question archive I have a question I don't understand can u help me please

I have a question I don't understand can u help me please

Subject:Computer SciencePrice: Bought3

I have a question I don't understand can u help me please. Here

is the question. Liam wants to compare monthly payments for interest rates that vary from 3.95% to 5.15% and for terms of 120, 180, and 240 months. He has already set up the structure for a data table in the range A12:D25.
1.       make a two-variable data table as follows to provide the comparison that Liam requests:
a.       In cell A12, enter a formula without using a function that references the monthly payment amount (cell D6) because Liam wants to compare the monthly payments.
b.       Based on the range A12:D25, make a two-variable data table that uses the term in months (cell D5) as the row input cell and the rate (cell D4) as the column input cell.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE