Please see the attached files.© BrainMass Inc. brainmass.com August 15, 2018, 10:26 am ad1c9bdddf
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.