Recall & Review
beginner
What does the OR function do in Excel?
The OR function checks if any of the given conditions are TRUE. It returns TRUE if at least one condition is TRUE, otherwise it returns FALSE.
Click to reveal answer
beginner
Write the syntax of the OR function.
OR(logical1, [logical2], ...)
Where each logical argument is a condition you want to test.
Click to reveal answer
beginner
Example: What is the result of =OR(5>3, 2=4)?
The result is TRUE because 5>3 is TRUE, even though 2=4 is FALSE. OR returns TRUE if any condition is TRUE.
Click to reveal answer
beginner
Can OR function handle more than two conditions?
Yes, OR can check many conditions at once. For example, =OR(A1>10, B1<5, C1=7) checks three conditions.
Click to reveal answer
beginner
How is OR function useful in real life?
You can use OR to check if any one of several things is true. For example, if a student passes any one subject, OR can help decide if they pass overall.
Click to reveal answer
What does =OR(FALSE, FALSE, TRUE) return?
✗ Incorrect
OR returns TRUE if any argument is TRUE. Here, one argument is TRUE, so the result is TRUE.
Which of these is the correct syntax for OR function?
✗ Incorrect
The correct syntax uses parentheses and commas: OR(condition1, condition2).
If all conditions in OR are FALSE, what is the result?
✗ Incorrect
OR returns FALSE only if all conditions are FALSE.
Can OR function be used with text comparisons like =OR(A1="Yes", B1="No")?
✗ Incorrect
OR works with any logical condition, including text comparisons.
What will =OR(3>5, 2=2, 4<1) return?
✗ Incorrect
2=2 is TRUE, so OR returns TRUE.
Explain how the OR function works and give a simple example.
Think about checking if at least one thing is true.
You got /3 concepts.
Describe a real-life situation where you might use the OR function in a spreadsheet.
Imagine checking if any one of several things happened.
You got /3 concepts.