Matching
Match each of the following terms to its description:
Premises:
ROWS area
COLUMNS area
FILTERS area
Slicer
VALUES area
Responses:
Fields added to this area have a calculation of some sort applied.
The field(s)used to organize PivotTable along the top of the table
The field(s)used to organize a PivotTable along the left side of the table
A small window containing one button for each unique item in a field
The first field in this area creates a filter that appears in cell B1.
Correct Answer:
Premises:
Responses:
FILTERS area
The first field in this area creates a filter that appears in cell B1.
COLUMNS area
The field(s)used to organize PivotTable along the top of the table
ROWS area
The field(s)used to organize a PivotTable along the left side of the table
VALUES area
Fields added to this area have a calculation of some sort applied.
Slicer
A small window containing one button for each unique item in a field
Premises:
FILTERS area
COLUMNS area
ROWS area
VALUES area
Slicer
Responses:
The first field in this area creates a filter that appears in cell B1.
The field(s)used to organize PivotTable along the top of the table
The field(s)used to organize a PivotTable along the left side of the table
Fields added to this area have a calculation of some sort applied.
A small window containing one button for each unique item in a field
Related Questions
Q2: If you are interested in finding what
Q3: Which is not true of filters in
Q4: If you want to turn off grand
Q5: A subtotal row must contain at least
Q6: You cannot change the label of a
Q7: What would you do to format all
Q8: The _ function is the default summary
Q9: If you would like to show a
Q10: If you have related data stored in
Q11: Using the % of Grand Total Calculation