ЁЯУв Too many exams? DonтАЩt know which one suits you best? Book Your Free Expert ЁЯСЙ call Now!

    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
    More Important Computer Questions Questions

    Relevant for Exams:

    ask-question

    Not sure which exam is best for you Talk to our expert

    Get My Free Call