Page 25 - Computer Genius Class 06
P. 25
Understanding Cell Range
group o selected cells is called a range. The selected cells should e in continuation to orm a
range. hen a range is selected in a or sheet a rectangular shape is ormed. e can use a cell
range to per orm a calculation on multiple cells. The address o a range is created y using the
starting and ending cell addresses separated y a colon sign. For e ample i e ha e selected the
cells rom 2 to then the address o the range ill e 2 .
Selecting a Range in a Worksheet
e can select a range y using the mouse and y using the hi t ey.
By using the Mouse
To select a range by using the mouse, follow the given steps:
1 Click on the first cell from which
you ant to start the range.
2 Drag and drop the left mouse
utton to select the desired range.
By using the Shift Key
To select a range by using the Shift key, follow the given steps:
1 Click on the first cell from which
you ant to start the range.
2 Press and hold the Shift key and click on the last
cell up to hich you ant to ma e the selection.
hen the hi t ey is released. The range gets selected.
Formulas and Functions in Excel 23

