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