Pivot Table Homework Problems
R: 12/27/06 dld
With the source data (file: WesternRegional_DataSet_2.xls) referenced with the pivot table tutorial, answer the following questions:
1.
How much bicycle revenue did the Provo store receive in the month of October?
2.
How many bicycles did Provo sell in the month of October?
3.
What was the total revenue received from pajamas comprising all three months and all three stores?
4.
What percentage of Bicycle revenue was Candy revenue for the Orem store for all three months, how about shirts?
5.
a). What is the average sum of revenue received for snacks in San Jose for all three months? Hint: you can get the sum of the snack revenue in
the pivot table. Then you must divide the sum by the number of months (3) outside of the pivot table.
b). What is the average monthly snack revenue received for snacks in all three store? Hint: you can get the sum of the revenue amounts in the
pivot table and then you must divide the sum by 9 (3 months X 3 stores) outside of the pivot table.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Winter '08
 BALL
 Revenue, Sales

Click to edit the document details