Sheets with Google Data Studio (Looker) in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to sum values in cells A1 to A5.

Google Sheets

=SUM([1])

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

AA1*A5

BA1+A5

CA1-A5

DA1:A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus signs instead of a range.

Using subtraction or multiplication instead of sum.

The SUM function adds all numbers in the range A1:A5.

2fill in blank

medium

Complete the formula to count how many cells in B1:B10 contain numbers.

Google Sheets

=COUNT([1])

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

AB1*B10

BB1:B10

CB1-B10

DB1+B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus or minus instead of a range.

Counting cells outside the intended range.

The COUNT function counts numeric values in the range B1:B10.

3fill in blank

hard

Fix the error in the formula to calculate average of C1 to C5.

Google Sheets

=AVERAGE([1])

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

AC1-C5

BC1+C5

CC1:C5

DC1*C5

Attempts:

3 left

💡 Hint

Common Mistakes

Using arithmetic operators instead of a range.

Selecting only two cells instead of a range.

The AVERAGE function needs a range like C1:C5 to calculate the mean.

4fill in blank

hard

Fill both blanks to create a dictionary of word lengths for words longer than 4 letters.

Google Sheets

{word: [1] for word in words if len(word) [2] 4}

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

Alen(word)

Bword

C>

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using the word itself instead of its length.

Using less than or equal instead of greater than.

The dictionary maps each word to its length using len(word). The condition len(word) > 4 filters words longer than 4 letters.

5fill in blank

hard

Fill all three blanks to create a dictionary of uppercase keys and values greater than zero.

Google Sheets

result = [1]: [2] for k, v in data.items() if v [3] 0}

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

Ak.upper()

Bv

C>

Dk.lower()

Attempts:

3 left

💡 Hint

Common Mistakes

Using lowercase keys instead of uppercase.

Using less than or equal instead of greater than.

Using keys instead of values in the dictionary.

The dictionary uses uppercase keys with k.upper(), values v, and filters for values greater than zero with v > 0.