MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Uses specific criteria to count a number of items.
A)SUMIF
B)COUNTIF
C)DCOUNT
D)extract range
E)criteria range
F)Custom Filter
G)AutoFilter
H)query
I)sort keys
J)conditional formatting

Question

Quizplus · Accepted Answer

COUNTIF is specifically designed to count a number of items based on specific criteria.

Answer: C
 DCOUNT also uses specific criteria to count a number of items, but it allows for more complex criteria and can be used with a database.

(Note: SUMIF and extract range are not related to counting items. Criteria range, Custom Filter, AutoFilter, query, sort keys, and conditional formatting may be used in data analysis but are not specifically designed for counting items.)

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