Site MapHelpFeedbackLesson 20 - Using Data Tables and PivotTables
Lesson 20 - Using Data Tables and PivotTables
(See related pages)

1
What dialog box allows you to change a field name in a PivotTable?
A)Field Options
B)Field Pane
C)Field Settings
D)Field Structure
2
Why are PivotTables considered interactive?
A)They allow you to add dynamic data.
B)They allow you to rearrange row and column data.
C)They allow you to generate e-mail enabled reports.
D)They allow you to print the reports with various settings.
3
Which button includes the Data Table command?
A)Data Tools
B)Source Data
C)Table Array
D)What-If Analysis
4
How can you add a title to a PivotChart that does not already have one?
A)Click the PivotChart Tools Design tab.
B)Click the PivotChart Tools Layout tab.
C)Click the PivotChart Tools Format tab.
D)Click the PivotChart Tools Analyze tab.
5
What command allows you to highlight the cell(s) in a data table that matches your set-up information?
A)Cell Styles
B)Conditional Formatting
C)AutoFormatting
D)Data Table Styles
6
What is the best way to illustrate profit ranges as the selling price is adjusted?
A)One-variable data table
B)Two-variable data table
C)Three-variable data table
D)PivotTable and associated chart
7
What element of a PivotTable appears in Formula AutoComplete and structured reference lists?
A)Its properties
B)Its size
C)Its name
D)Its location
8
Which of these tools is helpful in setting up column input values for a data table?
A)AutoComplete
B)AutoFill
C)AutoFit
D)AutoText
9
What is the purpose of using a pointer in a data table?
A)It highlights the cell that matches the source data.
B)It allows the array formula to be repositioned.
C)It highlights the first cell with a potential error.
D)It resets the file location to a recognized folder.
10
Which command substitutes input values in one or more formulas?
A)Data Table
B)Pivot Field
C)PivotTable
D)Paste Special







PASOnline Learning Center

Home > Excel > Lesson 20 Quiz