Match the List I with List II

LIST-I (Statistical functions in MS-Excel)		LIST-II (Return value)
A.	Average	I.	Returns the number of entries in a selected range
B.	Count	II.	Returns the value in the middle of the range
C.	Median	III.	Returns the value that occurs most frequently
D.	Mode	IV.	Returns the total of all the values in range divided by the number of values in the range

Choose the correct answer from the options given below:

Correct option is B

• A. Average: The average function returns the total sum of the values in a given range divided by the number of values. This corresponds to IV.

• B. Count: The Count function in Excel counts the number of cells that contain numbers in a selected range, so it corresponds to I.

• C. Median: The Median function returns the middle value of the data when it is arranged in ascending order, corresponding to II.

• D. Mode: The Mode function returns the most frequently occurring value in a dataset, so it matches with III.

Information Booster:

1. Average is useful for finding the central tendency of data, giving an overall sense of the typical value in a dataset.

2. Count helps to quickly count the number of entries in a dataset that are numerical, excluding empty or non-numeric cells.

3. Median is useful when you want to determine the middle point of your data, especially in cases where the data is skewed, and the mean might not be representative.

4. Mode helps in finding the most frequent value, which is useful in identifying common patterns or trends in data.