Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Tallies the number of data values in a range
A) SUMIF
B) VLOOKUP
C) COUNTIF
D) conditional formatting
E) calculated column
F) AVERAGE
G) HLOOKUP
H) COUNT
I) logical condition
J) SUM
K) AVERAGEIF
L) cell and range addresses
Correct Answer:
Verified
Correct Answer:
Verified
Q28: Lookup _ allow you to use tables
Q37: In the DATEDIF function,the first date
Q47: The _ function can determine if a
Q49: You could test two or more conditions
Q51: If all of the logical conditions are
Q63: The _ error value means that Excel
Q73: An alternative to using several nested IF
Q91: Sometimes the built-in conditional formatting rules do
Q98: Your boss in the human resources department
Q102: The IF function results in two values