Page 213 - CA_165_V2.0_C9_Flipbook
P. 213

For naming a cell, click on the cell and type the name for that cell in the name box, and press Enter key.
                 Name can be used directly in a formula.
                 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




                                                                                                Data Analysis    211
   208   209   210   211   212   213   214   215   216   217   218