Microsoft Office Tutorials and References
In Depth Information
EX 88
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
Wrapping Text
If you have a long
text entry, such as a
paragraph, you can
instruct Excel to wrap the
text in a cell, rather than
pressing ALT + ENTER to
end a line. To wrap text,
right-click in the cell,
click Format Cells on the
Alignment tab, and then
click Wrap text. Excel
will increase the height
of the cell automatically
will ﬁ t. If you want to
control where each line
ends in the cell, rather
than letting Excel wrap
based on the cell width,
however, then you
must end each line with
ALT + ENTER .
3 In cell C3, type Date and then press al t + ent er . Type Acquired and then press the right
arrow key.
4 In cell D3, type Shares and then press the right arrow key.
5 In cell E3, type Initial and then press al t + ent er . Type Price and then press al t + ent er .
Type Per Share and then press the right arrow key.
6 Type Initial in cell F3 and then press al t + ent er . Type Cost and then press the RIGHT
ARROW key .
7 In cell G3, type Current and then press al t + ent er . Type Price and then press al t + ent er .
Type Per Share and then press the right arrow key.
8 Type Current in cell H3 and then press al t + ent er . Type Value and then press the RIGHT
ARROW key .
9 In cell I3, type Gain/Loss and then press the right arrow key.
10 In cell J3, type Percent and then press al t + ent er . Type Gain/Loss .
To Enter the Portfolio Summary Data
Two-Digit Years
When you enter a
two-digit year value,
Excel changes a
twodigit year less than 30
to 20xx and a two-digit
year of 30 and greater
to 19xx. Use four-digit
years to ensure that Excel
interprets year values
the way you intend, if
necessary.
The portfolio summary data in Table 2–1 includes a purchase date for each stock.
Excel considers a date to be a number and, therefore, it displays the date right-aligned in
the cell. The following steps enter the portfolio summary data shown in Table 2–1.
1 Select cell A4, type Apple Computers , and then press the RIGHT ARROW key.
2 Type AAPL in cell B4 and then press the right arrow key.
3 Type 12/1/04 in cell C4 and then press the right arrow key.
4 Type 440 in cell D4 and then press the right arrow key.
5 Type 64.59 in cell E4 and then click cell G4.
6 Type 82.99 in cell G4 and then click cell A5.
7 Enter the portfolio summary data in Table 2–1 for the eight remaining stocks in rows 5
through 12 (Figure 2–4).
To Enter the Row Titles
Formatting a
Worksheet
With early worksheet
programs, users often
skipped rows to improve
the appearance of the
worksheet. With Excel it
is not necessary to skip
rows because you can
increase row heights to
information.
1 Select cell A13. Type Totals and then press the down arrow key. Type Average in
cell A14 and then press the down arrow key.
2 Type Highest in cell A15 and then press the down arrow key. Type Lowest in cell A16
and then press the ent er key. Select cell F4.
C6161_EXC_02.4c.indd 88
C6161_EXC_02.4c.indd 88
3/6/07 3:28:06 PM
3/6/07 3:28:06 PM

Search JabSto ::

Custom Search