Why logical functions enable decision-making in Excel - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

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

Excel

=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 '>' changes the logic.

Using '=' checks for equality, not greater than.

The '>' operator checks if A1 is greater than 10, which is needed for this decision.

2fill in blank

medium

Complete the formula to return "Pass" if score in B2 is 50 or more, otherwise "Fail".

Excel

=IF(B2 [1] 50, "Pass", "Fail")

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

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' excludes the value 50 itself.

Using '<=' reverses the logic.

The '>=' operator checks if B2 is 50 or more, which fits the pass condition.

3fill in blank

hard

Fix the error in the formula to check if C3 is exactly 100.

Excel

=IF(C3 [1] 100, "Correct", "Wrong")

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

A===

B==

C=

D<>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' or '===' causes a formula error in Excel.

Using '<>' means 'not equal', which is the opposite.

In Excel, '=' is used for equality checks inside IF formulas, not '==' or '==='.

4fill in blank

hard

Fill both blanks to create a formula that returns "Adult" if age in D4 is 18 or more, else "Minor".

Excel

=IF(D4 [1] 18, "Adult", [2])

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

A>=

B"Minor"

C"Child"

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' in the first blank reverses the logic.

Forgetting quotes around text values causes errors.

The '>=' operator checks if age is 18 or more, and the else part returns "Minor".

5fill in blank

hard

Fill all three blanks to create a formula that returns uppercase name if score in E5 is above 80, else "Try Again".

Excel

=IF(E5 [1] 80, [2](F5), [3])

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

A>

BUPPER

C"Try Again"

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<=' reverses the condition.

Not using UPPER function for uppercase conversion.

Forgetting quotes around "Try Again".

The formula checks if E5 is greater than 80, then converts F5 to uppercase using UPPER, else returns "Try Again".