Administrative Professional (CAP) · Question
In Excel, the function to sum a range only when cells meet a criterion is:
SUMIF sums based on a single criterion.
Start free practice for Administrative Professional (CAP)
200 questions · no signup required · 40 free questions per day
Question: In Excel, the function to sum a range only when cells meet a criterion is:
Answer options:
- SUM ✅ SUMIF
- COUNTIF
- VLOOKUP
Correct answer: SUMIF
Explanation: SUMIF sums based on a single criterion.
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.