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

