Page 18 - TP_iPlus_V2.1_Class8
P. 18

Spreadsheet—


                       Functions and Charts                                                2














                          Learning Outcomes


                              Understanding Cell Range                              Different Ways to Enter Formulas

                              Cell Referencing in Formulas and Its Types               Customise Worksheet Tab

                              Functions                                             Common Errors
                              Charts in Excel                                       Sorting Data





                  We have already learnt in the previous class that formulas are used to perform calculations.
                  In this chapter, we will learn more about formulas and different ways to add a formula in a
                  worksheet. We will also learn about different types of built-in functions, different types of charts,
                  and the sorting of data in Excel.

                   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
                                cell from which
                                you want to start
                                the range.



                                    2  Drag and drop the left mouse button to the ending cell of the range.





                    16
                         iPlus (Ver. 2.1)-VIII
   13   14   15   16   17   18   19   20   21   22   23