In Microsoft Excel,a function that returns TRUE if all conditions are true,and FALSE if not,is ________.
A)MAX(range)
B)COUNT(range)
C)AND(condition 1,condition 2…)
D)COUNTIF(range,criteria)

Question

Quizplus · Accepted Answer

The AND function is designed to return a boolean TRUE if all conditions are true, and FALSE if at least one of them is false. It can be used to evaluate multiple criteria and conditions within a formula. MAX and COUNT functions are not relevant for returning TRUE or FALSE based on multiple conditions, and COUNTIF is used to count the number of cells within a range that meet a certain criteria.

In Microsoft Excel,a Function That Returns TRUE If All Conditions