ECDL Exam ECDL-ADVANCED Topic 7 Question 51 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 51
Topic #: 7

Which of the following functions is used to return the average of its arguments, including numbers, text, and logical values?

AAVEDEV

BDELTA

CAVERAGEA

DAVERAGE

Show Suggested Answer

Suggested Answer: C

The AVERAGEA function is used to return the average of its arguments, including numbers, text, and logical values.

Answer option A is incorrect. It is used to return the average of the absolute deviations of data points from their mean.

Answer option D is incorrect. It is used to return the average of its arguments.

Answer option B is incorrect. It is used to test whether two values are equal.

Chapter: ADVANCED SPREADSHEETS

Objective: Functions

by Solange at May 09, 2022, 03:07 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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