Correct option is B
The COUNTIF function in MS Excel is used to count the number of cells that satisfy a specific condition or criteria.
Information Booster:
- Syntax of COUNTIF:
=COUNTIF(range,condition)=COUNTIF(range, condition)=COUNTIF(range,condition) - Example:
If cells A1:A10 contain numbers, and you want to count cells with values > 50:
=COUNTIF(A1:A10,">50")=COUNTIF(A1:A10, ">50")=COUNTIF(A1:A10,">50")
Additional Knowledge:
- COUNT: Counts all numerical values in a range.
- COUNTWHEN: Incorrect; no such function exists in Excel.
- COUTON: Incorrect term.
English
100 Questions
100 Marks
60 Mins
