Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The process of filtering activity based on one or more filter criteria.
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
Q75: When you enable _ and records are
Q76: With a database function,if one of your
Q77: Both the HLOOKUP and VLOOKUP functions look
Q78: MATCHING<br>Identify the letter of the choice that
Q79: _ records allows you to pull data
Q81: Which of the following are database functions?<br>A)AVERAGE<br>B)DAVERAGE<br>C)SUM<br>D)DSUM<br>
Q82: Which of the following is the path
Q83: The DCOUNT function can count either numeric
Q84: Excel does not sort _ records.
Q85: Describe how to format a table.