Homework SourseThe following data is entered in the cells of an Excel sheet
The following data is entered in the cells of an Excel sheet ranging from L1 to L5: 16, 9, 11, 15, 12. What will be the output of the following function?
=AVERAGEIF(L1:L5,\">13\")
A. 15.5
B. 8.6
C. 17.3
D. 7.5
E. 18.5
The following data is entered in the cells of an Excel sheet ranging from L1 to L5: 16, 9, 11, 15, 12. What will be the output of the following function?
=AVERAGEIF(L1:L5,\">13\")
A. 15.5
B. 8.6
C. 17.3
D. 7.5
E. 18.5
=AVERAGEIF(L1:L5,\">13\")
A. 15.5
B. 8.6
C. 17.3
D. 7.5
E. 18.5
Solution
The Excel function AVERAGEIF gives the arithmetic mean of the given range of values pertaining to certain specified criteria.
Here the range of data is L1:L5 (which contains numbers, 16, 19, 11, 15 and 12) and the criteria is \" > 13 \".
The Excel will generate the following output,
AVERAGEIF (16, 9, 11, 15, 12) = 15.5
Therefore, correct answer is A. 15.5
