Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.
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
Q29: A(n)_ is the sum of a subset
Q30: Excel turns on the outline feature automatically
Q31: Excel includes _ types of conditional formats.
Q32: In a table,a column that contains formulas
Q33: Jane has a worksheet that contains a
Q35: You can insert a _ at the
Q36: The _ function returns the value or
Q37: MATCHING<br>Identify the letter of the choice that
Q38: Dan is manipulating data in a table
Q39: To remove a filter criterion for a