Comments and suggestions in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a comment in a Google Sheets formula.

Google Sheets

=SUM(A1:A10) [1] This adds the values

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

A'

B/*

C//

D#

Attempts:

3 left

💡 Hint

Common Mistakes

Using # or // which are not valid comment symbols in Google Sheets formulas.

Trying to use /* which is not supported.

In Google Sheets, a comment in a formula is added using a single quote '. Anything after the quote is ignored.

2fill in blank

medium

Complete the formula to add a comment after the calculation.

Google Sheets

=AVERAGE(B1:B5) [1] Calculate average score

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

A#

BREM

C//

D'

Attempts:

3 left

💡 Hint

Common Mistakes

Using # or // which are common in other languages but not in Sheets formulas.

Using REM which is not recognized in Sheets formulas.

The single quote ' is used to add comments in Google Sheets formulas. Anything after it is ignored.

3fill in blank

hard

Fix the error in the formula by adding the correct comment symbol.

Google Sheets

=MAX(C1:C10) [1] Find max value

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

A'

B#

C//

D/*

Attempts:

3 left

💡 Hint

Common Mistakes

Using // or # which are not valid comment symbols in Sheets formulas.

Using /* which is not supported.

The correct comment symbol in Google Sheets formulas is the single quote '. Other symbols cause errors or are ignored differently.

4fill in blank

hard

Fill both blanks to create a formula that sums and adds a comment.

Google Sheets

=SUM([1]) [2] Total sales

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

AD1:D20

B'

CA1:A10

D//

Attempts:

3 left

💡 Hint

Common Mistakes

Using an invalid range or wrong comment symbol like //.

Putting the comment inside the SUM parentheses.

The range A1:A10 is used inside SUM, and the single quote ' adds a comment after the formula.

5fill in blank

hard

Fill all three blanks to create a formula that averages a range and adds a comment.

Google Sheets

=AVERAGE([1])[2] Calculate average of [3]

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

AB2:B15

B'

Csales

D//

Attempts:

3 left

💡 Hint

Common Mistakes

Using // instead of the single quote for comments.

Putting the comment inside the parentheses.

Using an invalid range.

The range B2:B15 is averaged, the comment starts with a single quote ', and the word sales describes the data.