New Click Here to Play Diwali Spin and Win and Get Huge Discounts

    Register

    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