09.2_Pivot_Tables_Day_2_Problems

09.2_Pivot_Tables_Day_2_Problems - Pivot Table Homework...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Pivot Table Homework Problems R: 12/27/06 dld With the source data (file: Western-Regional_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. c). What is the average amount of a snack sale at San Jose? What is the average amount of a snack sale at all locations?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This homework help was uploaded on 04/17/2008 for the course ISYS 210 taught by Professor Ball during the Winter '08 term at BYU.

Page1 / 2

09.2_Pivot_Tables_Day_2_Problems - Pivot Table Homework...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online