Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called?
Format
Filtering
Calculated Field
Labels
Numeric data and titles
Design
Design
Fields
What is typically included in the range of data selected to create a chart?
Format
Filtering
Calculated Field
Labels
Numeric data and titles
Design
Design
Fields
John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?
Format
Filtering
Calculated Field
Labels
Numeric data and titles
Design
Design
Fields
John wants to change the chart style on his Pivot table. Which Pivot Table chart tools tab would he choose?
Format
Filtering
Calculated Field
Labels
Numeric data and titles
Design
Design
Fields
John wants to identify the exact value that each column in his chart represents. Which option should he choose?
Format
Filtering
Calculated Field
Labels
Numeric data and titles
Design
Design
Fields
What is the process of viewing a PivotTable report for a subset that meets the criterion only?
Format
Filtering
Calculated Field
Labels
Numeric data and titles
Design
Design
Fields
Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
Format
Filtering
Calculated Field
Labels
Numeric data and titles
Design
Design
Fields
When creating a PivotTable, which are drawn in columns in the worksheet data?
Format
Filtering
Calculated Field
Labels
Numeric data and titles
Design
Design
Fields
Check it!