0
0
Excelspreadsheet~10 mins

Conditional formatting basics in Excel - Interactive Code Practice

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Practice - 5 Tasks
Answer the questions below
1fill in blank
easy

Complete the formula to highlight cells greater than 100.

Excel
=A1 [1] 100
Drag options to blanks, or click blank then click option'
A<>
B<
C=
D>
Attempts:
3 left
💡 Hint
Common Mistakes
Using '<' instead of '>' will highlight smaller numbers.
Using '=' will only highlight cells equal to 100.
2fill in blank
medium

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

Excel
=A1 [1] "Done"
Drag options to blanks, or click blank then click option'
A=
B<
C<>
D>
Attempts:
3 left
💡 Hint
Common Mistakes
Using '>' or '<' operators with text causes errors.
Forgetting quotes around the text "Done".
3fill in blank
hard

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

Excel
=A1 [1] 50
Drag options to blanks, or click blank then click option'
A<=
B>=
C<
Attempts:
3 left
💡 Hint
Common Mistakes
Using '>=' instead of '<=' causes a syntax error.
Using only '<' excludes the value 50.
4fill in blank
hard

Fill both blanks to highlight cells with values between 10 and 20 (inclusive).

Excel
=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 '<=' excludes 20.
Using '>' instead of '>=' excludes 10.
5fill in blank
hard

Fill the blanks to highlight cells that are either blank or contain the text "N/A".

Excel
=OR(ISBLANK(A1), A1 [1] [2])
Drag options to blanks, or click blank then click option'
A=
B"N/A"
CISBLANK(A1)
D<>
Attempts:
3 left
💡 Hint
Common Mistakes
Using '<>' instead of '=' changes the logic.
Not using quotes around "N/A" causes errors.