In a lookup formula,the defined range is referred to as the ________.
A)table array
B)named range
C)validation list
D)defined name

Question

Quizplus · Accepted Answer

In a lookup formula, the defined range is referred to as the table array. This is the range of data where the formula will search for the lookup value. The other options mentioned are different terms in Excel but do not refer to the defined range in a lookup formula.

In a Lookup Formula,the Defined Range Is Referred to as the ________