Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Allows you to enter custom criteria,such as multiple options or ranges of numbers.
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
Q32: In a table,a column that contains formulas
Q33: Jane has a worksheet that contains a
Q34: MATCHING<br>Identify the letter of the choice that
Q35: You can insert a _ at the
Q36: The _ function returns the value or
Q38: Dan is manipulating data in a table
Q39: To remove a filter criterion for a
Q40: The general form of the VLOOKUP function
Q41: A(n)_ row-and-column structure can be used to
Q42: Which of the following are guidelines for