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

