Creating a PivotTable in Google Sheets - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a PivotTable from data in range A1:C10.

Google Sheets

=PIVOTTABLE([1], "A1:C10")

Drag options to blanks, or click blank then click option'

ADATA

BA1:C10

CDATA!A1:C10

DRANGE

Attempts:

3 left

💡 Hint

Common Mistakes

Using a sheet name without range

Using an undefined name like DATA

Putting the range in quotes

The range A1:C10 specifies the data source for the PivotTable.

2fill in blank

medium

Complete the code to add a row field named 'Category' to the PivotTable.

Google Sheets

=PIVOTTABLE(A1:C10, , [1])

Drag options to blanks, or click blank then click option'

AROW

BFILTERS

CCOLUMNS

DROWS

Attempts:

3 left

💡 Hint

Common Mistakes

Using singular 'ROW' instead of 'ROWS'

Confusing rows with columns

Using 'FILTERS' instead of 'ROWS'

The ROWS argument defines which column to use as row labels in the PivotTable.

3fill in blank

hard

Fix the error in the formula to sum the 'Sales' column in the PivotTable.

Google Sheets

=PIVOTTABLE(A1:C10, ROWS="Category", VALUES=[1])

Drag options to blanks, or click blank then click option'

A"SUM"

B"SUM(Sales)"

C"Sales"

D"SUMIF(Sales)"

Attempts:

3 left

💡 Hint

Common Mistakes

Putting the whole formula inside quotes

Using the column name instead of aggregation function

Using invalid functions like SUMIF

The VALUES argument should specify the aggregation function like "SUM" to sum the 'Sales' column.

4fill in blank

hard

Fill both blanks to filter the PivotTable to show only 'East' region and sum 'Sales'.

Google Sheets

=PIVOTTABLE(A1:C10, ROWS="Region", VALUES=[1], FILTERS=[2])

Drag options to blanks, or click blank then click option'

A"SUM"

B"COUNT"

C"Region=East"

D"Region=West"

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong aggregation function

Filtering the wrong region

Mixing up filters and rows

Use "SUM" to sum sales and "Region=East" to filter only the East region.

5fill in blank

hard

Fill all three blanks to create a PivotTable summing 'Sales', grouping by 'Category', and filtering 'Region' to 'West'.

Google Sheets

=PIVOTTABLE(A1:C10, ROWS=[1], VALUES=[2], FILTERS=[3])

Drag options to blanks, or click blank then click option'

A"Category"

B"SUM"

C"Region=West"

D"Sales"

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing column names with aggregation functions

Filtering the wrong region

Using incorrect syntax for filters

Group rows by "Category", sum the "Sales" column using "SUM", and filter to "Region=West".