Multiple Choice
If you would like to show a subtotal of the wholesale price of a number of items of clothing on a PivotTable of data of both men and women.You have the following fields: Gender, Item and Price.Sum of Price is in the VALUES area.Gender is in the ROWS area.How do you get a subtotal of shirts and pants to display for each gender?
A) Drag the Item field to VALUES.
B) Drag the Item field above Gender in ROWS.
C) Drag the Gender field off the ROWS.
D) Drag the Item field beneath Gender in ROWS.
Correct Answer:

Verified
Correct Answer:
Verified
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
Q10: If you have related data stored in
Q11: Using the % of Grand Total Calculation
Q12: Match each of the following Show Value
Q13: You are analyzing sales data and eating
Q14: You can clear all fields from a