Nadia wants to compare monthly payments, total interest, and total cost for interest rates that vary from 7.725% to 8.075%. She has already entered formulas to insert the
CENGAGE
Shelly Cashman Excel 2019 | Module 4: End of Module Project I
monthly payment in cell D11, the total interest in cell E11, and the total cost in cell F11. Based on the range C11:F26, create a one-variable data table that uses the rate in cell D6 as the column input cell to provide the comparison that Nadia requests.
To create a one-variable data table in Excel for the range C11:F26 with the rate in cell D6 as the column input cell, 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" option in the "Data Tools" group.
4. Select "Data Table" from the drop-down menu.
5. In the "Column input cell" field, enter or select cell D6 (the cell containing the interest rate).
6. Click OK.
This will generate a data table that shows the monthly payments, total interest, and total cost for interest rates ranging from 7.725% to 8.075%, with the rate in cell D6 as the changing variable. Nadia can now easily compare the different values based on the varying interest rates.