Which formula would result in TRUE if C4 is less than 10 and D4 is less than 100?
Answer & explanation
Correct answer: option 4
The correct answer is Option (4) → =AND(C4<10, D4<100).
The AND function returns TRUE only when every condition in it is TRUE, and FALSE if even one is FALSE. So the formula must test both conditions of the question, “C4 is less than 10” and “D4 is less than 100”, with the right cells and the < sign: =AND(C4<10, D4<100).
Why the other options are incorrect
Option (1) =AND(C4>10, D4>10). — Incorrect. Both signs are reversed and the limit for D4 is wrong; it tests for C4 and D4 greater than 10.
Option (2) =AND(C4>10, C4<100). — Incorrect. It tests only C4, for a value between 10 and 100, and never looks at D4.
Option (3) =AND(C4>10, D4<10). — Incorrect. The sign for C4 is reversed and D4 is compared with 10 instead of 100.
NCERT (2026-27 edition):
|
