PREMIUM
Join our WhatsApp Channel
Daily MCQs, Past Papers & Jobs for PPSC, FPSC, CSS
Daily MCQs • Past Papers • Jobs for PPSC, FPSC, CSS
Join Channel

Which formula is used to add numbers in Excel?

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

Correct answer: =SUM(). In Excel, the SUM function adds numbers, for example =SUM(A1:A5) adds the values in cells A1 to A5.

Background: Excel formulas always begin with an equals sign, and SUM is the most used function for totals in accounts, marks and budgets.

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

Did you know? Excel has hundreds of built-in functions, including AVERAGE, MAX and MIN.

Memory trick: Add them up = SUM them up.

0 comments

Leave a Reply

Join Our WhatsApp Channel ×