Solved

What Dictates the Order of Hierarchy of Fields in the Rows

Question 17

Multiple Choice

What dictates the order of hierarchy of fields in the rows of a PivotTable?


A) alphabetical order
B) the order of the fields in the ROWS area.
C) the order of the fields in the COLUMNS area
D) the rank in the sort order dialog box.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q12: Match each of the following Show Value

Q13: You are analyzing sales data and eating

Q14: You can clear all fields from a

Q15: How would you add a date filter

Q16: Build a PivotChart in the PivotChart wizard

Q18: The four areas for organizing fields in

Q19: Creating a data model in Excel is

Q20: Moving one of two fields from the

Q21: Given a list of candy bars in

Q22: The _ area is replaced with the