Which formula is true if C4 is less than

CUET Preparation Today

Start Free Mocks

Home Questions E6JK9KCUGC

Target Exam

CUET

Subject

-- Accountancy Part C

Chapter

Use of Spreadsheet in Business Applications

Question:

Which formula is true if C4 is less than 10 and D4 is less than 100?

Options:

=AND(C4>10, D4>10).

=AND(C4>10, C4<100)

=AND(C4>10, D4<10)

=AND(C4<10, D4<100).

Correct Answer:

=AND(C4<10, D4<100).

Explanation:

The correct answer is option 4- =AND(C4<10, D4<100).

The AND function returns TRUE only if all the conditions inside it are TRUE.

The formula to be true when: