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
Previous

Leave a Reply