In Google Sheets, when you add a field to Rows, what effect does it have?

• A. Creates a chart automatically.
• B. Groups data by that field and lists categories vertically.
• C. Deletes the column.
• D. Changes data type.

Answer: (B)

Rows in a pivot table define how data is organized and labeled. When you add a field to Rows, Google Sheets groups the data by the distinct values of that field and lists each category as its own row label down the page. This creates a vertical list of categories on the left, with the corresponding aggregated numbers shown in the table’s body. It doesn’t automatically create charts, delete columns, or change data types; it simply reorganizes the view to show data by that category. For example, adding a region field to Rows will produce a row for each region, allowing you to compare totals or sums across regions.