Page 18 - iprime_V2.2_class8
P. 18
2 Spreadsheet—
Functions and Charts
Chapter Profile
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 learned in the previous class that formulas are used to perform calculations. In this chapter,
we will explore different ways to add formulas to a worksheet, various types of built-in functions,
different types of charts, and 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. You can use a
cell range to perform calculations 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 you select the
cells from B2 to E3, then the address of the range will be B2:E3.
Selecting a Range in a Worksheet
You can select a range by using the mouse or the Shift key.
By Using the Mouse
Follow these steps to select a range by using the mouse:
Step 1 Click on the first cell where you want to start the range.
Step 2 Press and hold the left mouse button, then drag the mouse diagonally to select the desired range.
Step 3 Release the mouse button on the cell where you want the range to end.
Cell Range Selected by using Mouse
16 iPRIME (Ver. 2.2)–VIII

