Multiple Choice
Match the following PivotTable screen elements with their description:
i.FILTERS area
II.COLUMNS area
III.ROWS area
IV.VALUES area
v.PivotTable Fields pane
A) A window that lists at the top,all of the fields and column titles.
B) An area to position fields that you want to display as columns in the PivotTable.
C) An area in the lower portion of the PivotTable Fields pane to position fields.
D) Numeric of financial in nature and the data is summarized.
E) The data is grouped by theses row titles.
Correct Answer:

Verified
Correct Answer:
Verified
Q81: You can limit the display of data
Q82: A PivotTable is an interactive Excel report
Q83: A _ chart is used to illustrate
Q84: Match the following terms and elements with
Q85: By default,when a non-numeric field is added
Q86: An area to position fields that you
Q88: A PivotChart displays _ that you can
Q89: The area to rearrange and reposition fields
Q90: Match the following terms with their meanings:<br>i.PivotChart<br>II.field
Q91: A series of rows that contains related