Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
We have a PivotTable with the following configuration of fields: Class on Columns, Category and Item Name on Rows, and Amount on Values. Which options can we guarantee were changed from the default layout in order to display the PivotTable as shown below?
Subtotals have been set to “Show all Subtotals at Bottom of Group”, and grand totals have been set to “Off for Rows and Columns”
Subtotals have been set to “Show all Subtotals at Bottom of Group”, and grand totals have been changed from the default configuration
Grand totals have been set to “On for Columns Only”
Don’t know
2
Beginner
We have a PivotTable with the following configuration of fields: Hours on Rows, Class on Columns and Amount on Values. What can we guarantee is true in the following setup?
Subtotals have been set to “Show at Bottom of Group”
Grand totals have been set to “On for Rows Only”
Grand totals have been set to “On for Columns Only”
Don’t know
3
Beginner
How did the author manage to display both the Sum and Average of the Amount column in the following PivotTable?
They selected the value for the “Alcohol” subtotal, right-clicked and chose Value Field Settings, navigated to the Subtotals & Filters tab, selected Custom, and chose both Sum and Average
They went to PivotTable Tools > Design > Subtotals > Add Level > Average
They right-clicked “Alcohol”, chose Field Settings, navigated to the Subtotals & Filters tab, selected Custom, and chose both Sum and Average
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement