Unformatted text preview: a. IDENITFY (Highlight) the top 3 age/income groups that have the Highest Average Spend per Visit (use the “fill color” icon) b. IDENTIFY (Highlight) the bottom 3 age/income groups that have the Lowest Average Spend per Visit (use the “fill color” icon) c. Put a legend in the document that showcases your colors & contents d. Record BOTH sets of observations/facts into the Word Document Answer Template (Task 5) 6. Print Setup (for the Pivot Table) a. Make it print on one single sheet of paper (portrait) 1x1 b. Header: Date in Left, an Appropriate Title in the Center and YOUR name on the left c. Center Horizontally 7. Rename this Pivot Table worksheet tab to be AvgRevenuePerVisitByIncome&AgeGroup 8. Save the file so as to not lose any of your hard work Once finished, PRINT this is as Deliverable 3....
View Full Document
- Fall '08