Working with Excel Tables, PivotTables and PivotCharts | Quizalize

placeholder image to represent content

Working with Excel Tables, PivotTables and PivotCharts

Quiz by Lisa DeCastillia

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
view complete results in the Gradebook and Mastery Dashboards
automatically assign follow-up activities based on students’ scores
assign as homework
share a link with colleagues
print as a bubble sheet

Q 1/12
Score 0
Excel assigns the name ____ to the first Excel table created in a workbook.
29

1Table
NewTable
Table1
1

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