This is an Excel 2013 Question. The question is how do you create a one-variable data table for the range A9:H10 using the interest rate from column B as the Row input cell.

Screen Shot 2017-04-25 at 10.10.43 PM nsert Calibri (Body) 11 Aa A Currency Delete Conditional Format Cell Paste Format Formatting as Table Styles Clipboard Alignment Styles Cells SUM K Format Shape Mortgage Options 2 Retail Cost $265,500 3 Down Payment Amount to Finance $241,500 Interest Rate 675 5 Fi 6 Term (month 180 Line Monthly Pay 37.06 6.75% 6.00% 6.25% 6.50% 7.00% 7.25% 7.50% 100 6.7s% 6.25% 6.50% 7.00% 7.25% 7.50% 120 Screen Shot 2017-04-25 at 10.11.00 PM 14 240 a 360 17 19 21 On the HomeLoan worksheet, in cell A10, enter a reference to the monthly payment from column B. Create a one-variable data table for the range A9:H10 using the interest rate from column B as the Row input cell. Editing