Page 19 - iPlus_Ver_2.0_class_8
P. 19

•  Typing the formula in the Formula bar: In this way, we can type the formula in the Formula
                    bar as follows:

























                    After entering the formula, when we press the Enter key on the keyboard, the result will
                    appear.


                  i +  UNDERSTANDING CELL RANGE

                 A group of cells is known as a cell range. A range comprises two or more selected cells and
                 those selected cells need not be adjacent to each other. A cell range consisting of adjacent
                 cells shows the cell addresses of the first and last cells in the cell range, separated by a colon (:)
                 sign.
                 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

                 To select a range by using the mouse, follow the given steps:

                                            1   Click  on  the  first  cell  from
                                           which you want to start the range.


















                                                               2  Drag and drop the left mouse
                                                              button to select the desired range.







                                                                                                                  17
                                                                              Spreadsheet—Functions and Charts
   14   15   16   17   18   19   20   21   22   23   24