Title: Using relational operators in Excel

Question 1

Answer this question before your proceed

Q: The result of a relational operator comparison in Excel is a numerical value
A: false
If right: Yes, you got it!
If wrong: No, the the result of a relational operator comparison in Excel is either true or false.

Question 2

Answer this question before you continue

Q: The result of the formula =B3<C3 where cell B3=5 and cell C3=4 is _________
- False (correct) (Well done!) (if not chosen: No, you can try again)
- Error (No, you can try again)
- True (No, you can try again)
- Equal (No, you can try again)

Question 4

Answer the question before you proceed

Q: An AND function returns a value of TRUE if _______________
- All arguments in the function are TRUE (correct) (Yes, you're correct!) (if not chosen: No, you can try again)
- One or more of the arguments in the function are TRUE (No, you can try again)
- All arguments in the function are FALSE (No, you can try again)
- One or more of the arguments in the function are TRUE (No, you can try again)

Question 5

Try this question to proceed

Q: Using the formula =NOT(J10:J26) will result in an answer of _____________ if all cells in the range are TRUE
- ​​​​​​None of the above (correct) (Well done!) (if not chosen: Incorrect, plese try again)
- True (Incorrect, plese try again)
- False (Incorrect, plese try again)
- Sum

Question 5

Almost nearing the end, answer this question

Q: The NOT function changes a true value to false and a false value to true
A: true
If right: Yes, you got it
If wrong: No, the NOT function changes a true value to false and vice versa

Question 3

Answer the question before you proceed

Q: To test whether at least one condition is met, you should use the ___________ function
- OR (correct) (Yes, you got it!) (if not chosen: No, try again)
- AND (No, try again)
- NOT (No, try again)
- IF (No, try again)

Recap

=OR(FALSE,TRUE,TRUE) results in the final value of _______________

- TRUE (correct)
- FALSE
- #VALUE

- AND Boolean function requires all arguments to be true for the result to be true (correct)
- OR Boolean function requires all arguments to be true for the result to be true
- NOT Boolean function requires all arguments to be true for the result to be true

- You can use the Boolean logical functions AND, OR, and NOT to evaluate data. (correct)
- You can use the Relational logical functions AND, OR, and NOT to evaluate data.
- You can use the IF logical functions AND, OR, and NOT to evaluate data.

- The OR function evaluates a list of logical arguments to determine if at least one of the arguments is TRUE (correct)
- The AND function evaluates a list of logical arguments to determine if at least one of the arguments is TRUE
- The NOT function evaluates a list of logical arguments to determine if at least one of the arguments is TRUE