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
Q1: If you create a Recommended PivotTable on
Q3: The _ function is the default summary
Q4: If you would like to show a
Q5: What would you do to format all
Q6: A worksheet of faculty members at your
Q7: You created a PivotTable and later made
Q8: You would like to see both average
Q9: Moving one of two fields from the
Q10: Which of the following is true about
Q11: What does a + button indicate 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