Page 18 - iPlus_Ver_2.0_class_8
P. 18

Spreadsheet—



                       Functions and Charts
                                                                                           2













                          Learning Outcomes


                              Different Ways to Enter Formulas                      Understanding Cell Range

                              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 +  DIFFERENT WAYS TO ENTER FORMULAS

                  There are mainly two ways to enter a formula in a worksheet:
                  •  Typing the formula directly in the cell: In this way, the formula is directly typed in the cell
                     after typing an equal sign as follows:














                     After entering the formula in the cell, press the Enter key. When the Enter key is pressed, the
                     result of the formula will appear in the cell:












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