Quizalize logo
placeholder image to represent content

Quiz - PivotTable

Quiz by Jamal Haider Naqvi

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    What is a pivot table?
    A table that summarizes data by grouping and aggregating it based on specific criteria
    A table that includes only filtered data
    A table that lists all the data in a spreadsheet
    A table that calculates the average of all the data
    30s
  • Q2
    What is a pivot filter?
    A feature that sorts data in a pivot table
    A feature that groups data in a pivot table
    A feature that allows you to filter data in a pivot table, based on specific criteria
    A feature that adds calculations to a pivot table
    30s
  • Q3
    Can you use multiple criteria to group data in a pivot table?
    Only if the criteria are in different fields
    Only if the criteria are in the same field
    No
    Yes
    30s
  • Q4

    The underlying data used by the pivot table does not change, but Excel changes the ways Excel displays the data.

    true
    false
    True or False
    30s
  • Q5

    You can use pivot tables to do queries, do multiple types of calculations, to organize data, to summarize data, and to create charts.

    true
    false
    True or False
    30s
  • Q6

    The pivot table is more dynamic than an ordinary Excel table.

    true
    false
    True or False
    30s
  • Q7

    How do you change the report layout of your pivot table (i.e. the display settings)?

    PivotTable Tools appear in the ribbon. Pick the Design tab. Under the Layout tab there is a Subtotals icon where you can choose report layout.

    None of above

    Place your cursor inside the data table. Then go to the Insert table and click Pivot Table. A dialogue box will appear: Choose report layout 

    Under the Design Tab, go to Report Layout in the Layout Group

    60s
  • Q8

    You can also select different kinds of charts: pie, line, bar, and area charts. Excel will notify you if certain chart types are inappropriate when using pivot tables.

    true
    false
    True or False
    30s
  • Q9

    Slicers are visual buttons used to apply filters to the data. They show tables with selective information.

    true
    false
    True or False
    30s
  • Q10

    Slicers :

    filter data.

    display pivot charts.

    sort data.

    import data.

    30s

Teachers give this quiz to your class