The following data is entered in the cells of an Excel sheet ranging from L1 to

Question

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

Explanation / Answer

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

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.