Skip to main content

Administrative Professional (CAP) · Question

In Microsoft Excel, what function is used to add a range of numbers?

The SUM() function is the standard Excel function for calculating the total of a range of cells.

Start free practice for Administrative Professional (CAP)

200 questions · no signup required · 40 free questions per day

Start Practice →

Question: In Microsoft Excel, what function is used to add a range of numbers?

Answer options: ✅ SUM()

  • ADD()
  • TOTAL()
  • CALCULATE()

Correct answer: SUM()

Explanation: The SUM() function is the standard Excel function for calculating the total of a range of cells.

Start free practice for Administrative Professional (CAP)

200 questions · no signup required · 40 free questions per day

Start Practice →

More about Administrative Professional (CAP)

Related Questions

More for Administrative Professional (CAP) candidates

Ready to practice?

Free, no signup required. Build a wrong-question list as you go.

Start Free Administrative Professional (CAP) Practice →

Related courses

Other Canadian certifications candidates often prepare for alongside this one.