It Is ________ Best to Use References to Cell Rather

question 13

Multiple Choice

It is ________ best to use references to cell rather than number in your spreadsheet formulas.

• A) rarely
• B) never
• C) sometimes
• D) always
• E) usually

---

Definitions:

Range

The difference between the highest and lowest values in a dataset, providing a measure of data dispersion.

Variance

A statistical measure that quantifies the spread or dispersion of a set of data points around their mean value.

Percentile

A value in a data set below which a certain percentage of observations fall.

STDEV.P(data range)

A function in spreadsheet software that calculates the standard deviation of a dataset, considering the entire population.