Multiple Choice
Given a list of candy bars in a field called Item and their prices in a field called Price on an empty PivotTable, how would you find out how many of each type of candy bar you have?
A) Drag Item to both the VALUES and the ROWS area.
B) Drag Price to the ROWS and Item to the VALUES area.
C) Drag Item to the COLUMNS area.
D) Drag Item to the ROWS areas.
Correct Answer:

Verified
Correct Answer:
Verified
Q16: Build a PivotChart in the PivotChart wizard
Q17: What dictates the order of hierarchy of
Q18: The four areas for organizing fields in
Q19: Creating a data model in Excel is
Q20: Moving one of two fields from the
Q22: The _ area is replaced with the
Q23: What field is in the ROWS area
Q24: A PivotChart _.<br>A)is not altered by filters
Q25: Auto Outline creates an outline based on
Q26: Which of the following is true about