Real-time co-editing in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to sum cells A1 to A5 in real-time co-editing.

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 a dash '-' instead of a colon ':' for ranges.

Separating cells with a semicolon ';' inside SUM.

Adding cells with '+' inside SUM instead of a range.

The correct range syntax in Google Sheets is A1:A5 to sum all cells from A1 to A5.

2fill in blank

medium

Complete the formula to count how many cells in B1:B10 are not empty during co-editing.

Google Sheets

=COUNTA([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 a dash '-' instead of a colon ':' for ranges.

Separating cells with a semicolon ';' inside COUNTA.

Adding cells with '+' inside COUNTA instead of a range.

The COUNTA function counts non-empty cells in the range B1:B10.

3fill in blank

hard

Fix the error in this formula to get the average of cells C1 to C5 during real-time editing.

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 a dash '-' instead of a colon ':' for ranges.

Separating cells with a semicolon ';' inside AVERAGE.

Adding cells with '+' inside AVERAGE instead of a range.

The correct range syntax is C1:C5 to calculate the average of those cells.

4fill in blank

hard

Fill both blanks to create a formula that sums only cells in D1:D10 that are greater than 5 during co-editing.

Google Sheets

=SUMIF([1], [2])

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

AD1:D10

B>5

C<5

DD1-D10

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':' for ranges.

Using the wrong comparison operator like '<5'.

Putting the range and criteria in the wrong order.

The SUMIF function sums cells in D1:D10 that are greater than 5 using the criteria >5.

5fill in blank

hard

Fill both blanks to create a formula that counts cells in E1:E20 that contain the text "Done" during real-time co-editing.

Google Sheets

=COUNTIF([1], [2])

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

AE1:E20

B"Done"

DE1-E20

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':' for ranges.

Not using quotes around the text criteria.

The COUNTIF function counts cells in E1:E20 that exactly match the text "Done".