📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    Question

    What does the AVERAGEIF function do in

    Excel?
    A Calculates the average of a range of cells that meet specified criteria Correct Answer Incorrect Answer
    B Returns the average of the smallest values in a range of cells Correct Answer Incorrect Answer
    C Counts the number of cells in a range that are not empty Correct Answer Incorrect Answer
    D Returns the average of the largest values in a range of cells Correct Answer Incorrect Answer
    E None of these Correct Answer Incorrect Answer

    Solution

    The AVERAGEIF function in Excel calculates the average of a range of cells that meet specified criteria.

    Practice Next
    More MS Office Questions

    Relevant for Exams:

    ask-question