Which of the following is a basic formula to add numbers in Excel?

A. =SUM(A1)
B. =ADD(A1)
C. =PLUS(A1)
D. =TOTAL(A1)
Correct Answer: A. =SUM(A1)

Correct answer: =SUM(A1). The basic formula to add numbers in Excel is =SUM(A1).

Background: In Excel, the SUM function adds numbers. =SUM(A1) adds the value in cell A1.

  • =ADD(A1): ADD is not an Excel function.
  • =PLUS(A1): PLUS is not an Excel function.
  • =TOTAL(A1): TOTAL is not an Excel function.

Did you know? =SUM(A1:A10) adds all the numbers from A1 to A10.

Memory trick: Add means SUM.

0 comments

Leave a Reply