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. (You can find the article online by going to www.aicpa.org and following the links to Online Journal of Accountancy.)

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 the other three sales¬ people are in sales group 2. Print out a report that shows monthly sales for each group.