MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Use to reference cells within an Excel table
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
Q2: The ORERROR function can determine if a
Q14: In the DATEDIF function,the first date
Q15: Whenever you enter a formula into an
Q18: If you need to modify the formula
Q21: An error value begins with a number
Q25: MATCHING
Identify the letter of the choice that
Q27: MATCHING
Identify the letter of the choice that
Q28: If any logical condition listed in the
Q29: The IF function results in two values
Q34: You can calculate the number of cells
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