Excel Slicers Quiz
3 Questions
0 Views

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)

More Like This

Test Your Excel Skills
3 questions

Test Your Excel Skills

TrustworthyCarnelian avatar
TrustworthyCarnelian
Excel 3 Flashcards
23 questions

Excel 3 Flashcards

ExceedingSodalite avatar
ExceedingSodalite
Excel Flashcards: Formatting Basics
84 questions
Use Quizgecko on...
Browser
Browser