Podcast
Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App
Questions and Answers
Which of the following statements about Slicers in Excel 2016 is true?
Which of the following statements about Slicers in Excel 2016 is true?
- Clicking an item in a Slicer removes it from the PivotTable (correct)
- Clicking a selected value in a Slicer removes it from the filter
- Values displayed in light gray or white appear in the PivotTable
- Shift and Ctrl keys cannot be used to help define selections in a Slicer
What happens when you click a value in a Slicer in Excel 2016?
What happens when you click a value in a Slicer in Excel 2016?
- It hides the value in the PivotTable
- It removes the value from the filter
- It changes the color of the value in the PivotTable
- It creates a filter that limits the data displayed to only that value (correct)
What should you do if you want to display values related to multiple items in a Slicer in Excel 2016?
What should you do if you want to display values related to multiple items in a Slicer in Excel 2016?
- Click each item one by one to display their values
- Use the Ctrl key to select multiple items
- Use the Shift key to select multiple items
- Click the Multi-Select button on the Slicer’s title bar (correct)
Flashcards are hidden until you start studying
Study Notes
Slicers in Excel 2016
- When you click a value in a Slicer, it filters the data to show only the records related to the selected value.
- To display values related to multiple items in a Slicer, hold down the Ctrl key while selecting the items.
- This allows you to select multiple items in a Slicer and display all related data in the report.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
