Page 26 - Digicode_AI_class_6
P. 26

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. To assign a name to a cell range, follow the given steps:


                                                  2  Click on the     3  Click on the Define
                                                  Formulas tab.       Name command.


























                                                    1   Select  the  range  of  cells  to  which
                                                    you want to assign a name.



                                               4  Type the name.





























                                             5  Click on the OK button.


            Now, we can use this name in place of the cell address in formulas.





                 24    DigiCode AI-VI
   21   22   23   24   25   26   27   28   29   30   31