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
×
×