Please see the attached files.
On formatting the Sales column in the Currency number, format with no decimal places:
Go to Format and click Cells. Click currency on the format tab. In the decimal place, type zero ...
The solution shows how to summarize and analyze the data using the spreadsheet Pivot Table option. The given data and solution are found in the attached spreadsheet file.