Page 19 - iprime_V2.2_class8
P. 19

By Using the Shift Key

                 Follow these steps to select a range using the Shift key:
                 Step 1  Click on the first cell where you want to start the range.

                 Step 2  Press and hold the Shift key on the keyboard and then click on the last cell where you
                         want to end the selection.

                 Step 3  Release the Shift key. The range will be selected.
                 Naming a Cell Range

                 Excel allows you 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:

                 Step 1  Select the range of cells you want to name.
                 Step 2  Click on the Formulas tab on the Ribbon.

                 Step 3  Click on the Define Name command in the Defined Names group.






















                                                          Cell Range Selected
                         The New Name dialog box appears.

                 Step 4  Type the desired name for the range in the Name text box.
                 Step 5   Click on the OK button.
                         The assigned name will appear in the Name box.
















                                New Name Dialog Box                        Naming Cell Range
                 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