Asked in PPSC, FPSC and other one-paper exams (compiled from unofficial resources).
Microsoft Office & ProductivityMS Excel
Which function in MS Excel 2016 calculates the average of all the cells in a range that meet specified criteria?
- A.SUMAVERAGE
- B.AVERAGEIFS
- C.DAVERAGE
- D.AVERAGEIFCorrect answer
Timed quizzes, instant results, track your progress — free
Practice these MCQs in the appQuick fact: The AVERAGEIF function in MS Excel 2016 calculates the average of cells in a range that meet a single specified criterion.