And now a quiz to see what we've learned today! Quiz Statistics and Answer Key

This quiz has been taken 117 times.

Average score: 71%

Click on the links below to see statistics for each question:

How many parts are there in a VLOOKUP formula?
The correct answer is "4"

What does a $ in front of a cell reference tell Excel?
The correct answer is "That the cell references don't change when copied"

What does the fourth part of a VLOOKUP formula do?
The correct answer is "Tell Excel whether to look for an exact or an approximate match"