Microsoft Office Tutorials and References
In Depth Information
To Enter Numbers
The Walk and Rock Music First Quarter Rock-It MP3 Sales numbers used in Chapter 1 are summarized in
Table 1–1. These numbers, which represent sales revenue for each of the product types and regions, must be entered
in rows 4, 5, 6, 7, and 8.
Table 1–1 Walk and Rock Music First Quarter Rock-It MP3 Sales
The following steps enter the numbers in Table 1–1 one row at a time.
• Click cell B4.
• Type 66145.15 and then press the
RIGHT ARROW key to enter the
data in cell B4 and make cell C4
the active cell (Figure 1–29).
Do I need to enter dollar signs,
commas, or trailing zeros for the
quarterly sales numbers?
You are not required to type dollar
signs, commas, or trailing zeros.
When you enter a dollar value that
has cents, however, you must add
the decimal point and the numbers
representing the cents. Later in this
chapter, the numbers will be
formatted to use dollar signs, commas,
and trailing zeros to improve the appearance and readability of the numbers.
in cell B4
• Enter 79677.1 in cell C4, 34657.66
in cell D4, 52517.2 in cell E4, and
99455.49 in cell F4 (Figure 1–30).
quarterly sales for
Video product type
entered in row 4