Page 18 - Trackpad_ipro 4.1_Class8
P. 18

Spreadsheet—Functions


                                     and Charts



                                                                                 Chapter
                                                                                 02







                             Your Aim

                             to learn about:
                                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 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.
                      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 a cell
                  range to perform a calculation 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 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

                  To select a range by              1  Click on the first cell from which
                  using the mouse,                 you want to start the range.
                  follow the given
                  steps:



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




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