AND_OR Excel Functions Quiz

What does the AND function return when all the conditions are TRUE?

• TRUE

• FALSE

• 0

• 1

Which of the following best describes the OR function in Excel?

• It returns TRUE if all conditions are TRUE.

• It returns FALSE if at least one condition is TRUE.

• It returns TRUE if at least one condition is TRUE.

• It returns FALSE if all conditions are FALSE.

Which of the following formulas will return FALSE if both conditions are FALSE?

• =AND(FALSE, TRUE)

• =AND(TRUE, TRUE)

• =OR(TRUE, FALSE)

• =OR(FALSE, FALSE)

What result does the formula =AND(3>2, 4>5) return?

• TRUE

• FALSE

• Error

• 1

If you have the formula =OR(5<3, 7=7), what will Excel return?

• TRUE

• FALSE

• Error

• #VALUE!

What does the AND function return when one or more of the conditions are FALSE?

• TRUE

• FALSE

• Error

• Blank

Which of these functions can be used to check if at least one of several conditions is TRUE in Excel?

• SUM

• AND

• OR

• IF

What will the formula =AND(5=5, "Apple"="Banana") return?

• TRUE

• FALSE

• #VALUE!

• Error

Which of the following formulas correctly checks if the value in cell A1 is either greater than 10 or less than 5?

• =AND(A1>10, A1<5)

• =OR(A1>10, A1<5)

• =OR(A1>=10, A1<=5)

• =AND(A1>10, A1<5)

What does the OR function return when all conditions are FALSE?

• TRUE

• FALSE

• #VALUE!

• Error