Still Before You Begin...

2. Try it: Add Sample Data

Select Cell B2 and type: 2,850
Select Cell B3 and type: 8,180
Select Cell B4 and type: 21,470
Select Cell B5 and type: 1,050

 

Select Column D and format the numbers.

Go to Home->Numbers->Accounting.

Keep going...


Memo to Self: You can use the sample spreadsheet or enter your own data. If you use the sample spreadsheet, you can link the sales data to the spreadsheet called Sales Subtotal by Category,

Home->Numbers->Accounting

 

Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.1. Apply and modify cell formats