Page 20 - iPlus_Ver_2.0_class_8
P. 20
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 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.
i + CELL REFERENCING IN FORMULAS AND ITS TYPES
A cell reference refers to a cell or a range of cells on a worksheet that can be used to find the
values or data. The main benefit of using a cell reference is when the data present in referenced
cell(s) in another worksheet changes, a value returned by the cell reference is automatically
updated.
18
iPlus (Ver. 2.0)-VIII

