Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-When enabled with hidden records,Excel displays a filter icon on the filter buttons used to establish the filter.
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
Correct Answer:
Verified
Correct Answer:
Verified
Q100: The Subtotal command displays outline symbols beside
Q101: If the function references a(n)<u>range</u> that grows
Q102: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3737/.jpg" alt=" -In the Sort
Q103: The Conditional Formatting _ dialog box displays
Q104: With criteria ranges,if you want an AND
Q106: The <u>DAVERAGE</u> function counts the number of
Q107: The DAVERAGE function requires a numeric field
Q108: Data in descending sequence is sorted from
Q109: A _ total sums all of the
Q110: Each _ in any given table column