Question: Excel Problem Objective Create pivot tables for what if analysis Required

Excel Problem*
Objective: Create pivot tables for what-if analysis.

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

Sale on SolutionInn
  • CreatedDecember 19, 2014
  • Files Included
Post your question