Reference Functions Quiz

For the VLOOKUP or HLOOKUP function, the lookup_value can be:

any of these choices

The syntax of the HLOOKUP function is

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Given the table above, which formula will give the letter grade if the score is located in cell H6, and the score is not an exact match?

=HLOOKUP(H6, B1:F2, 2, TRUE)

Given the table above, which formula is the correct way to give the salary of the employee whose ID is in cell C10?

=VLOOKUP(C10, A2:E5, 4, FALSE)

Given the table above, which formula will give the letter grade if the score is located in cell E3, and the score is not an exact match?

=VLOOKUP(E3, A2:B6, 2, TRUE)

What function returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula?

IFERROR( ) function

The table_array argument in the VLOOKUP or HLOOKUP function should include any row or column

False

For the HLOOKUP function, the lookup_value must be in the first row of the table array

True

If the range_lookup argument to the VLOOKUP function is set to TRUE, then the leftmost column of the table_array argument must be in ascending order.

True

The syntax of the VLOOKUP function is:

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