Administrative Professional (CAP) · Question
In Microsoft Excel, which function is used to calculate the sum of a range of cells?
The SUM() function is the standard Excel function used to add up all the numbers in a specified range of cells. It is fundamental for calculations.
Start free practice for Administrative Professional (CAP)
200 questions · no signup required · 40 free questions per day
Question: In Microsoft Excel, which function is used to calculate the sum of a range of cells?
Answer options: ✅ SUM()
- TOTAL()
- ADD()
- CALCULATE()
Correct answer: SUM()
Explanation: The SUM() function is the standard Excel function used to add up all the numbers in a specified range of cells. It is fundamental for calculations.
Start free practice for Administrative Professional (CAP)
200 questions · no signup required · 40 free questions per day
More about Administrative Professional (CAP)
Related Questions
- Which tab in Microsoft PowerPoint is used to apply predefined animation effects to individual objects on a sli
- When writing an internal memo, what tone is generally most appropriate?
- What is the primary purpose of a 'register' in records management?
- Which of the following is an example of an open-ended question?
- What is the purpose of using 'track changes' in Microsoft Word?
- In Microsoft PowerPoint, what feature allows you to display your slides on a projector while viewing your note
More for Administrative Professional (CAP) candidates
FAQs
Question explanations
- Which tab in Microsoft PowerPoint is used to apply predefined animation effects to individual objects on a sli
- When writing an internal memo, what tone is generally most appropriate?
- What is the primary purpose of a 'register' in records management?
- Which of the following is an example of an open-ended question?
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.