Page 39 - Plus_V2.2_C6_Flipbook
P. 39

DIFFERENT WAYS TO ENTER A FORMULA


                 There are mainly two ways to enter a formula in a worksheet:
                    Typing the formula directly in the Cell: In this way, the
                   formula is directly typed in the cell after typing an equal
                   sign as follows:
                    After entering the formula in the cell, press the Enter               Formula in cell
                   key. When the Enter key is pressed, result of the formula
                   appears in the cell.

                    Typing the formula in the Formula bar: In this way, we
                   can type the formula in Formula bar after selecting the
                   cell as follows:                                                           Output
                 After entering the formula, when we press the Enter key from

                 the keyboard. The result will appear.

                        UNDERSTANDING CELL RANGE



                 A group of selected cells is called a cell range. The selected         Formula in Formula bar
                 cells should be in continuation to form a range. When a range is selected in a worksheet, a rectangular
                 shape is formed. We can use a cell range 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 E3 then the address of the range will be B2:E3.
                      Selecting a Range in a Worksheet


                 We can select a range by using the mouse and 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 the left mouse button and drag           Cell range selected by mouse
                         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.

                 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.

                                                                               Formulas and Functions in Excel 2016  37
   34   35   36   37   38   39   40   41   42   43   44