Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
When enabled with hidden records, Excel displays a filter icon on the filter buttons used to establish the filter.
Responses:
SUMIF
Custom Filter
COUNTIF
DCOUNT
extract range
AutoFilter
query
sort keys
conditional formatting
criteria range
Correct Answer:
Premises:
Responses:
SUMIF
Custom Filter
COUNTIF
DCOUNT
extract range
AutoFilter
query
sort keys
conditional formatting
criteria range
Premises:
SUMIF
Custom Filter
COUNTIF
DCOUNT
extract range
AutoFilter
query
sort keys
conditional formatting
criteria range
Responses:
Related Questions
Q8: A _ should be formatted so that
Q16: For the VLOOKUP function to work correctly,the
Q59: If you deselect an item from the
Q67: To change an active table back to
Q68: With the criteria range,if you want a(n)_
Q69: All of the database functions require a
Q70: You can set up a criteria range
Q71: The HLOOKUP and VLOOKUP functions can be
Q90: When performing an advanced filter operation,the location
Q106: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9082/.jpg" alt=" In the Sort