Microsoft Office Tutorials and References

In Depth Information

**Session 1.2**

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

1.
A(n)

Review

is the place on the worksheet where a column and row

intersect.

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.

a. 11/09/2006

b. Net Income

c. 321

d. C11*225

e. 201-19-1121

f. =D1-D9

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.

Session 1.2

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.