Matching
Match the following calculated field settings with the corresponding description:
Premises:
Slicer
Filter
Calculated Field
PivotChart
Slicer caption
Responses:
An interactive graphical representation of the data in a PivotTable
Text that displays in the header at the top of the slicer window
A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly
A user-defined field that does not exist in the original dataset
Excludes particular categories or values
Correct Answer:
Premises:
Responses:
Slicer
Filter
Calculated Field
PivotChart
Slicer caption
Premises:
Slicer
Filter
Calculated Field
PivotChart
Slicer caption
Responses:
Related Questions
Q60: When using subtotal,what does the 4th button
Q61: Once slicers are created additional Slicer Styles
Q62: How are grouped columns ungrouped?<br>A)Select the entire
Q63: PivotTables can be created from the _
Q64: A PivotTable can be created from the
Q66: Match the following charts to their descriptions:
Q67: Slicers can only be removed from the
Q68: Match the following terms to their meanings:
Q69: Which of the following is not a
Q70: Where is the command to insert a