BUS 1350 EXAM 3 COMPLETE STUDY GUIDE QUESTIONS AND VERIFIED ANSWERS

BUS 1350 EXAM 3 COMPLETE STUDY GUIDE
QUESTIONS AND VERIFIED ANSWERS

●● VLOOKUP- for an APPROXIMATE match what is the formula
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
Answer: the value to lookup


●● table_array
Answer: the reference to the vertical lookup table


●● col_index
Answer: column number in lookup formula containing the value to be
returned


●● range_lookup
Answer: is set to FALSE for an EXACT MATCH and TRUE for
approximate match lookups

,●● VLOOKUP- for an EXACT MATCH what is the formula
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
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.
Answer: TRUE


●● What is the order of a vertical lookup table for APPROXIMATE
MATCH LOOKUPS? (4 items)
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.
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
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)
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