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