Matching
Match the Fields used below with the appropriate areas to make this Pivot Table.
Refer to the PivotTable above:
Premises:
Category (Regular Meal, Snacks, etc.)
Item (Pizza Slice, Cookies, Water, etc.)
Extended Price (unit price * quantity of item sold)
Quantity (quantity of item sold)
Date (date of the purchase)
Responses:
FILTERS or not used, at all
Second in VALUES
Second in ROWS
First in VALUES
First in ROWS
Correct Answer:
Premises:
Responses:
Category (Regular Meal, Snacks, etc.)
Item (Pizza Slice, Cookies, Water, etc.)
Extended Price (unit price * quantity of item sold)
Quantity (quantity of item sold)
Date (date of the purchase)
Premises:
Category (Regular Meal, Snacks, etc.)
Item (Pizza Slice, Cookies, Water, etc.)
Extended Price (unit price * quantity of item sold)
Quantity (quantity of item sold)
Date (date of the purchase)
Responses:
Related Questions
Q43: Match each of the following Data Modeling
Q44: A PivotTable has a live update feature
Q45: Which category or categories display in the
Q46: Match each of the following terms to
Q47: A PivotTable time line can filter dates
Q49: Sum is the default action of a
Q50: You created a slicer on the field
Q51: A(n)_ hides some values from a field
Q52: Excel is able to group data both
Q53: The first step in using the subtotal