Logical Functions (IF, AND, OR) MCQs – CBSE Class 10 Exam Practice
Logical Functions (IF, AND, OR) MCQs – CBSE Class 10 Exam Practice
Class: 10
Subject: Computer Science
Unit: Unit 2 – Electronic Spreadsheet
Topic: Logical Functions (IF, AND, OR)
Board: CBSE Board Examinations (NCERT Based)
Q1. The IF function is classified as which type of function?
Answer: B. Logical
IF evaluates a condition and returns one value if true and another if false.
IF evaluates a condition and returns one value if true and another if false.
Q2. Basic syntax of IF function is?
Answer: C
Correct syntax: =IF(condition, value_if_true, value_if_false).
Correct syntax: =IF(condition, value_if_true, value_if_false).
Q3. =IF(A1>50,"Pass","Fail") checks?
Answer: B
The condition A1>50 is logically tested.
The condition A1>50 is logically tested.
Q4. AND function returns TRUE when?
Answer: B
AND returns TRUE only if every condition is satisfied.
AND returns TRUE only if every condition is satisfied.
Q5. OR function returns TRUE when?
Answer: B
OR returns TRUE if at least one condition is true.
OR returns TRUE if at least one condition is true.
Q6. =AND(A1>10,B1<5) is TRUE if?
Answer: A
AND requires both logical tests to be true.
AND requires both logical tests to be true.
Q7. Nested IF means?
Answer: B
Nested IF allows multiple conditions within one formula.
Nested IF allows multiple conditions within one formula.
Q8. IF function can return?
Answer: D
IF can return text, numeric, or logical results.
IF can return text, numeric, or logical results.
Q9. =OR(FALSE,TRUE) returns?
Answer: A
At least one TRUE makes OR TRUE.
At least one TRUE makes OR TRUE.
Q10. =AND(TRUE,FALSE) returns?
Answer: B
All conditions must be TRUE for AND.
All conditions must be TRUE for AND.
Q11. Logical operators include?
Answer: D
Comparison operators are used in logical tests.
Comparison operators are used in logical tests.
Q12. IF without false value returns?
Answer: C
If omitted, it may return FALSE or blank depending on software.
If omitted, it may return FALSE or blank depending on software.
Q13. AND can combine how many conditions?
Answer: C
AND supports multiple logical arguments.
AND supports multiple logical arguments.
Q14. OR supports multiple conditions?
Answer: A
OR can test multiple logical expressions.
OR can test multiple logical expressions.
Q15. Logical result values are?
Answer: C
Logical functions return TRUE or FALSE.
Logical functions return TRUE or FALSE.
Q16. =IF(A1=10,100,0) returns 100 when?
Answer: B
Condition must evaluate TRUE.
Condition must evaluate TRUE.
Q17. Combining IF with AND is used for?
Answer: A
Used to evaluate more than one condition.
Used to evaluate more than one condition.
Q18. =IF(AND(A1>50,B1>50),"Pass","Fail") means?
Answer: B
Both conditions must be true.
Both conditions must be true.
Q19. Logical functions are mainly used for?
Answer: A
They help in decision-based calculations.
They help in decision-based calculations.
Q20. IF function belongs to which category in Function Wizard?
Answer: A
IF is listed under Logical functions.
IF is listed under Logical functions.
