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
Intermediate
Suppose you’ve added a field containing numbers into the values area of a Pivot Table, but the display is not to your liking. Which is the best method to update the number format in the Pivot Table?
Right click the column on the Pivot Table, select Value Field Settings and then Numbers, and choose your preferred format there
Select the cells and format them from the Number group on the Home tab
Go to the Pivot Table Tools Design Tab and set the format under the Report Layout button
Don’t know
2
Intermediate
By default, Excel automatically adjusts column widths on a Pivot Table to fit the data. (This is to avoid seeing ### symbols when a number is too large to be displayed in the cell.) If you don’t want this to happen, how do you turn it off?
There is no way to turn it off
Right click the Pivot Table, choose Value Field Settings, and clear the “Autofit column widths on update” checkbox
Right click the Pivot Table, choose Pivot Table options, and clear the “Autofit column widths on update” checkbox
Don’t know
3
Intermediate
By default, Excel adds subtotals to Pivot Tables when value fields are added. How do you make subtotals appear at the bottom of the applicable groups?
Go to the Pivot Table Tools Design tab, and choose “Show all subtotals at bottom of group” from the Subtotals menu
Right click the label in the rows field on the Pivot Table and choose “Show all subtotals at bottom of group”
No actions are required, as sub-totals show up at the bottom of the group by default
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement