Page 19 - iPro_trackGPT_V5_Class8
P. 19
By Using the Shift Key
To select a cell range by using the Shift key, follow the given steps:
2 Press and
1 Click on
hold the Shift
the cell from
key and click
which you
on the cell up
want to start
to which you
the range.
want to make
the selection.
The cell range is selected once the Shift key is released.
Naming a Cell Range
Excel allow you to assign a name to a cell or a range of cells. This name can then be used in
formulas instead of cell addresses, making formulas easier to read and manage.
The steps to naming a cell range are as follows:
2 Click on the Formulas tab. 3 Click on the Define Name command.
4 Type the name
in the Name box.
1 Select the range
of cells to which
you want to assign
a name.
5 Click on the OK button.
The moon highlights different
aspects at different times, much
like filtering focuses on specific
data subsets.
Now, we can use this name in place of the cell address in formulas.
DIFFERENT WAYS TO ENTER FORMULAS
There are two main ways to add a formula to a worksheet:
Enter the Formula Directly into the Cell: You can enter the formula directly into a cell by
typing an equal sign (=) and then enter the formula you want to use.
Spreadsheet—Functions and Charts 17

