Why advanced rules highlight patterns in Google Sheets - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to highlight cells greater than 100.

Google Sheets

=IF(A1 [1] 100, TRUE, FALSE)

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

A<

B<=

C>

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>'

Using '=' which only checks equality

The formula checks if the cell value is greater than 100 to highlight it.

2fill in blank

medium

Complete the formula to highlight cells that equal "Done".

Google Sheets

=IF(A1 [1] "Done", TRUE, FALSE)

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

A>

B=

C<>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<>' which means 'not equal'

Using '>' or '<' which are for numbers

The formula checks if the cell exactly equals the word "Done" to highlight it.

3fill in blank

hard

Fix the error in the formula to highlight cells with values less than or equal to 50.

Google Sheets

=IF(A1 [1] 50, TRUE, FALSE)

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

A>=

B>

C==

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' which means greater than

Using '==' which is not valid in Google Sheets

The correct operator to check 'less than or equal to' is '<='.

4fill in blank

hard

Fill both blanks to highlight cells where the value is between 10 and 20 inclusive.

Google Sheets

=AND(A1 [1] 10, A1 [2] 20)

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

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '<=' for inclusive check

Using '>' instead of '>=' for inclusive check

The formula uses '>= 10' and '<= 20' to check if the value is between 10 and 20 including both ends.

5fill in blank

hard

Fill all three blanks to highlight cells where A1 equals "Pass", B1 is greater than 70, and C1 is TRUE.

Google Sheets

=AND(A1 [1] "Pass", B1 [2] 70, C1 [3] TRUE)

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

A=

B>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' for score check

Using '!=' instead of '=' for text check

The formula checks if A1 equals "Pass", B1 is greater than 70, and C1 is TRUE to highlight the cell.