Page 83 - PlusGPT_V2.1_C7_Flipbook
P. 83

Formula in cell                      Output

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

                    will appear in the selected cell.
                                                                                             Formula in Formula bar

                        UNDERSTANDING CELL RANGE


                 A group of selected cells is called a range. The selected 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 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 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 selecting

                          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      Cell range selected by mouse
                          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 selecting 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

                 Excel 2016 allows us to assign a name to a cell range. This name can be used in place of cell address
                 in formulas.


                                                                                           Formulas and Functions  81
   78   79   80   81   82   83   84   85   86   87   88