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.
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.
1 answer
1 answer