Multiple Choice
Match the following terms and elements with their descriptions:
i.Clear Filter
II.Filter
III.filtering button
IV.slicer header
v.slicers
A) The button on a slicer that you use to select the item by which to filter.
B) Indicates the category of the slicer items.
C) Easy-to-use filtering controls to drill down through large amounts of data in an interactive way.
D) Limits the display of data to only specific information.
E) A command that removes a filter.
Correct Answer:

Verified
Correct Answer:
Verified
Q79: The PivotTable report with data graphically represented
Q80: When you import data from Microsoft Access
Q81: You can limit the display of data
Q82: A PivotTable is an interactive Excel report
Q83: A _ chart is used to illustrate
Q85: By default,when a non-numeric field is added
Q86: An area to position fields that you
Q87: Match the following PivotTable screen elements with
Q88: A PivotChart displays _ that you can
Q89: The area to rearrange and reposition fields