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