Page 70 - Computer Class 06

You can also select multiple cells at the same

time. A group of cells is known as a cell
range. Rather than a single cell address, you
will refer to a cell range using the cell

addresses of the first and last cells in the cell
range separated by a colon (:). For example,
a cell range that included cells G1, G2, G3,

G4 and G5 would be written as G1:G5 .
If the columns in the spreadsheet are labeled

with numbers instead of letters, you need to
change the default reference style for Excel.

Selecting Data

Working with a complete data set is a common task in Excel. You might want to move

the data, apply a filter or common format or convert the data to a table. There are
many reasons for selecting a data range, but doing so might require jumping through
a few selection hoops, especially if you are working with a large range that spans
several screens. Fortunately, there’s a quick and easy way to select an entire data

range.

Let us know about the selection process one-by- one.
Selecting a Cell

To select a cell, click on the cell. It will become the active cell and appear with a thick

black border.

Computer-6 70 Computer-1