Multiple Choice
The HLOOKUP function
A) is the periodic interest rate, such as a monthly interest rate.
B) calculates the periodic payment for a loan with a fixed interest rate and fixed term.
C) looks up a value in a lookup table where the first column contains the values to compare with the lookup value.
D) looks up a value in a lookup table where the first row contains the values to compare with the lookup value.
Correct Answer:
Verified
Correct Answer:
Verified
Q37: A relative cell reference<br>A) indicates a cell's
Q38: The MAX function<br>A) tallies the number of
Q39: A function is a predefined formula that
Q40: The _ value is a reference to
Q41: The lookup value<br>A) is the argument in
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
Q47: A nested function<br>A) contains data for the