Excel Logical Function Quiz (Excel Logical Function Quiz)

Question 1

Which function tests one condition and returns one result for TRUE and another for FALSE?

Question 2

What does this formula return: =IF(75>=70, "Pass", "Fail")?

Question 3

If the FALSE part is omitted in =IF(A1>0, "Yes"), what appears when A1 is not greater than 0?

Question 4

Which function returns TRUE only when every test inside it is TRUE?

Question 5

What is the result of =AND(10>5, 2<1)?

Question 6

Which function returns TRUE when at least one condition is TRUE?

Question 7

What does =OR(A1="Yes", B1="Yes") do?

Question 8

Which function flips TRUE to FALSE and FALSE to TRUE?

Question 9

If A1 contains "Done", what does =NOT(A1="Done") return?

Question 10

Which function is designed to handle several conditions in order without nesting many IF statements?

Question 11

Why do many IFS formulas end with TRUE as the final test?

Question 12

What does this formula return for a score of 85: =IFS(B2>=90,"A", B2>=80,"B", B2>=70,"C", TRUE,"F")?

Question 13

Which function is best when you want to compare one value against a list of exact matches like codes or status labels?

Question 14

What does this formula return: =SWITCH("U", "A", "Admin", "U", "User", "Guest")?

Question 15

In SWITCH, what is the purpose of the last unmatched argument like "Guest" in =SWITCH(B2,"A","Admin","U","User","Guest")?

Question 16

Why would someone use SWITCH(TRUE, ...) instead of a normal SWITCH(value, ...)?

Question 17

Which function replaces any Excel error with a fallback result you choose?

Question 18

What does =IFERROR(100/0, 0) return?

Question 19

Which function is better when you want to handle only missing lookup results but still see structural problems like #REF!?

Question 20

What kind of error is IFNA designed to catch?

Question 21

What does XOR return when exactly one condition is TRUE?

Question 22

Which function simply returns the logical constant TRUE with no test needed?

Question 23

Which function returns the logical constant FALSE with no condition required?

Question 24

In Excel math, what number does TRUE usually behave like?

Question 25

Excel Logical Function Quiz