What steps do you follow to create a pivot table in Google Sheets?

• A. Select the data range; Insert a pivot table; Add Rows, Columns, and Values; adjust as needed.
• B. Open the Chart menu and select a pivot option.
• C. Copy the data to a new sheet and create a pivot table there.
• D. Delete the original data and recreate it through a pivot wizard.

Answer: (A)

To create a pivot table in Google Sheets, you start by selecting the data you want to summarize. Then use the pivot table option from the Data menu and choose where to place the pivot table (new sheet or existing sheet). In the pivot table editor, you add fields to Rows to define row labels, to Columns to define column labels, and to Values for the numeric calculations (such as sum, count, or average). You can adjust the arrangement and calculations as needed to get the desired summary. The other approaches aren’t how this feature works: using the Chart menu doesn’t create a pivot table, copying data to another sheet isn’t required, and deleting the original data with a wizard isn’t how you build a pivot table.