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 number of values in the range |
Choose the correct answer from the options given below:
1
A - II, B - III, C - I, D - IV
2
A - IV, B - I, C - II, D - III
3
A - I, B - IV, C - II, D - III
4
A - II, B - III, C - IV, D - I