Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Use to highlight duplicate values in a range with a font and/or fill color
A) SUMIF
B) VLOOKUP
C) COUNTIF
D) conditional formatting
E) calculated column
F) AVERAGE
G) HLOOKUP
H) COUNT
I) logical condition
J) SUM
K) AVERAGEIF
L) cell and range addresses
Correct Answer:
Verified
Correct Answer:
Verified
Q4: You can edit existing conditional formatting _
Q29: MATCHING<br>Identify the letter of the choice that
Q38: The COUNTAS function counts the number of
Q71: If you are creating a calculated column
Q87: You can edit existing conditional formatting rules
Q111: To set up an approximate match lookup
Q112: You can use _ to reference cells
Q114: Case-Based Critical Thinking Questions<br>Case 7-2<br>Your boss in
Q115: MATCHING<br>Identify the letter of the choice that
Q121: Error values indicate that some element in