Multiple Choice
A nested function
A) contains data for the basis of the lookup and data to be retrieved.
B) is the lowest value for a specific category or series in a lookup table.
C) looks up a value and returns a related result from the lookup table.
D) contains another function embedded inside one or more of its arguments.
Correct Answer:
Verified
Correct Answer:
Verified
Q42: The HLOOKUP function<br>A) is the periodic interest
Q43: To insert a function by typing first
Q44: The TODAY function<br>A) evaluates a condition and
Q45: The column index number<br>A) is the periodic
Q46: The _ function calculates the periodic payment
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
Q52: The breakpoint<br>A) looks up a value and