When adding Rows to a pivot table, what order are they displayed by default?

• A. In ascending order
• B. In descending order
• C. In the order data was entered
• D. Random order

Answer: (A)

When you add a field to the Rows area of a pivot table, the row labels are sorted in ascending order by default. This keeps the table organized and easy to read. For text values, that means A to Z; for numbers, smallest to largest; for dates, oldest to newest. You can change this to descending or a custom order if you want a different arrangement, but the automatic default is ascending. The original data entry order isn’t preserved by default, and the rows aren’t in random order unless you apply a specific, non-default sort.