Question: PivotTable Analyses Use the event data on the Past Events worksheet ( range A 3 :G 1 0 3 ) to construct a PivotTable to
PivotTable Analyses
Use the event data on the Past Events worksheet range A:G to construct a PivotTable to calculate how much more total food sales have been generated at both Concerts and Sporting
Events than Other Events in the sample. Place the PivotTable on a new worksheet. Use Type as a Row Label and an appropriate presentation of Food as the Values field for the PivotTable. Rename the new worksheet PT points
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
