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

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 Flashcards: Formatting Basics
84 questions
Introducción a Microsoft Excel
20 questions
Use Quizgecko on...
Browser
Browser