Matching
Match the following terms to their meanings:
Premises:
PowerPivot
Relationship
Add-in
PivotChart
Slicer
Responses:
A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly
An interactive graphical representation of the data in a PivotTable
An association between two related tables where both tables contain a related field of data, such as IDs
A built-in add-in program in Excel 2013 that enables you to import millions of rows of data from multiple data sources, create a relationship between two or more related tables within one workbook, and maintain connections
A third party application that adds additional functionality to Excel
Correct Answer:
Premises:
Responses:
PowerPivot
Relationship
Add-in
PivotChart
Slicer
Premises:
PowerPivot
Relationship
Add-in
PivotChart
Slicer
Responses:
Related Questions
Q116: Which tool is best suited for use
Q117: Which of the following is not one
Q118: PowerPivot in an Excel add-in.
Q119: Which of the following options is the
Q120: A(n)_ is a small window containing one
Q122: When setting custom calculation options in a
Q123: Multiple filters can be applied to a
Q124: Match the following calculated field settings with
Q125: What does the Values Area of a
Q126: When modifying a PivotTable,the _ appears on