Logical functions (IF, AND, OR, NOT) – Excel MCQs

1 Which function in Excel returns one value if a condition is true and another value if it is false? a) OR b) AND c) IF d) NOT Answer: c) IF 2 What is the result of the formula =AND(TRUE, FALSE)? a) TRUE b) FALSE c) #VALUE! d) #ERROR Answer: b) FALSE 3 Which function in Excel is used to check if a condition is not met? a) IF b) AND c) OR d) NOT Answer: d) NOT 4 What is the result of the formula =OR(FALSE, FALSE, TRUE)? a) TRUE b) FALSE c) #VALUE! d) #ERROR Answer: a) TRUE 5 In which scenario would you use the AND function? a) To check if at least one condition is true b) To check if all conditions are true c) To check if a condition is not true d) To combine text values Answer: b) To check if all conditions are true 6 What is the result of the formula =IF(A1>10, “Yes”, “No”) when A1 is 12? a) Yes b) No c) #VALUE! d) #ERROR Answer: a) Yes 7 Which of the following formulas will return TRUE? a) =NOT(TRUE) b) =IF(AND(FALSE, TRUE), “Yes”, “No”) c) =OR(FALSE, TRUE) d) =IF(NOT(FALSE), “Yes”, “No”) Answer: c) =OR(FALSE, TRUE) 8 How does the formula =IF(AND(A1>5, B1<10), “In Range”, “Out of Range”) work when A1 is 7 and B1 is 12? a) In Range b) Out of Range c) #VALUE! d) #ERROR Answer: b) Out of Range 9 Which logical function is used to combine multiple conditions where at least one condition must be true? a) IF b) AND c) OR d) NOT Answer: c) OR 10 What is the result of the formula =NOT(OR(FALSE, FALSE, FALSE))? a) TRUE b) FALSE c) #VALUE! d) #ERROR Answer: a) TRUE