If a Lookup_value Is Smaller Than the Smallest Value in the First

question 132

Multiple Choice

If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the ____ error value.

• A) #N/A
• B) ##
• C) #ERROR#
• D) @#@#

---

Definitions:

Sample Mean

The sample mean is the average value of a sample set of numbers, calculated by dividing the sum of all values in the sample by the number of values.

Standard Deviation

A quantification of the variability or scattering of data points within a dataset.

Population Mean

The average value of a characteristic in a population, calculated by summing all values and dividing by the total number of observations.

Sampling Distribution

A distribution of probabilities for a statistic, derived from taking many samples from a designated population.