How would you connect the slicer to both PivotTables?

  • 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

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock