Which of the following MS Excel functions is used to count the number of cells based on condition?

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:

1. Syntax of COUNTIF:
   $=COUNTIF(range,condition)$
2. Example:
   If cells A1:A10 contain numbers, and you want to count cells with values > 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.