Excel Functions Quiz samir

What does the VLOOKUP function do?

• Looks up values horizontally

• Looks up values vertically

• Sums values

• Filters data

Which function searches data horizontally in the first row?

• VLOOKUP

• INDEX

• HLOOKUP

• MATCH

Which function returns the position of a value in a range?

• INDEX

• MATCH

• CHOOSE

• HLOOKUP

Which function is used to return the value at a specific row and column?

• VLOOKUP

• HLOOKUP

• INDEX

• OFFSET

What is the correct syntax of VLOOKUP?

• VLOOKUP(range, value, row_num, FALSE)

• VLOOKUP(value, table_array, col_index_num, [range_lookup])

• VLOOKUP(col_index_num, value, table_array, TRUE)

• VLOOKUP(value, row, column, TRUE)

What happens if VLOOKUP cannot find the value?

• Returns 0

• Returns blank

• Returns #N/A error

• Crashes Excel

Which function can dynamically return a cell reference by moving rows/columns?

• MATCH

• INDEX

• OFFSET

• XLOOKUP

Which of the following is a modern replacement for both VLOOKUP and HLOOKUP?

• OFFSET

• CHOOSE

• LOOKUP

• XLOOKUP

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

• Yes

• No

What does the CHOOSE function do?

• Matches values

• Selects a value based on index number

• Offsets values

• Searches vertically