Page 50 - TP_Prime_v2.2_Class_6
P. 50

Step 3:   Click on the Define Name command under the Defined Names group. The New Name
                           dialog box appears.

                  Step 4:  Type the name and click on the OK button. The assigned name appears in the Name

                           box.




           Prime (Ver. 2.2)-VI















          48                                                Cell Range Selected
















                                  New Name Dialog Box                        Naming Cell Range
                  Now, we can use this name in place of the cell address in formulas.




                    Cell Referencing in Formulas and its Types


                  A cell reference is a cell address that can be used in a formula to denote a specific cell. A

                  formula may contain reference of other cells. In such a case, the result of a formula depends
                  on the values in the referenced cells. In case you make any change in the referenced cells,

                  the result will automatically be changed.

                  To see how this works:
                     Enter 10 in cell A1.

                      Now select cell A2 and type =A1*2, and press
                    the Enter key.                                                      Using Cell Reference

                  The value in cell A2 is 20. If you change the value in cell A1 from 10 to any value, the value

                  in cell A2 will also change.
   45   46   47   48   49   50   51   52   53   54   55