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
How do you stop Pivot Tables from changing their column widths whenever the data is refreshed?
Right click any cell in the Pivot Table ⇒Pivot Table Options ⇒uncheck “autofit column widths on update”
Select any cell in the Pivot Table ⇒Pivot Table Tools ⇒Design ⇒uncheck Resize column on Update
Right click any cell in the Pivot Table ⇒Pivot Table Options ⇒check “preserve column widths on update”
Don’t know
2
Intermediate
You drag your Sales $ field onto a Pivot Table and it adds it under the name Sum of Sales $. What do you need to do in order to make it display as Sales $?
Change the name on the Pivot Table to Sales $ with a space after the $ sign
Right click the column and choose “reset”
Rename the column in the source data
Don’t know
3
Intermediate
Which Pivot Table layout is pictured below?
Outline Form with subtotals forced to the bottom
Tabular Form
Compact Form
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement