Administrative Professional (CAP) · Question
In Microsoft Excel, what function is used to sum a range of cells that meet specific criteria?
The SUMIF function in Excel is specifically designed to add up numbers in a range that meet a single specified condition.
Start free practice for Administrative Professional (CAP)
200 questions · no signup required · 40 free questions per day
Question: In Microsoft Excel, what function is used to sum a range of cells that meet specific criteria?
Answer options: ✅ SUMIF
- SUM
- COUNTIF
- AVERAGEIF
Correct answer: SUMIF
Explanation: The SUMIF function in Excel is specifically designed to add up numbers in a range that meet a single specified condition.
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.