Page 49 - TP_Prime_v2.2_Class_6
P. 49
Understanding Cell Range
A group of selected cells is called a cell 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. FORMULAS AND FUNCTIONS IN EXCEL
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 Keyboard.
By using the Mouse
Perform the following steps to select a range by using the mouse: 47
Step 1: Click on the first cell from which you want to start the range.
Step 2: Press and hold 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. Cell Range Selected by Mouse
By using the Shift Key
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 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 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.

