The _____ Function Returns the Value from a Range of Data

question 548

Multiple Choice

The _____ function returns the value from a range of data at the intersection of a specified row and column.

• A) INDEX
• B) MATCH
• C) LOOKUP
• D) ARRAY

---

Definitions:

Ordinal Data

A type of categorical statistical data type in which the order of the values is significant but the difference between each one is not necessarily uniform.

Nominal Data

Nominal data represents categories that cannot be logically ordered or ranked, where each category is mutually exclusive and there is no inherent arithmetic relationship among them.

Ordinal Data

A type of categorical data with a set order or ranking among the categories but without a defined distance between categories.

Nominal Data

Data categorized by labels or names without a natural order or ranking between the categories.