Page 40 - Plus_V2.2_C6_Flipbook
P. 40

Naming a Cell Range


                  Excel allows us to assign a name to a cell range. This name can be used in place of cell address in
                  formulas. 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 Defined Names group. The New Name dialog
                          box appears.
                  Step 4:  Type the name and click on the OK button. The assigned name gets appear 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 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.











                                                            Using cell reference

                  38    Premium Edition-VI
   35   36   37   38   39   40   41   42   43   44   45