Matching
Match each of the following terms to its description:
Premises:
VALUES area
FILTERS area
ROWS area
COLUMNS area
Slicer
Responses:
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 field(s)used to organize PivotTable along the top of the table
Fields added to this area have a calculation of some sort applied.
The first field in this area creates a filter that appears in cell B1.
Correct Answer:
Premises:
Responses:
VALUES area
FILTERS area
ROWS area
COLUMNS area
Slicer
Premises:
VALUES area
FILTERS area
ROWS area
COLUMNS area
Slicer
Responses:
Related Questions
Q90: The % Period Expense Column on this
Q91: Match each of the following PivotChart terms
Q92: Match each of the following Data Modeling
Q93: Match each of the following Show Value
Q94: Match each of the following PivotTable summary
Q95: Match the Fields used below with the
Q96: Match each of the following subtotal functions
Q97: Match each of the following terms to
Q98: Match each of the following tools to
Q99: Match each of the following terms to
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents