Short Answer
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
Correct Answer:
Verified
Q27: Match the following terms to their meanings:
Q28: Match the following terms with their meanings:
Q29: Match the following grouping button with the
Q30: What is the default summary statistic for
Q31: By default,PivotTables display aggregated data for each
Q33: Once applied,slicers cannot be removed.
Q34: Which PivotTable calculation option is best suited
Q35: In a PivotTable Fields task pane,the _
Q36: Which of the following is not a
Q37: _ is the process of analyzing large