Matching
Match the following PivotTable areas with the corresponding description:
Premises:
PivotTable Fields task pane
Filters Area
Columns Area
Rows Area
Values Area
Responses:
Organizes and groups data into categories on the left side. Each group name occupies a single row.
Displays summary statistics, such as totals or averages.
Subdivides data into one or more additional categories.
Filters the data to display results based on particular conditions you set.
Contains two sections that allow for the editing of a PivotTable.
Correct Answer:
Premises:
Responses:
PivotTable Fields task pane
Filters Area
Columns Area
Rows Area
Values Area
Premises:
PivotTable Fields task pane
Filters Area
Columns Area
Rows Area
Values Area
Responses:
Related Questions
Q126: When modifying a PivotTable,the _ appears on
Q127: A(n)_ is a powerful,interactive data-mining feature that
Q128: Which of the following tools is best
Q129: _ provide visual representations of data filters
Q130: What tool is best suited for organizing
Q131: Match the following terms to their meanings:
Q133: What is the best PowerPivot tool when
Q134: The default numerical field calculation for a
Q135: Match the following terms with their meanings:
Q136: The Quick Analysis gallery is the only