Solved

Match the Following Terms to Their Meanings

Question 10

Matching

Match the following terms to their meanings:

Premises:
PowerPivot
Add-in
Slicer
PivotChart
Relationship
Responses:
A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly
A third party application that adds additional functionality to Excel
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
An interactive graphical representation of the data in a PivotTable

Correct Answer:

PowerPivot
Add-in
Slicer
PivotChart
Relationship
Related Questions

Q20: Multiple subtotals can be applied to one

Q31: By default,PivotTables display aggregated data for each

Q57: Custom slicers can be created in Excel.

Q64: A PivotTable can be created from the

Q67: Slicers can only be removed from the

Q72: Which of the following tools is best

Q86: Adding _ to a preexisting data set

Q90: To update the data in a PivotTable

Q104: Where are the Expand Field and Collapse

Q117: Which of the following is not one