> > >

Excel MCQs

When you have many different PivotTables in one report, you can share a slicer that you created in one PivotTable with other PivotTables. Which of the following statements is not true?

Any changes that you make to a shared slicer are immediately reflected in all PivotTables that are connected to that slicer

When you share a slicer, you are creating a connection to another PivotTable that contains the slicer that you want to use

A PivotTable can have both local and shared slicers, you can enable this option under Slicer Settings

Any changes that you make to a shared slicer are immediately reflected in all PivotTables that are connected to that slicer

Answer

Correct Answer: A PivotTable can have both local and shared slicers, you can enable this option under Slicer Settings

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it