BUS 1350 FINAL EXAM - MODULE 7&9
QUESTIONS & VERIFIED CORRECT
ANSWERS
To perform an APPROXIMATE match with VLookup, use the equation:
LOOKUP(lookup_value,table_array,column_index_num,range_lookup=___________)
True or False - Correct Answer ✔✔ TRUE
To perform an EXACT match with VLookup, use the equation:
LOOKUP(lookup_value,table_array,column_index_num,range_lookup=__________)
True or False - Correct Answer ✔✔ FALSE
The approximate match lookup compares a lookup value to ranges of values,
determining the range the lookup value falls within?
True or False? - Correct Answer ✔✔ True
The video gave two important rules concerning vlookup: The 1st was the data had to be
in vertical columns, and the 2nd was information that you know must be
_____________ of the data you want to lookup - Correct Answer ✔✔ Left
Specify _______ as the range lookup when you want an exact match, and
___________ for an approximate match - Correct Answer ✔✔ Specify FALSE as the
range lookup when you want an exact match, and TRUE for an approximate match
What is the proper syntax for xlookup? - Correct Answer ✔✔ XLOOKUP(Lookup value,
lookup array, return array, [not found])
*make sure lookup VALUE is the first typed*
What is the purpose of the COUNTIF functions? - Correct Answer ✔✔ counts the
number of cells that match specific criteria.
Is this the correct way to type a COUNTIF Function?
=COUNTIF(B10:B90,"Twitter") - Correct Answer ✔✔ Yes,
It is saying that it will count all the numbers in the range B10:B90, that equal the value
"Twitter"
, The COUNTIF function makes no distinction between text values and numerical values
unlike the COUNT function which does NOT count text values?
True or False? - Correct Answer ✔✔ True
COUNTIF = text values and numerical values
COUNT = numerical
COUNTIFS function applies to _____________ criteria for a conditional count - Correct
Answer ✔✔ Multiple
(counting with two ranges/criteria pairs)
What is this formula finding?
=COUNTIFS(C12:D14,F5,C15:D17,G9) - Correct Answer ✔✔ It counts the number of
times the value of F5 is in the ranges C12:D14 and also counts the number of times the
value of G9 is in the ranges C15:D17)
What does the SUMIF function do?
What is the Syntax of the SUMIF function? - Correct Answer ✔✔ Calculates the sum of
values that match specified criteria
=SUMIF(A1:A50,">50")
What is this function finding?
=SUMIF(A1:A50,">50") - Correct Answer ✔✔ Calculating the sum of values in range
A1:A50, but only for those values that are greater than 50
In this formula, =SUMIF(A1:A50,E15,B1:B50)
what of these does B1:B50 represent?
- Criteria Range
- Criteria Value
- Sum Range - Correct Answer ✔✔ Sum Range
SUMIFS & AVERAGEIFS do what? - Correct Answer ✔✔ - Both begin with a reference
to the range containing the sum or average to be calculated followed by MORE
criteria/range pairs
You use Logical Functions when... - Correct Answer ✔✔ you need to set data values
based on whether a condition is true or false
To test for multiple conditions, returning different values for each condition, you can
______________ one IF function within the other - Correct Answer ✔✔ Nest
QUESTIONS & VERIFIED CORRECT
ANSWERS
To perform an APPROXIMATE match with VLookup, use the equation:
LOOKUP(lookup_value,table_array,column_index_num,range_lookup=___________)
True or False - Correct Answer ✔✔ TRUE
To perform an EXACT match with VLookup, use the equation:
LOOKUP(lookup_value,table_array,column_index_num,range_lookup=__________)
True or False - Correct Answer ✔✔ FALSE
The approximate match lookup compares a lookup value to ranges of values,
determining the range the lookup value falls within?
True or False? - Correct Answer ✔✔ True
The video gave two important rules concerning vlookup: The 1st was the data had to be
in vertical columns, and the 2nd was information that you know must be
_____________ of the data you want to lookup - Correct Answer ✔✔ Left
Specify _______ as the range lookup when you want an exact match, and
___________ for an approximate match - Correct Answer ✔✔ Specify FALSE as the
range lookup when you want an exact match, and TRUE for an approximate match
What is the proper syntax for xlookup? - Correct Answer ✔✔ XLOOKUP(Lookup value,
lookup array, return array, [not found])
*make sure lookup VALUE is the first typed*
What is the purpose of the COUNTIF functions? - Correct Answer ✔✔ counts the
number of cells that match specific criteria.
Is this the correct way to type a COUNTIF Function?
=COUNTIF(B10:B90,"Twitter") - Correct Answer ✔✔ Yes,
It is saying that it will count all the numbers in the range B10:B90, that equal the value
"Twitter"
, The COUNTIF function makes no distinction between text values and numerical values
unlike the COUNT function which does NOT count text values?
True or False? - Correct Answer ✔✔ True
COUNTIF = text values and numerical values
COUNT = numerical
COUNTIFS function applies to _____________ criteria for a conditional count - Correct
Answer ✔✔ Multiple
(counting with two ranges/criteria pairs)
What is this formula finding?
=COUNTIFS(C12:D14,F5,C15:D17,G9) - Correct Answer ✔✔ It counts the number of
times the value of F5 is in the ranges C12:D14 and also counts the number of times the
value of G9 is in the ranges C15:D17)
What does the SUMIF function do?
What is the Syntax of the SUMIF function? - Correct Answer ✔✔ Calculates the sum of
values that match specified criteria
=SUMIF(A1:A50,">50")
What is this function finding?
=SUMIF(A1:A50,">50") - Correct Answer ✔✔ Calculating the sum of values in range
A1:A50, but only for those values that are greater than 50
In this formula, =SUMIF(A1:A50,E15,B1:B50)
what of these does B1:B50 represent?
- Criteria Range
- Criteria Value
- Sum Range - Correct Answer ✔✔ Sum Range
SUMIFS & AVERAGEIFS do what? - Correct Answer ✔✔ - Both begin with a reference
to the range containing the sum or average to be calculated followed by MORE
criteria/range pairs
You use Logical Functions when... - Correct Answer ✔✔ you need to set data values
based on whether a condition is true or false
To test for multiple conditions, returning different values for each condition, you can
______________ one IF function within the other - Correct Answer ✔✔ Nest
