ECDL Exam ECDL-ADVANCED Topic 1 Question 30 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 30
Topic #: 1

Which of the following functions is used to add all numbers in a range of cells, based on a given criteria?

ASumSq()

BSumProduct()

CSumIf()

DSum()
Explanation:
The SumIf function is used to add all numbers in a range of cells, based on a given criteria.
Answer option B is incorrect. The SumProduct function is used to multiply the corresponding items in the arrays and return the sum of the results.
Answer option A is incorrect. The SumSq function is used to return the sum of the squares of a series of values.
Answer option D is incorrect. The Sum function is used to add all numbers in a range of cells and return the result.

Show Suggested Answer

Suggested Answer: C

Chapter: ADVANCED SPREADSHEETS

Objective: Functions

by Corinne at May 07, 2022, 03:34 AM

Limited Time Offer

25%

Off

Get Premium ECDL-ADVANCED Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!