Page 84 - PlusGPT_V2.1_C7_Flipbook
P. 84

Perform the following steps to assign a name to a cell range:
                  Step 1:   Select  the  range of cells to  which you  want to

                           assign a name.
                  Step 2:  Click on the Formulas tab from the Ribbon.
                  Step 3:   Click  on the  Define Name command  under the

                           Define Name 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.                          Cell range selected












                                       New Name dialog box                 Naming cell range

                  Now, we can use this name in place of 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 cases, 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 then press ENTER
                  key. 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.









                                               Using cell reference        After changing value
                  Cell references  are especially  helpful in case  of complex  formulas. There are three  types  of cell
                  references used in Excel: relative, absolute and mixed.


                       Relative References
                  By default, all cell references are relative references. When copied across multiple cells, they change
                  based  on the relative position  of rows  and columns. When a formula that  possesses  a relative
                  reference is copied from one cell to another cell, the value of the relative references in the copied cell
                  also changes.



                  82    Premium Edition-VII
   79   80   81   82   83   84   85   86   87   88   89