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
You’ve added a new filter to filter your Sales Category on your PivotTable. When you go to use it, you notice that you can only filter by a single category, but you’d like to select Bottled Beer, Canned Beer and Draft Beer. How can you fix this?
Click the “Select Multiple Items” checkbox at the bottom of the filter window
Go to PivotTable Options > Totals & Filters > Check the “Select Multiple Items” box
Hold down the CTRL key and select the additional categories
Don’t know
2
Intermediate
Assume you had a PivotTable filtered as shown below, and you wanted to select only the Canned Beer category. What would be the most efficient method to do so?
Check “Canned Beer” and uncheck all the other items
Uncheck the “Select Multiple Items” checkbox, then select Canned Beer
Check the “(All)” checkbox, uncheck the “(All)” checkbox, and select the “Canned Beer” checkbox
Don’t know
3
Intermediate
What steps would you need to take to set up your filters to appear as shown below, providing you’d added them to your report filters area in the following order: Category, Class, Week, POSChitHour and POSChitMinute?
Go to PivotTable Options and choose to display field “Down, Then Over”, using 2 report filter fields per column
Go to PivotTable Options and choose to display field “Over, Then Down”, using 3 report filter fields per row
Manually drag the filter fields to the location you want to see them
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement