Quiz 4 Flashcards
Which of the following will find and count all instances of values that are less than the value in cell C2 in the continuous range C2 to C10?
A. =COUNTIF(C2:C10, “<“&C2)
B. =COUNTIF(C2:C10, “<&C2”)
C. =COUNTIF(C2:C10, “< C2”)
D. =COUNTIF(C2:C10, < C2)
A
What function should be used to count the number of items in a list that meet one and only one specified criterion?
COUNTIF( )
Which of the following is often true in cases where formulas are copied in two directions (across and down)?
A. absolute cell referencing should always be used
B. absolute cell referencing should never be used
C. mixed cell referencing should never be used
D. cell referencing does not apply
E. mixed cell referencing is often needed for the formula to result in the correct solution
E
True or False?
In the AVERAGEIFS( ) function, the average_range argument comes last after the criteria_range and the criteria arguments.
False
True or False?
When using TRUE or FALSE as criteria in a function, they are considered to be boolean values and therefore should not be put in quotes.
True
Which of the following will find and count all instances of values that are less than 40 in the continuous range C2 to C10?
A. COUNTIF(C2:C10, “<40”)
B. COUNTIF(C2:C10, “<“&40)
C. COUNTIF(C2:C10, “<“40)
D. COUNTIF(C2:C10,”<&40”)
A
True or False?
Excel treats capital and small letters as the same, so specifying “USA” is the same as specifying “usa”, “Usa”, etc.
True
True or False?
In the COUNTIFS() function, every optional argument is treated as an “OR” scenario, meaning only one criteria must be evaluated to true in order for the item to be counted.
False
True or False?
One major difference between the SUMIF() and the SUMIFS() functions is that the sum_range argument comes last in the SUMIFS() function.
False
True or False?
The syntax rules for the criteria in a SUMIF() function and AVERAGEIF() function are the same as the syntax rules for the COUNTIF() funciton.
True
