placeholder image to represent content

Working with Excel Tables, PivotTables and PivotCharts

Quiz by Lisa DeCastillia

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

Correct quiz answers unlock more play!

New Quizalize solo game modes
12 questions
Show answers
  • Q1
    Excel assigns the name ____ to the first Excel table created in a workbook.
    1Table
    NewTable
    Table1
    1
    30s
  • Q2
    A table name cannot include ____.
    Letters
    Underscores
    Numbers
    Spaces
    30s
  • Q3
    ____ order arranges labels in reverse alphabetical order, from Z to A.
    Major
    Ascending
    Descending
    Reverse
    30s
  • Q4
    To add a sort field in the Sort dialog box, click the ____ button.
    Add field
    New sort field
    New level
    Add level
    30s
  • Q5
    The ____ condition requires that all of the selected criteria be true for the record to be displayed
    Or
    If
    And
    Nand
    30s
  • Q6
    The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.
    Aggregate
    Between
    Top 10
    Range
    30s
  • Q7
    You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.
    Home
    Table Tools Design
    View
    Table Tools Format
    30s
  • Q8
    The following is an example of a delimiter: _______.
    #
    period
    Tab
    $
    30s
  • Q9
    The following is an example of a delimiter: _______.
    Structured
    Trusted
    Relational
    Linked
    30s
  • Q10
    Which of the following is not a type of trendline?
    Linear
    Power
    Horizontal
    Exponentail
    30s
  • Q11
    The Power Pivot add-in provides access to the _________.
    Data model
    Diagram
    Database
    None of the above
    30s
  • Q12
    A __________ is a slicer that is applied to date fields.
    Timeline
    Scatter line
    PivotTable
    Trendline
    30s

Teachers give this quiz to your class