Spreadsheet - Vlookup

What does the VLOOKUP function primarily do in Excel?

• Finds the average of a set of values

• Searches for a value in a table and returns a corresponding value

• Sorts data in ascending order

• Filters data based on a condition

Which of the following is the correct syntax for VLOOKUP?

• =VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup])

• =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• =VLOOKUP(lookup_value, col_index_num, table_array, [range_lookup])

• =VLOOKUP([range_lookup], table_array, lookup_value, col_index_num)

In the formula =VLOOKUP("Apple", A2:B10, 2, FALSE), what does the argument FALSE represent?

• Search for an approximate match

• Search for an exact match

• Ignore errors

• Return a value from the first column

What does the lookup_value represent in the VLOOKUP function?

• The range of cells to search in

• The column number to retrieve data from

• The value you want to search for

• The type of match you want (exact or approximate)

What does the argument col_index_num specify in a VLOOKUP function?

• The number of rows to search

• The column number from which to return the value

• The range of cells to perform the lookup in

• Whether the function should return an exact or approximate match

If the range_lookup argument is left blank, what type of match will VLOOKUP perform by default?

• Exact match

• Approximate match

• No match

• Case-sensitive match

In order to use VLOOKUP for approximate matches, how should the table be organized?

• Sorted in descending order

• Sorted alphabetically by the second column

• Sorted in ascending order by the leftmost column

• Sorted in ascending order by any column

Which function can you use in combination with VLOOKUP to handle errors when no match is found?

• IFERROR

• SUM

• MATCH

• CONCATENATE

When would you set the range_lookup argument to TRUE in a VLOOKUP function?

• When you need an exact match

• When you want to find the smallest value greater than the lookup value

• When you want to find the largest value less than or equal to the lookup value

• When you want the function to return the first result it finds

What does VLOOKUP return if an exact match is not found and FALSE is specified for range_lookup?

• The closest approximate match

• A random value from the table

• An error

• A blank cell