Match the following calculated field settings with the corresponding description:
I.Slicer
II.Filter
III.Calculated Field
IV.PivotChart
V.Slicer caption
A.An interactive graphical representation of the data in a PivotTable
B.Text that displays in the header at the top of the slicer window
C.A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly
D.A user-defined field that does not exist in the original dataset
E.Excludes particular categories or values
Correct Answer:
Verified
Q77: PivotTables can be created from the _
Q78: When formatting the data to compile a
Q79: Once completed,fields in PivotTables can be rearranged.
Q80: The Quick Analysis gallery is the only
Q81: _ provide visual representations of data filters
Q83: Match the following PivotTable areas with the
Q84: A(n)_ is a small window containing one
Q85: _ is a built-in add-in program in
Q86: When the calculation options of a PivotTable
Q87: Match the following Pivot Table move options
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