πŸ“’ 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