Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
An area of the worksheet that you use to manipulate records that pass the comparison criteria.
Responses:
AutoFilter
COUNTIF
Custom Filter
criteria range
SUMIF
extract range
query
sort keys
DCOUNT
conditional formatting
Correct Answer:
Premises:
Responses:
AutoFilter
COUNTIF
Custom Filter
criteria range
SUMIF
extract range
query
sort keys
DCOUNT
conditional formatting
Premises:
AutoFilter
COUNTIF
Custom Filter
criteria range
SUMIF
extract range
query
sort keys
DCOUNT
conditional formatting
Responses:
Related Questions
Q13: The _ command on the AutoFilter menu
Q20: Identify the letter of the choice that
Q23: A table also is called a record.
Q28: A(n)_ total sums all of the data
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
Q60: Which of the following is the path
Q84: Excel does not sort _ records.
Q100: The Subtotal command displays outline symbols beside