Match the Following Five Terms to Their Meanings

Multiple Choice

Match the following five terms to their meanings:
i.Lookup function
II.table array
III.VLOOKUP function
IV.HLOOKUP function
v.name

A) looks up values arranged in horizontal rows
B) looks up value in a defined range of cells located in another part of the workbook to find a corresponding value
C) word or string of characters that represents a cell,a range of cells,a formula,or a constant value
D) looks up values arranged in vertical columns
E) defined range in lookup formula