Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Allows you to enter custom criteria, such as multiple options or ranges of numbers.
Responses:
SUMIF
DCOUNT
COUNTIF
conditional formatting
criteria range
query
Custom Filter
AutoFilter
extract range
sort keys
Correct Answer:
Premises:
Responses:
SUMIF
DCOUNT
COUNTIF
conditional formatting
criteria range
query
Custom Filter
AutoFilter
extract range
sort keys
Premises:
SUMIF
DCOUNT
COUNTIF
conditional formatting
criteria range
query
Custom Filter
AutoFilter
extract range
sort keys
Responses:
Related Questions
Q13: The _ command on the AutoFilter menu
Q15: The general form of the VLOOKUP function
Q22: Identify the letter of the choice that
Q23: A table also is called a record.
Q28: A(n)_ total sums all of the data
Q34: Which of the following are database functions?<br>A)
Q60: Which of the following is the path
Q72: A worksheet's row-and-column structure can be used
Q84: Excel does not sort _ records.
Q100: The Subtotal command displays outline symbols beside