This quiz has been taken 117 times.
Average score: 71%
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"