Comma Training Page 54

Enter the Data

What goes into each basket of fruit? The items will be listed in Column A. The costs will be entered in Column B.

2. Try This: Enter the Items

Select Cell A2 and type: Apples.

Select Cell A3 and type: Basket.

Select Cell A4 and type: Bow.

Select Cell A5 and type: Box.

3. Try This, Too: Enter the Cost

Enter some sample numbers:
Cell B2: 2.50
Cell B3: 3.75
Cell B4: 1.00
Cell B5: 1.25

4. And Try This: Format the Cost

Select Column B.

Go to Home -> Number ->Accounting. ($) to format these numbers as dollars and cents.

Memo to self: Technically, just clicking the dollar sign ($) formats the numbers as Accounting. Accounting has a static dollar sign instead of a floating symbol.