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
Assume you have two PivotTables (Sales and Inventory) which both include the “Product Size” field. You’d like to give your end user the option to filter the PivotTable to only select product of a specific size, but want to keep both tables filtered by the same sizes. How would you do this?
Go to PivotTable Options > Totals & Filters > Report Connections
Select a cell in the Sales pivot, add a slicer for Product Size. Ensuring a cell is selected in the Sales Pivot, go to the PivotTable Tools > Analyze (Options in Excel 2010) > Filter Connections and link the PivotTable to the slicer
Select a cell in the Sales pivot, add a slicer for Product Size, select it, go to the Slicer Tools tab > Report Connections and link it to both PivotTables
Don’t know
2
Advanced
Assume you created two PivotTables: Sales is in columns A:B and Inventory is in columns D:E, as shown below. You’d like to keep both tables filtered to the same category, so you select E2 and type =B2. What would you expect to happen when you try to commit the formula?
The reports would link and stay in sync
You would receive an error as you’re not permitted to type into a Report Filter cell on the worksheet
You would receive an error as you’re not permitted to link two report filters in this way
Don’t know
3
Advanced
Assume you’ve got the Sales PivotTable (on the left) and the Inventory PivotTable (on the right) linked to the Category slicer as shown below. You then decide you only want the slicer linked to the Sales table (on the left). How would you correct this?
Select the Slicer > Slicer Tools > Report Connections > uncheck the box next to the Inventory PivotTable
Select a cell in the Inventory PivotTable > Right-click the slicer > Unlink from PivotTable
Select a cell in the Sales PivotTable > PivotTable Tools > Analyze (Options in Excel 2010) > Filter Connections > Uncheck the Slicer
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement