Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Changes a cell's formatting when its contents match a specified condition
Responses:
SUMIF
logical condition
VLOOKUP
HLOOKUP
AVERAGE
conditional formatting
TRANSPOSE
DATEDIF
SUM
COUNTIF
Correct Answer:
Premises:
Responses:
SUMIF
logical condition
VLOOKUP
HLOOKUP
AVERAGE
conditional formatting
TRANSPOSE
DATEDIF
SUM
COUNTIF
Premises:
SUMIF
logical condition
VLOOKUP
HLOOKUP
AVERAGE
conditional formatting
TRANSPOSE
DATEDIF
SUM
COUNTIF
Responses:
Related Questions
Q28: Lookup _ allow you to use tables
Q50: You can use a _ function to
Q52: A(n)_ match lookup occurs when the lookup
Q57: The _ function is a logical function
Q67: The IF function evaluates a(n) <span
Q69: The _ function is a logical function
Q70: Identify the letter of the choice that
Q78: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9151/.jpg" alt=" Given the flowchart
Q79: A formula that includes a structured reference
Q112: If a formula is in a calculated