Multiple Choice
When setting custom calculation options in a PivotTable,what does % of Parent Row Total calculate?
A) Displays each value as a percentage of the grand total
B) Displays each value as a percentage of the respective column
Total.The values in each column total 100%
C) Displays each value as a percentage of the respective row
Total.The values in each row total 100%
D) Displays values as: (value for the item) / (value for the parent
Item on rows)
Correct Answer:

Verified
Correct Answer:
Verified
Q7: Match the following table components to their
Q8: A(n)_ is a user-defined field that does
Q9: Which of the following calculations cannot be
Q10: The default numerical field calculation for PivotTables
Q11: Custom calculated fields will not update if
Q13: Filters can only be applied to PivotTables
Q14: Match the following Pivot Table move options
Q15: Once created,a PivotTable cannot be edited.
Q16: Once completed,fields in PivotTables can be rearranged.
Q17: PivotTables can be created from the _