Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Calculates the average of the values in a range
Responses:
DATEDIF
SUMIF
AVERAGE
SUM
VLOOKUP
conditional formatting
HLOOKUP
logical condition
COUNTIF
TRANSPOSE
Correct Answer:
Premises:
Responses:
DATEDIF
SUMIF
AVERAGE
SUM
VLOOKUP
conditional formatting
HLOOKUP
logical condition
COUNTIF
TRANSPOSE
Premises:
DATEDIF
SUMIF
AVERAGE
SUM
VLOOKUP
conditional formatting
HLOOKUP
logical condition
COUNTIF
TRANSPOSE
Responses:
Related Questions
Q6: When Excel automatically fills the rest of
Q27: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9151/.jpg" alt=" According to
Q36: If you see _ as the result
Q41: The _ function calculates the average of
Q54: Each time you create a conditional format
Q59: When you create a calculated column you
Q90: _ references make it easier to create
Q96: The _ function searches vertically down the
Q105: The _ function calculates the difference between
Q113: All the logical conditions listed in an