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
Q21: The PV is
A) a set of range
Q22: The COUNTA function
A) evaluates a condition and
Q23: A nested function
A) contains data for the
Q24: The TODAY function
A) evaluates a condition and
Q25: The logical test
A) is the lowest value
Q27: A lookup table
A) looks up a value
Q28: The Table Array
A) is the argument in
Q29: A range name
A) Indicates a cell's specific
Q30: One benefit of using range names in
Q31: The PMT function
A) is the periodic interest
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents