When You Use a Named Range in a Formula, It

question 314

Multiple Choice

When you use a named range in a formula, it becomes a(n) _____ reference by default.

• A) external
• B) 3-D
• C) absolute
• D) relative

---

Definitions:

Interquartile Range

A measure of variability, defined as the difference between the first and third quartiles, describing the middle 50% of a data set.

25th Percentile

A value below which 25% of the data falls.

75th Percentile

A value below which 75% of the data points in a dataset fall, used as a measure of dispersion.

Symmetric Data

Data that are evenly distributed around the center, showing mirror-image properties on both sides of the median.