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

Question

Quizplus · Accepted Answer

HLOOKUP searches across the first row of the lookup table.

Answer: D 
 Conditional formatting is a tool used to format cells based on logical conditions.

Answer: B 
 VLOOKUP is a function used to search for a value in the first column of a lookup table and return a corresponding value in the same row from a specified column.

Note: There may be multiple correct answers depending on the context of the phrase or definition given.

MATCHING Identify the Letter of the Choice That Best Matches the the Phrase