Question

In a Pivot table fields pane, when you select a field that is text or date it will automatically be moved to which category?

1) Rows
2) Columns
3) Values
4) Filters

Answer 1

In a Pivot table fields pane, selecting a text or date field will automatically place it in the Rows category. This is because they provide optimal categorization of data in most cases, although manual adjustment to Columns or Filters is possible.

Step-by-step explanation:

When you select a field that is text or date in a Pivot table fields pane, it will automatically be moved to the Rows category. This behavior is because PivotTables are designed to categorize and display data efficiently. Text and date fields are typically used to segment data into meaningful groups, which is best done in rows for easier interpretation and interaction. However, you can manually move these fields to other areas like Columns or Filters, depending on your data analysis needs.