Why logical functions handle conditions in Google Sheets - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to check if A1 is greater than 10.

Google Sheets

=IF(A1 [1] 10, "Yes", "No")

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

A>

B<

C=

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' will check the wrong condition.

Using '=' will check if A1 equals 10, not greater.

The IF function tests if A1 is greater than 10 using the '>' operator.

2fill in blank

medium

Complete the formula to return TRUE if B2 equals 5.

Google Sheets

=IF(B2 [1] 5, TRUE, FALSE)

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

A=

B>=

C<

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' or '<' checks for greater or less, not equality.

Using '>=' checks for greater or equal, not exact equality.

The '=' operator checks if B2 is exactly 5.

3fill in blank

hard

Fix the error in the formula to check if C3 is less than or equal to 20.

Google Sheets

=IF(C3 [1] 20, "OK", "Check")

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

A>

B<

C<=

D==

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' causes an error because Google Sheets uses '=' for equality.

Using '<' only checks less than, not less than or equal.

The correct operator for 'less than or equal to' is '<=' in Google Sheets.

4fill in blank

hard

Fill both blanks to create a formula that returns "Pass" if D4 is between 50 and 100 (inclusive).

Google Sheets

=IF(AND(D4 [1] 50, D4 [2] 100), "Pass", "Fail")

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

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '<=' excludes 100 from the range.

Using '>' instead of '>=' excludes 50 from the range.

The formula checks if D4 is greater than or equal to 50 and less than or equal to 100.

5fill in blank

hard

Fill all three blanks to create a formula that returns "Good" if E5 is greater than 70, "Average" if equal to 70, and "Poor" if less than 70.

Google Sheets

=IF(E5 [1] 70, "Good", IF(E5 [2] 70, "Average", IF(E5 [3] 70, "Poor", "Poor")))

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

A>

B=

C<

D>=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>=' instead of '>' changes the logic.

Using '=' in the first condition causes wrong results.

The formula first checks if E5 is greater than 70, then if equal to 70, else it is less than 70.