Multiple Choice
The breakpoint
A) looks up a value and returns a related result from the lookup table.
B) is a range containing a lookup table.
C) is the lowest value for a specific category or series in a lookup table.
D) is a reference to a cell containing a value to look up.
Correct Answer:

Verified
Correct Answer:
Verified
Q47: A nested function<br>A) contains data for the
Q48: One benefit of using range names is
Q49: The logical test<br>A) is the lowest value
Q50: The COUNT function<br>A) tallies the number of
Q51: The SUM function<br>A) identifies the midpoint value
Q53: An Argument (as it applies to Excel
Q54: An (A) _ cell reference provides a
Q55: A range name<br>A) Indicates a cell's specific
Q56: Because the _ function is so commonly
Q57: An absolute cell reference indicates a cell's