Practice Quiz
11. Before creating a pivot table, how should you format your data?
- Sort & filter
- As a table
- Conditional formatting
- Cell size
12. How can you add more filters to the pivot table?
- use a formula
- first add filters to the original table data
- use a function
- drag a field to the Filters area of the PivotTable Fields pane
13. What are slicers?
- on-screen graphical filter objects
- split pivot tables
- header filters
- standard filters
14. What do timelines provide in pivot tables?
- previews views of different filters
- lets you filter specifically on date-related data
- provides details of all actions performed during a given period
- sets the pivot table to an earlier view
Graded Quiz
15. According to the video checklist, what should you remove before making a Pivot Table?
- Row labels
- Value fields
- Date fields
- Blank rows, columns, and cells
16. What is automatically added after formatting data as a table?
- Alternate light/dark rows
- Column headers
- Filter drop-downs at top of columns
- Data bars
17. After creating a pivot table and selecting it, what pane appears to the right of the pivot table?
- The PivotTable Metadata pane
- The PivotTable Properties pane
- The PivotTable Fields pane
- Additional pivot table examples
18. What do Timelines provide in pivot tables?
- Lets you filter specifically on date-related data
- Sets the pivot table to an earlier view
- Provides details of all actions performed during a given period
- Previews views of different filters
19. What is one way to remove a slicer or timeline?
- Right-click it and select cut
- Create a new one
- Remove all filters from pivot table
- Press CTRL+Z