Home »
MCQs »
Microsoft Excel MCQs
Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?
16. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?
- OR
- AND
- IF
- ANDIF
Answer: B) AND
Explanation:
The AND() function is used to test multiple conditions and returns TRUE if all arguments evaluate TRUE; FALSE if not.
Syntax:
=AND (logical1, [logical2], ...)