Podcast
Questions and Answers
What is the visual indication of an active filter in Excel 2013 and earlier versions?
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?
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?
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)