Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Calculates the average of the values in a range
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
Q88: MATCHING<br>Identify the letter of the choice that
Q88: If any logical condition listed in the
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
Q92: The _ function adds the values in
Q93: If you edit a cell in a
Q94: MATCHING<br>Identify the letter of the choice that
Q96: The _ function searches vertically down the
Q98: Your boss in the human resources department