The Table Array
A) is the argument in a VLOOKUP function that identifies from which column to return a value.
B) looks up a value in a horizontal 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 a range containing a lookup table.
Correct Answer:
Verified
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
Q26: The column index number
A) is the periodic
Q27: A lookup table
A) looks up a value
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
Q32: The RATE
A) is the periodic interest rate,
Q33: The IF function
A) contains data for the
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