Page 39 - TP_Pluse_V2.2_Class_6
P. 39

Step 2:   Press and hold the Shift key down from the keyboard and click on the last cell up to which
                         you want to make selection.

                 Step 3:  Release the Shift key. The range gets selected.

                      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.
                 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.





















                                                             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.



                                                                               Formulas and Functions in Excel 2016  37
   34   35   36   37   38   39   40   41   42   43   44