Multiple Choice
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Adds the values in a range
A) SUMIF
B) VLOOKUP
C) COUNTIF
D) conditional formatting
E) DATEDIF
F) AVERAGE
G) HLOOKUP
H) TRANSPOSE
I) logical condition
J) SUM
Correct Answer:
Verified
Correct Answer:
Verified
Q25: When you want to reference an entire
Q50: You can use a _ function to
Q51: Your boss in the human resources department
Q52: A(n)_ match lookup occurs when the lookup
Q54: The Conditional Formatting button provides access to
Q57: The major difference between HLOOKUP and VLOOKUP
Q57: The _ function is a logical function
Q60: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB2166/.jpg" alt=" -The complete formula
Q70: The COUNTIF function is sometimes referred to
Q110: _ formatting changes a cell's formatting when