Which three key pieces of information are required to perform a VLOOKUP function in Microsoft Excel? (Choose three.)
- the column number in the range that contains the return value
- the mean average of the column
- the range where the value is located
- the locator value for the blank fields
- the lookup value
Explanation: To perform a VLOOKUP the function needs 4 required pieces of key information:
1. The value you want to lookup – aka the lookup value.
2. The range where the value is located.
3. The column number in the range that contains the return value.
4. And, optionally: Specify TRUE if you want an approximate match or FALSE if you want an exact match of the return value.
Related exam: Module 5.6.2 Quiz - Analyze the Data Using Statistics
