Google Forms to Sheets in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to get the timestamp of a Google Form submission in Sheets.

Google Sheets

=ARRAYFORMULA([1])

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

ATODAY()

BNOW()

CFormResponses!A2:A

DIMPORTRANGE()

Attempts:

3 left

💡 Hint

Common Mistakes

Using NOW() which gives current time, not submission time.

Using TODAY() which only gives the date.

Using IMPORTRANGE() without specifying the source.

The FormResponses!A2:A range contains the timestamps of form submissions in the linked Google Sheet.

2fill in blank

medium

Complete the formula to count how many times the answer "Yes" appears in the form responses column B.

Google Sheets

=COUNTIF([1], "Yes")

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

AFormResponses!B:B

BFormResponses!A:A

CFormResponses!C:C

DResponses!B:B

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong column or sheet name.

Counting in the timestamp column instead of answers.

The COUNTIF function counts how many cells in column B of the form responses contain "Yes".

3fill in blank

hard

Fix the error in the formula that tries to filter responses where column C equals "No".

Google Sheets

=FILTER(FormResponses!A2:C, FormResponses!C2:C [1] "No")

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

A=

B==

C!=

D<>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' instead of '=' causes a formula error.

Using '!=' or '<>' when checking for equality.

In Google Sheets formulas, the correct equality operator is =, not ==.

4fill in blank

hard

Fill both blanks to create a formula that sums values in column D only if column B equals "Completed".

Google Sheets

=SUMIF([1], [2], FormResponses!D2:D)

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

AFormResponses!B2:B

B"Completed"

C"Complete"

DFormResponses!C2:C

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong column for the condition range.

Misspelling the condition text.

The SUMIF sums values in column D where column B matches the text "Completed".

5fill in blank

hard

Fill all three blanks to create a formula that creates a dictionary of question names and their average scores from columns B and C, only for scores above 70.

Google Sheets

=[1]: AVERAGEIF(FormResponses!C2:C, [2], FormResponses!B2:B) for [3] in UNIQUE(FormResponses!A2:A)}

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

Aquestion

B>70

Dscore

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up keys and values in the dictionary.

Using incorrect comparison operators.

This formula builds a dictionary where each question name maps to the average score above 70.