Stephanie Added Data Validation to a Worksheet Column After Entering

question 338

Multiple Choice

Stephanie added data validation to a worksheet column after entering a few records of data.Which Excel feature can she use to locate data that doesn't satisfy the data validation criteria?

• A) Tracer Arrows
• B) Error Check
• C) Watch Window
• D) Circle Invalid Data

---

Definitions:

Standard Deviation

An index quantifying the spread or variability among a collection of numbers, where a smaller standard deviation suggests the numbers are closely clustered around the average.

Tchebysheff's Theorem

A statistical theorem stating that, for any real-valued random variable, the proportion of values lying within k standard deviations from the mean is at least 1-1/k^2, for k > 1.

Empirical Rule

A statistical guideline suggesting that within a normal distribution, nearly every data point can be found within three standard deviations of the central mean.

Stem-And-Leaf Plot

A graphical method for displaying quantitative data, where each number is split into a "stem" (the leading digit(s)) and a "leaf" (the last digit).