Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Uses specific criteria to count a number of items.
Responses:
sort keys
extract range
SUMIF
AutoFilter
criteria range
query
Custom Filter
COUNTIF
DCOUNT
conditional formatting
Correct Answer:
Premises:
Responses:
sort keys
extract range
SUMIF
AutoFilter
criteria range
query
Custom Filter
COUNTIF
DCOUNT
conditional formatting
Premises:
sort keys
extract range
SUMIF
AutoFilter
criteria range
query
Custom Filter
COUNTIF
DCOUNT
conditional formatting
Responses:
Related Questions
Q9: Both the HLOOKUP and VLOOKUP functions look
Q13: The _ command on the AutoFilter menu
Q20: The process of filtering activity based on
Q31: Excel includes _ types of conditional formats.
Q34: Which of the following are database functions?<br>A)
Q39: To remove a filter criterion for a
Q51: Each row of an Excel worksheet used
Q64: If the function references a(n)<u>table</u> that changes
Q71: _ formatting allows you to create rules
Q84: Excel does not sort _ records.