Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 12 - 2607_Trackpad_Pro_5.1_flipbook_C6
P. 12

    21 st
                                                                                Century   #Leadership & Responsibility
                                                                                  Skills
                                                                             “Always Enter a formula as per
                                                                             BODMAS rule for accurate result.”

                                 CELL RANGE

                      A group of selected cells is called a cell range. The selected cells should be in continuation to form
                      a range. A cell range is used to perform a calculation on multiple cells. The address of a range
                      is created by using the starting and the ending cell addresses separated by a colon (:) sign. For
                      example, if we have selected the cells from B2 to E4, then the address of the range will be B2:E4.

                      SELECTING A CELL RANGE
                      We can select a range by using the mouse and by using the Shift key.

                      By using the mouse
                      Click in the first cell from which you want to start the
                      range, then press and hold the left mouse button and
                      drag the mouse diagonally to select the desired range.
                      Now release the mouse button.

                      By using the Shift key

                      Click on the first cell from which you want to start
                      the range, then press and hold the Shift key on the
                      keyboard and click on the last cell that you want to
                      include in the selection. Now release the Shift key.

                                CELL REFERENCE

                      A cell reference is a cell address that can be used in a formula to denote a specific cell. A formula
                      may contain reference to other cells. In such a case, the result of a formula depends on the values
                      in the referenced cells. Cell references are especially helpful when you create complex formulas.
                      There are three types of cell references used in Excel: Relative, Absolute and Mixed.

                      RELATIVE CELL REFERENCING
                                                                                                     To calculate total of
                      In relative cell reference, you actually refer to the cell that is above       adjacent cells:
                      or below and left or right to a number of rows or columns. When a
                      formula is copied to a new location in a worksheet, the value in the       Short key
                      copied cell also changes.                                                         Alt    +    =

                       10   Premium Edition-VI

| 7 8 9 10 11 12 13 14 15 16 17 |