graphic1

Exam 77-428 Microsoft Excel 2013 EXPERT
2. Apply Custom Formats and Layouts
2.1 Apply Custom Data Formats: Create Custom Accounting Formats

Sum of Amount

8. Try it: Format the Data

Sum of Amount is money-sales data.

Select Column B.

Go to Home->Number.

Click on Accounting ($).

 

Select Column B, again.

Go to Home->Number.

Click on Decrease Decimals twice.

 
Try This, Too: Save the PivotTable

Go to File->Save As.

Name the workbook: MyName PivotCharts.

Save. Save. Save.

 

Very good.

Home ->Number

graphic2
 

graphic3