Answered step by step
Verified Expert Solution
Question
1 Approved Answer
year. She decides to create a PivotTable to better manipulate and filter the student group data. Switch to the Academic PivotTable worksheet, then create a
year. She decides to create a PivotTable to better manipulate and filter the student group data.
Switch to the Academic PivotTable worksheet, then create a PivotTable in cell A based on the AcademicGroups table. Update the PivotTable as follows so that it matches Final Figure :
a Change the PivotTable name to: AcademicPivotTable
b Add the Activities field and the Group Name field in that order to the Rows area.
c Add the and fields in that order to the Values area.
d Change the display of subtotals to Show all Subtotals at Top of Group.
e Change the report layout to Show in Outline Form.
f Update the Sum of field in the Values area to display the name Membership with the Number number format with decimal places.
g Update the Sum of field in the Values area to display the name Membership with the Number number format with decimal places.
h Update the Sum of field in the Values area to display the name Membership with the Number number format with decimal places.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started