Page 18 - iprime_V2.2_class8
P. 18

2                                  Spreadsheet—






                                                      Functions and Charts








                           Chapter Profile
                             Understanding Cell Range                             Different Ways to Enter Formulas
                             Cell Referencing in Formulas and Its Types           Customise Worksheet Tab
                             Functions                                            Charts in Excel
                             Sorting Data


                  We learned in the previous class that formulas are used to perform calculations. In this chapter,
                  we will explore different ways to add formulas to a worksheet, various  types of built-in functions,
                  different types of charts, and sorting of data in Excel.


                      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. You can use a
                  cell range to perform calculations on multiple cells. The address of a range is created by using
                  the starting and ending cell addresses separated by a colon (:) sign. For example, if you select the
                  cells from B2 to E3, then the address of the range will be B2:E3.
                  Selecting a Range in a Worksheet

                  You can select a range by using the mouse or the Shift key.

                  By Using the Mouse

                  Follow these steps to select a range by using the mouse:
                  Step 1  Click on the first cell where you want to start the range.

                  Step 2  Press and hold the left mouse button, then drag the mouse diagonally to select the desired range.
                  Step 3  Release the mouse button on the cell where you want the range to end.













                                                    Cell Range Selected by using Mouse

                  16     iPRIME (Ver. 2.2)–VIII
   13   14   15   16   17   18   19   20   21   22   23