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 skillsfrom any curriculum
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
12 questions
Show answers
- Q1Excel assigns the name ____ to the first Excel table created in a workbook.1TableNewTableTable1130s
- Q2A table name cannot include ____.LettersUnderscoresNumbersSpaces30s
- Q3____ order arranges labels in reverse alphabetical order, from Z to A.MajorAscendingDescendingReverse30s
- Q4To add a sort field in the Sort dialog box, click the ____ button.Add fieldNew sort fieldNew levelAdd level30s
- Q5The ____ condition requires that all of the selected criteria be true for the record to be displayedOrIfAndNand30s
- Q6The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.AggregateBetweenTop 10Range30s
- Q7You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.HomeTable Tools DesignViewTable Tools Format30s
- Q8The following is an example of a delimiter: _______.#periodTab$30s
- Q9The following is an example of a delimiter: _______.StructuredTrustedRelationalLinked30s
- Q10Which of the following is not a type of trendline?LinearPowerHorizontalExponentail30s
- Q11The Power Pivot add-in provides access to the _________.Data modelDiagramDatabaseNone of the above30s
- Q12A __________ is a slicer that is applied to date fields.TimelineScatter linePivotTableTrendline30s