Skip to main content

Administrative Professional (CAP) · Question

In Microsoft Excel, what function would you use to calculate the average of a range of numbers?

The AVERAGE function in Excel calculates the arithmetic mean of a range of cells, providing the average value.

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 would you use to calculate the average of a range of numbers?

Answer options: ✅ AVERAGE()

  • SUM()
  • COUNT()
  • MEAN()

Correct answer: AVERAGE()

Explanation: The AVERAGE function in Excel calculates the arithmetic mean of a range of cells, providing the average value.

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.