Latest:
LinkedIn Microsoft Excel Certification 

How would you connect the slicer to both PivotTables?

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

You May Also Like

An .xlsx workbook is saved into .csv format. What is preserved in the new .csv file?

Editorial Staff 0

Which of these functions returns the largest value within the range H2:H30?

Editorial Staff 0

Which format setting does not change the background appearance of a cell?

Editorial Staff 0