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

Multiple Choice

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)