Explore BrainMass

Analyzing Information Systems Using Excel Pivot Table Option

Please see the attached files.


Solution Preview

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 ...

Solution Summary

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.