Why PivotTables summarize data fast in Google Sheets - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to sum the values in column B.

Google Sheets

=SUM([1])

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

AC2:C10

BA2:A10

CB2:B10

DD2:D10

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting the wrong column range.

Using a single cell instead of a range.

The SUM function adds all numbers in the range B2:B10, which contains the values to summarize.

2fill in blank

medium

Complete the formula to count how many entries are in column A.

Google Sheets

=COUNTA([1])

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

AB2:B20

BA2:A20

CC2:C20

DD2:D20

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT instead of COUNTA, which only counts numbers.

Selecting the wrong column range.

COUNTA counts all non-empty cells in the range A2:A20, which holds the entries.

3fill in blank

hard

Fix the error in the formula to calculate average sales in column C.

Google Sheets

=AVERAGE([1])

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

AC2:C15

BC2:C

CC2:C15:C20

DC2-C15

Attempts:

3 left

💡 Hint

Common Mistakes

Using incomplete or invalid range syntax.

Using subtraction instead of a range.

The correct range C2:C15 selects the cells with sales data. Other options are invalid ranges.

4fill in blank

hard

Fill both blanks to create a filter that shows only sales greater than 100.

Google Sheets

=FILTER(C2:C20, C2:C20 [1] [2])

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

A>

B<

C100

D50

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong comparison operator.

Using a wrong number for filtering.

The FILTER function uses the condition C2:C20 > 100 to show sales above 100.

5fill in blank

hard

Fill all three blanks to create a dictionary of product names and their sales above 200.

Google Sheets

=[1]: [2] for [3] in A2:A30 if B2:B30 > 200}

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

AA2:A30

BB2:B30

Cproduct

Dsales

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up keys and values.

Using ranges instead of variable names in the comprehension.

This comprehension creates a dictionary with product names as keys and sales as values, filtering sales above 200.