Which of the Following Excel Functions Is Used to Facilitate

question 34

Multiple Choice

Which of the following Excel functions is used to facilitate quick accuracy checks on the extreme values?

• A) AVERAGE
• B) SMALL
• C) MEDIAN
• D) STDEV
• E) QUARTILE

---

Definitions:

Standard Deviation

A measure of the amount of variation or dispersion of a set of values, indicating how much the values deviate from the mean.

Returns

Returns are the profits or losses generated from an investment over a specified period, often expressed as a percentage of the initial investment amount.

Risk

The possibility of loss or another adverse outcome resulting from a particular action or event.

Negatively Skewed Distribution

A probability distribution that is skewed to the left, indicating that the tail on the left side of the probability density function is longer or fatter than the right side.