Page 19 - TP_iPlus_V2.1_Class8
P. 19

By Using the Shift Key

                 To select a range by using the Shift key, follow the given steps:



                             1  Click on
                             the cell from
                             which you
                             want to start
                             the range.



                                               2  Press and hold the Shift key and click on the cell up
                                              to which you want to make the selection.

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


                     2  Click on the Formulas tab.     3  Click on the Define Name command.       4  Type the name.

















                                                                                         5  Click on the OK button.



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

















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







                                                                                                                  17
                                                                              Spreadsheet—Functions and Charts
   14   15   16   17   18   19   20   21   22   23   24