MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The field or fields you select to sort records.
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

Sort keys are the field or fields that you select to sort records.

Answer: D 
 The extract range is the range from which you want to extract data.

Answer: E 
 The criteria range is the range that contains the conditions you want to use to filter data in a list or database.

Answer: G 
 AutoFilter is a tool that allows you to filter data based on certain criteria.

Answer: H 
 A query is a request to retrieve data from one or more tables or other data sources.

Note: None of the other choices match the definition given.

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