Why Google Sheets is essential for collaboration - Test Your Understanding

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 '+' instead of ':' to specify a range.

Trying to subtract or multiply cell references inside SUM.

The correct way to sum a range in Google Sheets is using the colon to specify the range, like 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 '+' instead of ':' to specify a range.

Using COUNT on a single cell or incorrect range.

The COUNT function counts numeric values in a range, so you need to specify the range with a colon, like B1:B10.

3fill in blank

hard

Fix the error in this formula to get the average of cells 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 '+' or '-' instead of ':' to specify a range.

Multiplying or subtracting cell references inside AVERAGE.

The correct way to specify a range in Google Sheets is with a colon, so C1:C5 selects all cells from C1 to C5.

4fill in blank

hard

Fill both blanks to create a formula that sums values in D1 to D10 only if they are greater than 5.

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 '+' instead of ':' for the range.

Using the wrong comparison operator like '<5'.

The SUMIF function sums cells in the range D1:D10 that meet the condition '>5'.

5fill in blank

hard

Fill all three blanks to create a formula that counts cells in E1 to E20 that contain the text 'Done'.

Google Sheets

=COUNTIF([1], [2], [3])

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

AE1:E20

B"Done"

C"done"

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around the text 'Done'.

Using the wrong range or misspelling the text.

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