BUS 1350 – Exam 3 Questions and Answers, 2026 – Rated A+ practice and study
material
VLOOKUP - correct answer ✔✔ Pulls specific info for a spreadsheet based upon a piece of
information ie. title, name etc
VLOOKUP- for an APPROXIMATE match what is the formula - correct answer ✔✔
=LOOKUP(lookup-value, table_array,col_index_num,range_lookup= TRUE)
(the key to this answer is TRUE- approximate match always has true at the end of the formula )
Lookup_value - correct answer ✔✔ the value to lookup
table_array - correct answer ✔✔ the reference to the vertical lookup table
col_index - correct answer ✔✔ column number in lookup formula containing the value to be
returned
range_lookup - correct answer ✔✔ is set to FALSE for an EXACT MATCH and TRUE for
approximate match lookups
VLOOKUP- for an EXACT MATCH what is the formula - correct answer ✔✔
=LOOKUP(lookup_value, table_array,col_index_num,range_lookup+FALSE)
(the key to this answer is the FALSE- FALSE IS ALWAYS IN THE FORMULA FOR EXACT MATCH)
, APPROXIMATE MATCH LOOKUP - correct answer ✔✔ A lookup where the lookup value falls
within a range of numbers in the compare values in the lookup table instead of a single specific
value.
true or false: approximate match lookups can reference a vertical or horizontal lookup table. -
correct answer ✔✔ TRUE
What is the order of a vertical lookup table for APPROXIMATE MATCH LOOKUPS? (4 items) -
correct answer ✔✔ 1. the first column stores the valued to be compared to the lookup value
2. values in the first column must be sorted in ASCENDING ORDER
3. first entry in first column contains the lowest comparison value
4. each following entry contains the lower end of the range that the lookup value is compared
to
Excel finds an APPROXIMATE MATCH BY going ____ the ____ column of the table until it locates
the row containing the ___ value that is less than or equal to the lookup value. Then it retrieves
the corresponding values from that row. - correct answer ✔✔ down, first column, largest value
true or false- the APPROXIMATE match lookup compares a lookup value to ranges of values,
determining the range the lookup value falls within - correct answer ✔✔ true
What is the correct order of arguments for VLOOKUP for an EXACT match:
1 =V LOOKUP (lookup_value, table_array, col_index_num,range_lookup=FALSE)
2 =VLOOKUP (lookup_value, col_index_num, table_array, range_lookup=FALSE)
3 =VLOOKUP (table_array,lookup_value,col_index_num,range_lookup= TRUE) - correct answer
✔✔ 1 IS CORRECT
HINTS:first you can eliminate 3 bc for an EXACT match it is always FALSE, then table array comes
before column because first you need to find the table that its looking up from before you
would specify a column
material
VLOOKUP - correct answer ✔✔ Pulls specific info for a spreadsheet based upon a piece of
information ie. title, name etc
VLOOKUP- for an APPROXIMATE match what is the formula - correct answer ✔✔
=LOOKUP(lookup-value, table_array,col_index_num,range_lookup= TRUE)
(the key to this answer is TRUE- approximate match always has true at the end of the formula )
Lookup_value - correct answer ✔✔ the value to lookup
table_array - correct answer ✔✔ the reference to the vertical lookup table
col_index - correct answer ✔✔ column number in lookup formula containing the value to be
returned
range_lookup - correct answer ✔✔ is set to FALSE for an EXACT MATCH and TRUE for
approximate match lookups
VLOOKUP- for an EXACT MATCH what is the formula - correct answer ✔✔
=LOOKUP(lookup_value, table_array,col_index_num,range_lookup+FALSE)
(the key to this answer is the FALSE- FALSE IS ALWAYS IN THE FORMULA FOR EXACT MATCH)
, APPROXIMATE MATCH LOOKUP - correct answer ✔✔ A lookup where the lookup value falls
within a range of numbers in the compare values in the lookup table instead of a single specific
value.
true or false: approximate match lookups can reference a vertical or horizontal lookup table. -
correct answer ✔✔ TRUE
What is the order of a vertical lookup table for APPROXIMATE MATCH LOOKUPS? (4 items) -
correct answer ✔✔ 1. the first column stores the valued to be compared to the lookup value
2. values in the first column must be sorted in ASCENDING ORDER
3. first entry in first column contains the lowest comparison value
4. each following entry contains the lower end of the range that the lookup value is compared
to
Excel finds an APPROXIMATE MATCH BY going ____ the ____ column of the table until it locates
the row containing the ___ value that is less than or equal to the lookup value. Then it retrieves
the corresponding values from that row. - correct answer ✔✔ down, first column, largest value
true or false- the APPROXIMATE match lookup compares a lookup value to ranges of values,
determining the range the lookup value falls within - correct answer ✔✔ true
What is the correct order of arguments for VLOOKUP for an EXACT match:
1 =V LOOKUP (lookup_value, table_array, col_index_num,range_lookup=FALSE)
2 =VLOOKUP (lookup_value, col_index_num, table_array, range_lookup=FALSE)
3 =VLOOKUP (table_array,lookup_value,col_index_num,range_lookup= TRUE) - correct answer
✔✔ 1 IS CORRECT
HINTS:first you can eliminate 3 bc for an EXACT match it is always FALSE, then table array comes
before column because first you need to find the table that its looking up from before you
would specify a column
