Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Calculates the number of cells in a range that match criteria you specify using this function
A) SUMIF
B) VLOOKUP
C) COUNTIF
D) conditional formatting
E) DATEDIF
F) AVERAGE
G) HLOOKUP
H) TRANSPOSE
I) logical condition
J) SUM
Correct Answer:
Verified
Correct Answer:
Verified
Q36: If you see _ as the result
Q81: If you need to modify the formula
Q82: MATCHING<br>Identify the letter of the choice that
Q83: Discuss strategies for checking formulas for matching
Q84: You have been using a variety of
Q87: You can edit existing conditional formatting rules
Q88: MATCHING<br>Identify the letter of the choice that
Q89: Evaluate the formula =AND(G2="FT",M2>=1) based upon the
Q90: _ references make it easier to create
Q91: Evaluate the formula =AND(G2="FT",M2>=1) based upon the