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
Q24: MATCHING
Identify the letter of the choice that
Q25: To get the effect of a calculated
Q29: MATCHING
Identify the letter of the choice that
Q32: You cannot nest more than one IF
Q38: MATCHING
Identify the letter of the choice that
Q42: If all of the logical conditions are
Q45: The _ function is a logical function
Q48: _ just above a cell in the
Q57: In many situations the value you store
Q65: The _ function is a logical function
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents