Multiple Choice
Match the following terms with their meanings:
i.field names
II.list
III.source data
IV.field section
v.layout section
A) The data for a PivotTable,formatted columns and rows that can be located in an Excel worksheet or an external source.
B) The upper portion of the PivotTable Fields pane containing the fields.
C) The lower portion of the PivotTable Fields pane containing the four areas for layout.
D) A series of rows that contains related data with column titles in the first row.
E) The column titles from source data that form the categories of data for a PivotTable.
Correct Answer:

Verified
Correct Answer:
Verified
Q17: Which of the following areas of a
Q18: You can create a data model by
Q19: A _ can import data from an
Q20: The Clear Filter command removes a filter.
Q21: A row label corresponds to a data
Q23: A Data Model enables you to use
Q24: The default calculation in a PivotTable report
Q25: You can _ a PivotTable by using
Q26: The data for a PivotTable formatted in
Q27: From a PivotTable report,you can double-click a