Home -> Number ->Accuonting

 

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.

 

This is a simple list of what goes into a fruit basket. In real life, you would need to list every item including shipping and handling.

 

Exam 77-882: Microsoft Excel 2010 Core

2. Creating Cell Data

2.1. Construct cell data: Format the Column for Currency