Page 45 - TP_Modular_V2.1_Class7
P. 45
Selecting Range in a Worksheet
We can select a range by using the mouse and by using the Shift key.
By using the Mouse
Perform the following steps to select a range by using the mouse:
Step 1 Click on the first cell from which you want to start selecting the range.
Step 2 Press and hold-down the left mouse button and drag the
mouse diagonally to select the desired range.
Step 3 Release the mouse button on the cell up to which you
want to select the range. The range gets selected.
By using the Shift Key Cell range selected by mouse
Perform the following steps to select a range by using the Shift key:
Step 1 Click on the first cell from which you want to start selecting the range.
Step 2 Press and hold the Shift key down from the keyboard and click on the last cell up to
which you want to make selection.
Step 3 Release the Shift key. The range gets selected.
Naming a Cell Range
Excel 2016 allows us to assign a name to a cell range. This
name can be used in place of cell address in formulas.
Perform the following steps to assign a name to a cell
range:
Step 1 Select the range of cells to which you want to
assign a name.
Step 2 Click on the Formulas tab from the Ribbon.
Step 3 Click on the Define Name command under the
Define Name group. The New Name dialog
Cell range selected
box appears.
Step 4 Type the name and click on the OK button. The assigned name appears in the Name
box.
New Name dialog box Naming cell range
Now, we can use this name in place of cell address in formulas.
CELL REFERENCING IN FORMULAS AND ITS TYPES
A cell reference is a cell address that can be used in a formula to denote a specific cell. A
formula may contain reference of other cells. In such cases, the result of a formula depends on
the values in the referenced cells. In case you make any change in the referenced cells, the result
will automatically be changed.
Formulas and Functions 43

