Pivot Tables 101 Quiz
Name:
*
First Name
Last Name
Email:
*
example@example.com
Spreadsheet ID:
*
Your spreadsheet ID is available in the StudentsExcel Portal: http://portal.studentsexcel.com/.
1. How many blank fields can the first row of your pivot table source data contain?
*
A. 0
B. 1
C. 2
D. 3
2. Which of the following items can be added to a Pivot Table from the PivotTable Field list?
*
A. Report
B. Chart
C. Row Field
D. External Data Source
3. The Pivot Table Field Name Already Exists prompt signifies:
*
A. You attempted to drag a field onto a pivot table more than once
B. You tried to assign a name to a field in the values section that appears elsewhere on the field list
C. You dragged a field from the Rows section to the Columns section
D. You removed a field from the pivot table
4. Which pivot table format groups all fields within the Rows section of the Pivot Table Field list into a single column?
*
A. Compact Form
B. Outline Form
C. Tabular Form
D. Repeat All Item Labels
5. Fields placed within the Filter section of the Pivot Table field list:
*
A. Add additional columns to the pivot table
B. Add additional rows to the pivot table
C. Add additional worksheets to your workbook
D. Add another dimension for controlling data shown in the pivot table
6. How do you drill down on data within a pivot table to see the underlying records?
*
A. Left-click on any number in the pivot table.
B. Right-click on any number in the pivot table.
C. Double-click on any number in the pivot table.
D. Triple-click on any number in the pivot table.
Calculation
Submit
Should be Empty: