Page 18 - iPro_trackGPT_V5_Class8
P. 18

Spreadsheet—                                                    2


                       Functions and Charts











                      Goal Glimpse

                          Understanding Cell Range                        Different Ways to Enter Formulas

                          Cell Referencing in Formulas and its Types      Customise Worksheet Tab
                          Functions                                       Charts in Excel

                          Sorting Data




                  In the previous class, we have learnt that formulas help us do calculations. In this chapter, we
                  will explore formulas in more detail and learn about the different ways to add a formula to
                  worksheets. We will also learn about the different types of built-in functions and types of charts.
                  We will also learn about how to sort data in Excel.

                     UNDERSTANDING CELL RANGE
                  A cell range refers to a group of cells selected together in a worksheet. These cells must be
                  adjacent to one another, forming a rectangular shape when selected. Using a cell range allows
                  you to perform calculations on multiple cells simultaneously, which simplifies data management.
                  The address of a cell range is specified by noting the starting and ending cell addresses, separated
                  by a colon (:). For example, if the range includes cells from B2 to E3, it is written as B2:E3.

                  Selecting a Range in a Worksheet

                  A cell range can be selected either by using the mouse or by holding down the Shift key.
                  By Using the Mouse

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




                      1  Click on
                      the cell from
                      which you                                                                 2  Drag and drop the
                      want to start                                                             left mouse button to
                      the range.                                                                the ending cell of the
                                                                                                range.






                    16    TrackGPT iPRO (V5.0)-VIII
   13   14   15   16   17   18   19   20   21   22   23