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

