Excel Problem*

Objective: Create pivot tables for what-if analysis.

Required

Read the article “Make Excel an Instant Know-It-All” by Roberta Ann Jones in the March 2004 issue of the Journal of Accountancy (available at www.aicpa.org).

a. Follow the instructions in the article to create a spreadsheet with pivot tables.

b. Print out a report that shows sales by month for each salesperson.

c. Assume that Brown and David are in sales group 1 and that the other three salespeople are in sales group 2. Print out a report that shows monthly sales for each group.