Multiple Choice
The column index number
A) is the periodic interest rate, such as a monthly interest rate.
B) looks up a value in a horizontal lookup table where the first row contains the values to compare with the lookup value.
C) calculates the periodic payment for a loan with a fixed interest rate and fixed term.
D) is the argument in a VLOOKUP function that identifies from which column to return a value.
Correct Answer:
Verified
Correct Answer:
Verified
Q40: The _ value is a reference to
Q41: The lookup value<br>A) is the argument in
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
Q46: The _ function calculates the periodic payment
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