1 answer
(click or scroll down)
To create a one-variable data table in Excel, follow these steps:
1. Select the range C11:F26.
2. Go to the "Data" tab on the Excel ribbon.
3. Click on the "What-If Analysis" dropdown menu and select "Data Table".
4. In the "Row input cell" box, reference the cell that contains the formula for the monthly payment (cell D11).
5. In the "Column input cell" box, reference the cell that contains the interest rate (cell D6).
6. Click OK.
Excel will now populate the data table with the monthly payments, total interest, and total cost for interest rates ranging from 7.725% to 8.075%, based on the formulas in cells D11, E11, and F11. This table will help Nadia compare the different values based on the varying interest rates.