VLOOKUP Function Quiz

What does VLOOKUP stand for?

• Variable Lookup

• Value Lookup

• Vertical Lookup

• Visual Lookup

What is the purpose of the VLOOKUP function?

• To search for a value in a table

• To create charts

• To print documents

• To format cells

Which of the following is a required argument in the VLOOKUP function?

• range_lookup

• table_array

• col_index_num

• lookup_value

What does the 'range_lookup' argument specify?

• Type of match

• Column number

• Data range

• Lookup value

In the formula =VLOOKUP(E2,A2:C6,3,FALSE), what does 'E2' represent?

• The table range

• The result cell

• The cell to search for a value

• The column index

What will happen if you enter a non-existing ProductID in VLOOKUP?

• It will return an empty cell

• It will return 0

• It will return the last value

• It will return #N/A

What is the purpose of using IFERROR with VLOOKUP?

• To handle errors gracefully

• To speed up calculations

• To format the output

• To create charts

Which formula retrieves the ProductName instead of Price?

• =VLOOKUP(E2,A2:C6,1,FALSE)

• =VLOOKUP(E2,A2:C6,3,FALSE)

• =VLOOKUP(E2,A2:C6,2,FALSE)

• =VLOOKUP(E2,A2:C6,4,FALSE)

What is the first step in setting up a data table for VLOOKUP?

• Format cells

• Enter data

• Open Excel

• Create headers

What should you type in cell A1 to create a header?

• Price

• ProductName

• Category

• ProductID