Match the following terms to their meanings:

I. Range name A. A list of values that define acceptable entries in a designated set
II. Validation list of cells
III Table array B. A matrix of values that can be used to find a value using a
IV. Column index lookup function.
V. Row index C. Identity of a row in the table array containing designated in
the HLOOKUP function
D. A name given to a selected set of cells which can be identified as
a group
E. Identity of a column in the table array containing designated in
the VLOOKUP function


D, A, B, E, C

Computer Science & Information Technology

You might also like to view...

Motivation and accountability are two completely unrelated factors in the execution of tasks by individual staff members.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The ____ statement is used to assign a new array to the specified array variable.

A. ChangeSize B. ReDim C. ArraySize D. NumElem

Computer Science & Information Technology

A DoD approved disk wiping utility works by instructing the hard disk controller to apply a strong magnetic field to the disk surface, thereby electronically erasing the information from the disk

a. True b. False

Computer Science & Information Technology

?A(n) _____ is a condition, restriction, or requirement that the system must satisfy.

A. ?constraint B. ?index C. ?milestone D. ?viewport

Computer Science & Information Technology