Which formula would result in TRUE if C4 is less than 10 and D4 is le…

The correct answer is Option (4) → = AND (C4 < 10, D4 < 100)

The AND function returns TRUE only when every condition is true. “C4 is less than 10” is C4<10 and “D4 is less than 100” is D4<100, so the formula is =AND(C4<10, D4<100).