Question

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.



$1.99
Sales0
Views178
Comments0
  • CreatedDecember 19, 2014
  • Files Included
Post your question
5000