Question

    Excel formula to calculate average of B1 to B10

    is?
    A =AVG(B1:B10) Correct Answer Incorrect Answer
    B =MEAN(B1:B10) Correct Answer Incorrect Answer
    C =AVERAGE(B1:B10) Correct Answer Incorrect Answer
    D =SUM(B1:B10)/10 Correct Answer Incorrect Answer
    E =B1+B10/2 Correct Answer Incorrect Answer

    Solution

    The correct function to calculate the average in Excel is =AVERAGE(range).

    Practice Next

    Relevant for Exams: