MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Adds the values in a range that meet criteria you specify
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

SUMIF adds up the values in a range based on a specified criteria.

Answer: C
 COUNTIF counts the number of cells in a range that meet specific criteria.

Answer: J
 SUM adds up the values in a range.

Additional option:
Answer: I
 Logical conditions are used in various Excel functions, such as IF, AND, OR, and SUMIF, to evaluate whether a given condition is true or false.

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