Microsoft Excel Function and Formula Overview
which function returns the average of all the cells in a range that meet given criteria in MS Excel 2016
Answer: AVERAGEIF
Explanation
The AVERAGEIF function returns the average of cells in a range that meet the criteria you provide.
****
ND20-1-2023
This question appeared in
Past Papers (4 times)
IBA STS Past Papers, Syllabus, Jobs (1 times)
PPSC 5 Years Past Papers Subject Wise (Solved with Details) (2 times)
PPSC Past Papers (1 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- Which of following function is used to sum the values in a range that meet criteria that you specify
- Which of the following functions is used to calculate the average of a range of cells in Excel?
- The ______ function in Excel returns the highest value in a set of data that you specify.
- Which formula is used to find the number of numerical cells in a range of cells in Excel?
- How to duplicate values in cell range in Excel 2016?
- How can you sum up a range of cells in Excel?
- Where can you set the shading color of a range of cells in excel ?
- MS Excel's _____ function allows you to add the numbers in multiple cells.
- Which function is used in Excel to count numeric values in a range?
- Which of following function in Microsoft Excel is used to count items in a cell range?
