Match the following terms to their meanings:

I. INDEX function array
II. INDEX function reference
III. MATCH
IV. Lookup_value
V. Match_type

A. Searches for a specific item in a range and returns the relative position of the item
B. Returns a value of a component in a table or an array
C. Argument that specifies which value to return
D. Argument that specifies the value to be looked up
E. Returns the reference of a cell at the intersection of a specific row and column

Answer: B, E, A, D, C

Computer Science & Information Technology

You might also like to view...

There are only two ways to help prevent a password from being cracked.

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

Computer Science & Information Technology

What is a simulation tool used for?

A. Syntax errors B. Concurrent users C. Security vulnerabilities D. logic errors

Computer Science & Information Technology