1. The VLOOKUP function in Excel is used to:
(A) Search data vertically in the leftmost column of a table
(B) Search data horizontally in the top row of a table
(C) Count matching values
(D) Filter duplicate records
2. The HLOOKUP function in Excel is used to:
(A) Sort data in ascending order
(B) Search data vertically in the leftmost column
(C) Search data horizontally in the top row of a table
(D) Count cells containing numbers
3. In the function =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), the argument “col_index_num” refers to:
(A) The row number from which the value is returned
(B) The column number in the table from which the value is returned
(C) The worksheet number
(D) The index of the lookup value
4. What does the “range_lookup” argument in VLOOKUP/HLOOKUP control?
(A) Whether the search is case-sensitive
(B) Whether the column is hidden
(C) Whether the data is formatted automatically
(D) Whether the search is exact or approximate
5. What value should you use in the “range_lookup” argument for an exact match?
(A) 0 or FALSE
(B) 1 or TRUE
(C) 2
(D) Blank cell
6. What value should you use in the “range_lookup” argument for an approximate match?
(A) 1 or TRUE
(B) 0 or FALSE
(C) #N/A
(D) NULL
7. If VLOOKUP cannot find the lookup value, it returns:
(A) #VALUE!
(B) #REF!
(C) #N/A
(D) 0
8. Which limitation is true for VLOOKUP?
(A) It can only search in the leftmost column
(B) It can return multiple results at once
(C) It can search in both directions
(D) It ignores case sensitivity
9. In HLOOKUP, the “row_index_num” argument is used to:
(A) Identify the column to search
(B) Identify the lookup value position
(C) Identify the worksheet number
(D) Identify the row from which to return the value
10. Which function is more advanced and often used instead of VLOOKUP and HLOOKUP?
(A) FIND
(B) SEARCH
(C) INDEX and MATCH
(D) FILTER