LinkedIn Microsoft Excel Certification

How would you connect the slicer to both PivotTables?

October 29, 2022 Editorial Staff

You cannot use one slicer for two PivotTables.
Right-click the slicer and select Slicer Settings.
Merge the two PivotTables, right-click the merged PivotTable, and select Combine Slicer.
Right-click the slicer and select Report Connections, or click Report Connections on the Slicer tab.

The correct answer is:

Right-click the slicer and select Report Connections, or click Report Connections on the Slicer tab.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers