Page 19 - iPlus_Ver_2.0_class_8
P. 19
• Typing the formula in the Formula bar: In this way, we can type the formula in the Formula
bar as follows:
After entering the formula, when we press the Enter key on the keyboard, the result will
appear.
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 first cell from
which you want to start the range.
2 Drag and drop the left mouse
button to select the desired range.
17
Spreadsheet—Functions and Charts

