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

