VLOOKUP in Excel Quiz

What does VLOOKUP do in Excel?

• Adds numbers together

• Looks up a value and returns related information

• Changes the color of a cell

• Sorts data alphabetically

Which argument in the VLOOKUP formula represents the value you want to search for?

• Lookup_value

• Table_array

• Column_index_num

• Range_lookup

What does the "Table_array" argument in VLOOKUP refer to?

• The value you want to find

• The range of cells containing the data

• The result of the lookup

• The formula for the lookup

In VLOOKUP, which argument is used to specify whether you want an exact or approximate match?

• Lookup_value

• Table_array

• Column_index_num

• Range_lookup

If you use VLOOKUP with "FALSE" for the Range_lookup argument, what kind of match will it search for?

• Exact match

• Approximate match

• Any match

• Random match

What happens if VLOOKUP cannot find the lookup value?

• It returns a blank cell

• It returns an error message (#N/A)

• It gives the closest match

• It stops working

Which of the following is the correct order for the VLOOKUP function?

• Table_array, Lookup_value, Column_index_num, Range_lookup

• Lookup_value, Table_array, Column_index_num, Range_lookup

• Column_index_num, Table_array, Lookup_value, Range_lookup

• Lookup_value, Column_index_num, Table_array, Range_lookup

Which part of the VLOOKUP formula tells Excel which column to return the value from?

• Lookup_value

• Column_index_num

• Table_array

• Range_lookup

Can VLOOKUP search for values to the left of the lookup column?

• Yes

• No

What does the VLOOKUP function return if you set Range_lookup to TRUE?

• The closest match to the lookup value

• An exact match

• A random match

• The value from the first column