Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Searches across the first row of the lookup table
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
Q6: When Excel automatically fills the rest of
Q27: You have been using a variety of
Q28: Lookup _ allow you to use tables
Q29: MATCHING<br>Identify the letter of the choice that
Q30: _ just above the header row of
Q32: The _ function calculates the number of
Q35: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB2166/.jpg" alt=" -According to the
Q105: The _ function calculates the difference between
Q112: If a formula is in a calculated
Q127: Duplicate value highlighting helps to verify that