PivotTable formatting in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Google Sheets

=QUERY([1], "select Col1, sum(Col3) group by Col1", 1)

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

AA1:B10

BB1:C10

CA1:C10

DA2:C11

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a range that excludes headers.

Selecting a range missing the column with values to sum.

The data range A1:C10 includes all columns needed for the pivot table.

2fill in blank

medium

Complete the code to format the pivot table values as currency.

Google Sheets

=ARRAYFORMULA(TEXT(B2:B[1], "[2]"))

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

A10

B20

C"$#,##0.00"

D"#,##0"

Attempts:

3 left

💡 Hint

Common Mistakes

Using a range too short to cover all data.

Using a number format without currency symbol.

We format values in rows 2 to 20 as currency with two decimals using "$#,##0.00".

3fill in blank

hard

Fix the error in the formula that sums values in column C for the pivot table.

Google Sheets

=SUM([1])

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

AC2:C10

BC:C2

CC10:C2

DC2:C

Attempts:

3 left

💡 Hint

Common Mistakes

Using reversed ranges like C10:C2.

Using incomplete ranges like C:C2.

The range C2:C10 correctly sums values from row 2 to 10 in column C.

4fill in blank

hard

Fill both blanks to create a pivot table that filters rows where sales are greater than 1000.

Google Sheets

=QUERY(A1:C20, "select A, sum(C) where C [1] [2] group by A", 1)

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

A>

B<

C1000

D500

Attempts:

3 left

💡 Hint

Common Mistakes

Using less than symbol instead of greater than.

Using wrong numeric filter values.

The query filters rows where sales in column C are greater than 1000.

5fill in blank

hard

Fill all three blanks to create a pivot table that groups by product, sums sales, and filters for sales above 500.

Google Sheets

=QUERY(A1:C30, "select [1], sum([2]) where [2] [3] 500 group by [1]", 1)

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

AA

BB

CC

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up column letters for grouping and summing.

Using wrong column for filtering.

The pivot table groups by product in column A, sums sales in column C, and filters sales greater than 500.