Creating a PivotTable in Google Sheets - Quick Revision & Summary

Recall & Review

beginner

What is a PivotTable in Google Sheets?

A PivotTable is a tool that helps you quickly summarize and analyze large sets of data by organizing it into a simple table with rows, columns, and values.

beginner

How do you start creating a PivotTable in Google Sheets?

Select your data range, then go to the menu and click Insert > Pivot table. Choose where to place the PivotTable (new sheet or existing sheet).

beginner

What are the four main areas you can add fields to in a PivotTable?

Rows, Columns, Values, and Filters. Rows and Columns organize data, Values show calculations, and Filters let you limit what data is shown.

beginner

How can you change the calculation type in the Values area of a PivotTable?

Click on the value field in the PivotTable editor, then choose a calculation like SUM, COUNT, AVERAGE, MAX, or MIN from the list.

beginner

Why use Filters in a PivotTable?

Filters let you focus on specific parts of your data by showing only the rows that meet certain conditions, making analysis easier.

What menu option do you use to create a PivotTable in Google Sheets?

A Data > Sort range

B Insert > Pivot table

C Format > Conditional formatting

D Tools > Script editor

You create a PivotTable by selecting Insert > Pivot table from the menu.

Which area in a PivotTable is used to add the data you want to calculate?

A Rows

B Columns

C Filters

D Values

The Values area is where you add data to calculate sums, counts, averages, etc.

If you want to see data grouped by categories vertically, which PivotTable area do you use?

A Rows

B Columns

C Values

D Filters

Rows organize data vertically in the PivotTable.

How can you limit the data shown in a PivotTable to only certain items?

A Use Filters

B Change Values

C Add more Rows

D Sort the data

Filters let you choose which data to include or exclude in the PivotTable.

Which calculation is NOT commonly used in PivotTable Values?

A SUM

B AVERAGE

C SPELLCHECK

D COUNT

SPELLCHECK is not a calculation option in PivotTables.

Explain the steps to create a PivotTable from a data set in Google Sheets.

Think about what you click and what you choose in the menu.

Describe the purpose of each area in a PivotTable: Rows, Columns, Values, and Filters.

Consider how each area changes the way data is displayed or calculated.