1.	Which function finds a match, and then returns a related value?

A.VLOOKUP. B.SUBTOTAL. C.IF. D.ISERROR.

2.	When the VLOOKUP performs its match, it looks:

A.In all columns of the lookup range. B.In the first column of the lookup range only. C.In the last column of the lookup range only. D.In the first and last columns of the lookup range.

3.	Which function returns the relative position of a list item?

A.INDEX. B.MATCH. C.VLOOKUP. D.SUMIFS.

4.	Which function returns a numeric value given a text string that represents a number?

A.TEXT. B.VALUE. C.MATCH. D.INDEX.

5.	Which function returns a text string when given a numeric value?

A.TEXT. B.VALUE. C.MATCH. D.INDEX.

6.	Which function returns a value from a range at a given position?

A.MATCH. B.INDEX. C.TEXT. D.VALUE.