Page 19 - Trackpad_ipro 4.1_Class8
P. 19

By Using the Shift Key

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


                                                                                                    2  Press and
                                                                                                   hold the Shift
                       1  Click on
                                                                                                   key and click
                      the first cell                                                               on the last
                      from which                                                                   cell up to
                      you want                                                                     which you
                      to start the                                                                 want to make
                      range.                                                                       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 instead of the cell address
                 in formulas. Follow these steps to assign a name to a cell range:


                            2  Click on the Formulas tab.               3  Click on the Define 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.




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