If You See ____ as the Result of a VLOOKUP

question 36

Multiple Choice

If you see ____ as the result of a VLOOKUP formula you might have entered a letter for the col_index_num instead of a number.

• A)#NULL
• B)#REF?
• C)#NAME?
• D)#DIV\0

Grasp the impact of outliers on measures of central tendency.

Distinguish between population and sample statistical measures.

Interpret the effect of new data on the mean calculation.

Recognize the formulas for computing statistical measures.

---

Definitions:

Random Number

A number generated in such a way as to exhibit no predictable pattern or order, often used in computing to simulate chance or create variability in data processing.

Isalnum

A function in C that checks if a given character is an alphanumeric character (either a letter or a number).

Non-0 Number

A numeric value different from zero, indicating either a positive or negative value but not the absence of a quantity.

ASCII String

An ASCII String is a sequence of characters encoded using the ASCII standard, representing text in computers and other devices.