What does the function COUNT() do in MS Excel 2010?

Correct option is C

The COUNT() function in MS Excel 2010 is used to count the number of cells that contain numerical data in a selected range. It does not count empty cells or those containing text. This function is useful when analyzing data, especially when you need to know how many cells in a particular range contain numbers.
Important Key Points:
1. Numerical Data Counting: The COUNT() function specifically counts the number of cells with numeric values.
2. Excludes Non-Numeric Data: Cells that contain text, logical values, or are empty are not counted by the COUNT() function.
3. Commonly Used in Data Analysis: This function helps users determine the total number of numerical entries in a range, making it valuable for statistical calculations.
4. Syntax: COUNT(range) - where 'range' is the group of cells to be evaluated.
Knowledge Booster:
· Duplicates the number of cells: This is not a function of COUNT(). It does not duplicate or replicate any cells.
· Prints the number of cells: The COUNT() function does not print anything; it only returns the number of cells that contain numbers.
· Stores the number of cells: The COUNT() function does not store values; it simply counts and returns the result for the specified range.