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
Advanced
You have the following PivotChart, and would rather use slicers than the ugly filter buttons. How would you remove the filter buttons?
Select the PivotChart and go to PivotChart Tools > Analyze > Field Buttons > Hide All
Select each of them and press the DEL key
Select the PivotChart and go to PivotChart Tools > Format > Field Buttons > Hide All
Don’t know
2
Advanced
You create a nice PivotTable, and then create a PivotChart based on that PivotTable. After spending a long time getting the formatting customized to be just right, you send it off to a user. That users adds a new field to the PivotTable Values area. What happens to the PivotChart you worked so hard on?
It is immediately updated to include the new series
Nothing unless you explicitly modify the PivotChart to add the data
Nothing immediately. The data is added to the PivotChart the next time the PivotTable is refreshed
Don’t know
3
Advanced
When building a dashboard that uses multiple PivotTables and PivotCharts, what do you need to do to keep them all in sync?
Add slicers for filtering, and link them to each PivotTable and PivotChart used in the dashboard
All PivotCharts must be built against the same PivotTable to keep them in sync
Add slicers for filtering, and link them to each PivotTable used in the dashboard
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement