Page 19 - TP_iPlus_V2.1_Class8
P. 19
By Using the Shift Key
To select a range by using the Shift key, follow the given steps:
1 Click on
the cell from
which you
want to start
the range.
2 Press and hold the Shift key and click on the cell up
to which you want to make the selection.
When the Shift key is released. The range gets selected.
Naming a Cell Range
Excel allows us to assign a name to a cell range. This name can be used in place of cell address
in formulas. To assign a name to a cell range, follow the given steps:
2 Click on the Formulas tab. 3 Click on the Define Name command. 4 Type the name.
5 Click on the OK button.
1 Select the range of cells to which
you want to assign a name.
Now, we can use this name in place of the cell address in formulas.
17
Spreadsheet—Functions and Charts

