Page 39 - ModularV1.1 _c7_flipbook
P. 39

Selecting a Range in a Worksheet

                 We can select a range by using the mouse or by using the Shift key.
                 By using the Mouse

                 Perform the following steps to select a range by using the mouse:
                 Step 1  Click on the first cell from which you want to start the range.
                 Step 2  Press and hold-down the left mouse button and drag the
                         mouse diagonally to select the desired range.
                 Step 3  Release the mouse button on the cell up to which you
                         want to select the range. The range gets selected.
                                                                                         Cell range selected by mouse
                 By using the Shift Key

                 Perform the following steps to select a range by using the Shift key:
                 Step 1  Click on the first cell from which you want to start the range.

                 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

                 MS 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 from the Ribbon.
                 Step 3  Click on the Define Name command under the
                         Defined Names group. The New Name dialog
                                                                                         Cell range selected
                         box appears.
                 Step 4  Type the name and click on the OK button. The assigned name appears in the Name box.













                                   New Name dialog box                      Naming cell range
                 Now, we can use this name in place of 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 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  37
   34   35   36   37   38   39   40   41   42   43   44