Why collaboration is Sheets' superpower in Google Sheets - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

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

Google Sheets

=SUM(A1[1]A5)

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

A:

B,

C;

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using a comma ',' instead of a colon ':' to specify a range.

Using a semicolon ';' which is not valid for ranges.

Using a dash '-' which is not a range operator.

The colon ':' is used to specify a range of cells in Google Sheets formulas.

2fill in blank

medium

Complete the formula to count how many cells in B1:B10 are greater than 5.

Google Sheets

=COUNTIF(B1[1]B10[2]">5")

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

A-

B,

C;

D:

Attempts:

3 left

💡 Hint

Common Mistakes

Using a semicolon ';' instead of a comma ',' to separate arguments.

Using a dash '-' instead of a colon ':' for the range.

Putting the condition inside the range.

The colon ':' defines the range B1 to B10. The comma ',' separates the range from the condition.

3fill in blank

hard

Fix the error in this formula that joins text from cells A1 and B1 with a space.

Google Sheets

=CONCATENATE(A1[1]" "[2]B1)

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

A,

B;

C+

D:

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus '+' which is not valid for CONCATENATE in Sheets.

Using semicolon ';' which is invalid argument separator here.

Using colon ':' which is not an argument separator.

In Google Sheets, CONCATENATE uses commas ',' to separate arguments.

4fill in blank

hard

Fill in the blank to create a formula that returns TRUE if C1 is not empty.

Google Sheets

=NOT(IS[1](C1))

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

AEMPTY

BNULL

CBLANK

DNA

Attempts:

3 left

💡 Hint

Common Mistakes

Using ISNULL which is not a Sheets function.

Using ISNA which checks for errors, not emptiness.

Leaving out the parentheses.

ISBLANK(C1) checks if C1 is empty. NOT reverses the result to TRUE if not empty.

5fill in blank

hard

Fill all three blanks to create a formula that sums values in D1:D10 only if they are greater than 50.

Google Sheets

=SUMIF(D1[1]D10[2]">50[3])

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

A:

B,

C)

D;

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolon ';' instead of comma ',' to separate arguments.

Forgetting the closing parenthesis ')'.

Using dash '-' instead of colon ':' for range.

SUMIF uses a range with colon ':', then a comma ',', then the condition, and closes with a parenthesis ')'.