MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Use to calculate the average of values in a range that meet criteria you specify
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
Q16: In most cases,when manually creating a
Q23: In a fully qualified structured reference the
Q24: MATCHING
Identify the letter of the choice that
Q31: Duplicate value highlighting helps to verify that
Q32: If you use a structured reference outside
Q32: You cannot nest more than one IF
Q34: When manually creating a conditional formatting formula,if
Q35: In an unqualified structured reference only the
Q36: The #REF! error value can occur when
Q37: You use the MEANIF function to calculate
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