Page 199 - CA 165 ver 1.0 Class 9
P. 199

Consider a worksheet that has the following details:

                                 A                     B                 C                 D                 E

                  1   Name_of_Sales_Man           Sale_in_2015      Sale_in_2016      Sale_in_2017      Total_Sale

                  2   Kumar Narayan                  80000             80000             99000            259000

                 In the address bar assign the cell A1 as Name_of_Sales_Man, B1 as Sale_in_2015, C1 as Sale_in_2016, D1
                 as Sale_in_2017 and E1 as Total_Sale. Enter the value in the cell A2, B2, C2 and D2 as Kumar Narayan,
                 80000, 80000, 99000 respectively.

                 Now enter a formula in cell E2, say = B2 + C2 + D2
                 After pressing the Enter key, the output would get displayed as 259000 in cell E2.

                 Formula With In-Built Functions

                 Functions are in-built formula in ‘Calc’, which can be used to perform arithmetical and non-arithmetical
                 tasks. In ‘Calc’  there are more than 375 in-built functions which can be applied directly or as part of
                 a formula. For Example: A formula, say =A1+A2+A3+A4+A5 can be written using the ‘SUM’ function
                 along with cell range as: =SUM(A1:A5).

                 A function contains ‘Name’ and ‘Argument’.

                                                           =SUM(A1:A5)



                                                  Name                    Argument


                 ‘Name’ is the function that signifies the nature of operation. ‘Argument’ specifies the values or the range
                 of cells on which the specific operation is being applied and is always enclosed within the opening and
                 closing parenthesis (i.e., Name refers to the operator and Argument refers to the operand).

                           Notes

                           To apply a function on selected cells or on a range of cells, a semicolon (;) is used, i.e. for denoting
                           two cells A1 and A2, ‘A1;A2’ is applied.



                   CELL REFERENCING


                 The identification or address of a cell in a formula is known as a ‘Cell Reference’. There are three types
                 of referencing in ‘Calc’.
                 l  Relative Referencing             l  Absolute Referencing

                 l  Mixed Referencing

                 Relative Referencing
                 It is based on the position of the cell in which the formula is typed with respect to the cell address of the
                 formula. When we copy or move the formula to other cells, the reference (cell address) automatically
                 changes according to the relative position of cells in consideration.


                                                                                                Data Analysis    197
   194   195   196   197   198   199   200   201   202   203   204