Excel Slicers Quiz

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

Questions and Answers

What is the visual indication of an active filter in Excel 2013 and earlier versions?

  • A color change in the cells
  • A pop-up message
  • Slicers
  • A filter arrow indicator (correct)

What information did the filter arrow indicator provide in Excel 2013 and earlier versions?

  • Which values were selected for filtering
  • The type of filter applied
  • Which values were displayed and which were hidden (correct)
  • The total number of filtered values

What does the Insert Slicers dialog box allow you to do in Excel 2016?

  • Apply a filter to a field
  • View all hidden values in a PivotTable
  • Create a PivotTable
  • Select the data you want to filter (correct)

Flashcards are hidden until you start studying

More Like This

Test Your Excel Skills
3 questions

Test Your Excel Skills

TrustworthyCarnelian avatar
TrustworthyCarnelian
Excel Slicers Mastery Quiz
3 questions
Excel 3 Flashcards
23 questions

Excel 3 Flashcards

ExceedingSodalite avatar
ExceedingSodalite
Use Quizgecko on...
Browser
Browser