Matching
Match the following PivotTable areas with the corresponding description
Premises:
Columns Area
Rows Area
Filters Area
PivotTable Fields task pane
Values Area
Responses:
Organizes and groups data into categories on the left side.Each group name occupies a single row.
Contains two sections that allow for the editing of a PivotTable.
Filters the data to display results based on particular conditions you set.
Subdivides data into one or more additional categories.
Displays summary statistics,such as totals or averages.
Correct Answer:
Premises:
Responses:
Columns Area
Rows Area
Filters Area
PivotTable Fields task pane
Values Area
Premises:
Columns Area
Rows Area
Filters Area
PivotTable Fields task pane
Values Area
Responses:
Related Questions
Q15: Once created,a PivotTable cannot be edited.
Q30: Match the following grouping button with the
Q34: Which PivotTable calculation option is best suited
Q51: Where are PivotTable formatting tools located?<br>A)PivotTable Tools
Q53: Once a slicer is inserted into a
Q74: When editing a PivotTable where are values
Q78: Where is the Subtotal command located on
Q83: _ is the process of joining rows
Q102: Which of the following tools is best
Q123: Multiple filters can be applied to a