If you place a field in the Rows area, what effect does it have on the pivot table?

• A. It adds a new worksheet
• B. It formats numbers as currency
• C. It groups data by that field along the row labels
• D. It hides the data

Answer: (C)

Placing a field in the Rows area organizes the pivot table around that field by creating row labels and grouping the data accordingly. Each unique value of the field becomes a row label, so the data is grouped by that field along the rows. If you add more fields to the Rows area, you get a hierarchy: the first field forms the top-level groups, and subsequent fields nest within those groups. This layout change affects how the summarized values (in the Values area) appear, showing totals or other measures for each group. It doesn’t add worksheets, change formatting, or hide data.