Home » MCQs » Data Analytics and Visualization MCQs

The ___ function applies one or more conditions in the specified range of data and returns only those which fulfill all of the conditions

8. The ___ function applies one or more conditions in the specified range of data and returns only those which fulfill all of the conditions.

1. COUNTIFS
2. COUNT
3. IF
4. None of the mentioned above

Answer: A) COUNTIFS

Explanation:

The COUNTIFS function applies one or more conditions in the specified range of data and returns only those which fulfill all of the conditions.