Match the following terms to their meanings:
I.PowerPivot
II.Relationship
III.Add-in
IV.PivotChart
V.Slicer
A.A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly
B.An interactive graphical representation of the data in a PivotTable
C.An association between two related tables where both tables contain a related field of data,such as IDs
D.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
E.A third party application that adds additional functionality to Excel
Correct Answer:
Verified
Q88: A(n)_ is a user-defined field that does
Q89: Match the following calculated field settings with
Q90: Match the following grouping button with the
Q91: A(n)_ is an association between two related
Q92: To update the data in a PivotTable
Q94: Match the following calculated field settings with
Q95: The default numerical field calculation for a
Q96: A(n)_ is an interactive graphical representation of
Q97: The _ is text that displays in
Q98: Match each Slicer Tools command group with
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents