Page 19 - Trackpad_ipro 4.1_Class8
P. 19
By Using the Shift Key
To select a range by using the Shift key, follow the given steps:
2 Press and
hold the Shift
1 Click on
key and click
the first cell on the last
from which cell up to
you want which you
to start the want to make
range. 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 instead of the cell address
in formulas. Follow these steps to assign a name to a cell range:
2 Click on the Formulas tab. 3 Click on the Define Name command.
1 Select the range of
cells to which you want
to assign a name.
4 Type the name.
5 Click on the OK button.
Now, we can use this name in place of the cell address in formulas.
Spreadsheet—Functions and Charts 17

