OR function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to check if either A1 or B1 is TRUE using the OR function.

Excel

=OR([1])

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

AA1, B1

BA1 B1

CA1; B1

DA1+B1

Attempts:

3 left

💡 Hint

Common Mistakes

Using spaces or plus signs instead of commas between arguments.

Using semicolons which are not valid separators in Excel formulas.

The OR function takes arguments separated by commas. So =OR(A1, B1) checks if either A1 or B1 is TRUE.

2fill in blank

medium

Complete the formula to check if the value in C2 is greater than 10 or less than 5.

Excel

=OR(C2 [1] 10, C2 [2] 5)

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

A!=

B<

C=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong comparison operator like '=' or '<' for the first condition.

Confusing greater than and less than operators.

The formula should check if C2 is greater than 10 or less than 5. The first comparison is C2 > 10 and the second is C2 < 5.

3fill in blank

hard

Fix the error in the formula to correctly check if D3 equals 5 or 10 using OR.

Excel

=OR(D3=[1], D3=10)

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

A5

B"5"

C5.0

Dfive

Attempts:

3 left

💡 Hint

Common Mistakes

Putting numbers inside quotes, which makes them text.

Using words like 'five' instead of numbers.

Since D3 contains a number, use the number 5 without quotes. So D3=5 is correct.

4fill in blank

hard

Fill both blanks to create a formula that checks if E1 is less than 0 or greater than 100.

Excel

=OR(E1 [1] 0, E1 [2] 100)

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

A<

B>

C=

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using equals or less than or equal operators instead of strict less than or greater than.

The formula checks if E1 is less than 0 or greater than 100, so use < and > respectively.

5fill in blank

hard

Fill all three blanks to create a formula that checks if F2 is equal to 1, 2, or 3 using OR.

Excel

=OR(F2=[1], F2=[2], F2=[3])

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

A1

B2

C3

D4

Attempts:

3 left

💡 Hint

Common Mistakes

Including numbers outside the range 1 to 3.

Using text instead of numbers.

The formula checks if F2 equals 1, 2, or 3, so fill blanks with 1, 2, and 3 respectively.