Page 46 - modular4.0
P. 46
Chapter Profile
UNDERSTANDING CELL RANGE
A group of selected cells is called a range. The selected cells should be in continuation to form a
range. When a range is selected in a worksheet, a rectangular shape is formed. We can use a cell
range to perform a calculation on multiple cells. The address of a range is created by using the
starting and the ending cell addresses separated by a colon (:) sign. For example, if we have selected
the cells from B2 to E3 then the address of the range will be B2:E3.
Selecting a Range in a Worksheet
We can select a range by using the mouse and by using the Shift key. Perform the following steps
to select a range:
2 Press and hold the left
1 Click on the first
cell from which you mouse button and drag
want to start the the mouse diagonally or
range. hold the Shift key and
click on the last cell to
select the desired range.
The range gets selected.
Naming a Cell Range
Excel 2019 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:
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 cell address in formulas.
44 Modular (Ver. 4.0)-VII

