Microsoft Office Tutorials and References
In Depth Information
Sandra has some other changes to the workbook that she wants you to make. You’ll
continue working with the worksheet in the next session.
Session 1.1 Quick Check
is the place on the worksheet where a column and row
2. Cell refers to the intersection of the fourth column and second row.
3. What combination of keys can you press to make A1 the active cell in the worksheet?
4. To make Sheet2 the active worksheet, you .
5. Indicate whether Excel treats the following cell entries as text, a value, or a formula.
b. Net Income
g. 44 Evans Avenue
6. How do you enter multiple lines of text within a cell?
7. What formula would you enter to divide the value in cell E5 by the value in cell E6?
To reinforce the tasks you
learned in this session, go
to the SAM 2003 Training
Companion CD included
with this text.
Working with Ranges
Sandra has had a chance to study your work from the previous session. She likes the lay-
out of her data, but she wants to have a title at the top of the worksheet that displays infor-
mation about the sheet’s contents. To make room for the title, you have to move the
contents of the worksheet down a few rows. Before you attempt that, you have to first
understand how Excel works with groups of cells.
A group of worksheet cells is called a cell range , or just range . Ranges can be either
adjacent or nonadjacent. An adjacent range is a single rectangular block, such as all of
the data entered in cells A1 through G5 of the Dalton workbook. A nonadjacent range
consists of two or more separate adjacent ranges. For example, a nonadjacent range might
be composed of the names of the customers in the cell range A1 through A5 and the total
price of their orders in the cell range G1 through G5.
Just as a cell reference indicates the location of a cell on the worksheet, a range
reference indicates the location and size of a cell range. For adjacent ranges, the range
reference identifies the cells in the upper-left and lower-right corners of the rectangle,
with the individual cell references separated by a colon. For example, the range refer-
ence for the order data you entered in the last session was A1:G5 because it included the
range of cells from A1 through G5. If the range is nonadjacent, a semicolon separates the
rectangular blocks A1:A5 and G1:G5, as in A1:A5;G1:G5. This nonadjacent range refer-
ences the customer names in the range A1:A5 and the total amounts of their orders in
the range G1:G5.
For hands-on practice of
key tasks in this session,
go to the SAM 2003
Training Companion CD
included with this text.