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.
*Life-long learning opportunity: see p. xxii in preface.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.