Dr Mo Final Exam
The approximate match lookup compares a lookup value to ranges of values, determining
the range the lookup value falls within?
True
What is the correct order of arguments for the VLOOKUP function for an exact match?
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup=FALSE)
2 multiple choice options
The video gave you two important rules concerning VLOOKUPS: The 1st was that the data
had to be in a vertical columns, and the 2nd was information that you know must be
__________ of the data you want to
lookup.
Left
1 multiple choice option
Specify ________ as the range lookup value if you want an exact match and _________ for
an approximate match.
FALSE, TRUE
1 multiple choice option
Which of these is the proper syntax for a XLOOKUP function:
XLOOKUP(Lookup value, lookup array, return array, [not_found])
1 multiple choice option
Which of these would be a correct COUNTIF function?
=COUNTIF(B5: B100, "Facebook")
3 multiple choice options
The COUNTIF function makes no distinction between text values and numeric values unlike
the COUNT function which does NOT count text values.
True
In this formula =SUMIF(C3:C12,14, E3:12), what does the range E:3:12 represent?
Sum Range
2 multiple choice options
, Which one of these calculates the sum of values in the range B1:B100, but only those cells
whose value is less than 50:
=SUMIF (B1:B100," <50")
2 multiple choice options
Use the COUNTIF, SUMIF, and AVERAGEIF functions for _________ a criteria argument.
Excel also supports summary functions that allow for ________
criteria: COUNTIFS, SUMIFS, and AVERAGEIFS.
single, multiple
Which of these is the correct AVERAGEIF function?
AVERAGEIF(A1:A100, "> 50")
2 multiple choice options
To test for multiple conditions, returning different values for each condition, you can
__________ one IF function within the other?
Nest
The IFS function now provides an easier way of working with multiple
IF conditions _________ nesting.
Without
1 multiple choice option
The IFS function does not include a default value if all the conditions are false, but you can
add a default condition. Which of the following is the correct form of a default condition?
IFS(A1 <6, "Poor", A1 <10,"Average, A1> = 10, TRUE, 'Good")
2 multiple choice options
The score of a student in two subjects are inserted in the B2 and C2 cells and the passing
score for each subject is 60. Which of these functions will you insert in the D2 cell so that it
returns TRUE if at least one score is greater than or equal to 60, or else it returns FALSE?
=OR(B2>=60, C2>=60)
3 multiple choice options
The score of a student inserted in the B2 cell is 65 and in the C2 cell is
75. Which of the following functions will you insert in the D2 cell so that it returns FALSE if
any of the conditions are false for the values in the B2 and C2 cells?
=AND(B2>=70, C2>=80)
3 multiple choice options
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ACTUALSTUDY. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.