Microsoft Office Tutorials and References
In Depth Information
To Enter Numbers
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
Northeast
Southeast
Midwest
South
West
Video
66145.15
79677.10
34657.66
52517.20
99455.49
Mini
31375.24
82937.72
66137.50
30681.82
43595.24
Micro
27596.37
92716.32
88294.78
87984.79
83380.72
Flash
27885.59
98800.57
24111.33
69737.51
51003.09
Accessories
9715.12
31284.20
66527.37
40374.83
46321.88
The following steps enter the numbers in Table 1–1 one row at a time.
1
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 for-
matted to use dollar signs, commas,
and trailing zeros to improve the appearance and readability of the numbers.
C4 is active cell
66145.15
entered
in cell B4
Figure 1–29
2
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
numbers
right-aligned
in cells
Figure 1–30
 
 
Search JabSto ::




Custom Search