Which of the Following Excel Functions Will Calculate the Mean $= A V G ( A 1 : A 9 )$

question 27

Short Answer

Which of the following Excel functions will calculate the mean value of the data in cells A1 through A9? a. $= A V G ( A 1 : A 9 )$
b. $= A V E ( A 1 : A 9 )$
c. =AVERAGE $( A 1 : A 9 )$
d. $= \operatorname { MEAN } ( \mathrm { A } 1 : \mathrm { A } 9 )$

---

Definitions:

Competence

The ability to do something successfully or efficiently, often relating to a specific skill or knowledge set.

Intrinsic Motivation

The drive to engage in activities for their own sake, for the satisfaction and pleasure derived from the activity itself, rather than for some external reward.

Extrinsic Motivation

Motivation that is driven by external rewards such as money, fame, grades, or praise, in contrast to intrinsic motivation, which is driven by personal satisfaction or interest.

Extrinsic Motivation

Encouragement stemming from external factors including wealth, recognition, scores, and compliments.