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


    Question

    Which of the following formulas correctly calculates

    the sum of values in cells A1 to A5 in Excel?
    A =SUM(A1+A2+A3+A4+A5) Correct Answer Incorrect Answer
    B =ADD(A1:A5) Correct Answer Incorrect Answer
    C =SUM(A1:A5) Correct Answer Incorrect Answer
    D =TOTAL(A1,A2,A3,A4,A5) Correct Answer Incorrect Answer
    E =SUM(A1-A5) Correct Answer Incorrect Answer

    Solution

    =SUM(A1:A5)

    Practice Next
    ask-question

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

    Get My Free Call