Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 25 - 2615_KEC
P. 25

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

                     For example,  a formula (=A2*B2)  placed  in cell C2  multiplies  the

                     values of cells A2 and B2. As we press the Enter key, the result of the
                     multiplication of values in A2 and B2 is displayed in cell C2.
                     If we copy the formula (=A2*B2) in cell C3, then the cell references in the formula (=A2*B2) change

                     in relation to the new location of the formula, and the result is displayed according to the changed
                     cell reference.

                                                                                                After copying and pasting
                                                                                                 the formula in cell C3,
                                                                                                   cell references are
                                                                                                 automatically adjusted.
                                         Result of formula
                                        (=A2*B2) in cell C2

                                                                                     Formulas and Functions in Excel 2021  23

| 20 21 22 23 24 25 26 27 28 29 30 |