Multiple choice general knowledge science & technology

Which of the below formulas add cells a1 through a5 in Microsoft Excel?

  1. =sum(A1+A5)

  2. =sum(A1:A5)

  3. =add(A1+A5)

  4. =total(A1:A5)

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The question asks which formula correctly adds cells A1 through A5 in Excel. =SUM(A1:A5) is the correct syntax - the colon creates a range from A1 to A5 which SUM then totals. =SUM(A1+A5) would only add two cells (A1 and A5), and ADD and TOTAL are not valid Excel functions.