To compare monthly mortgage payments based on varying the interest rate and the cost of the house,you would use ________.
A)Scenario Manager
B)Goal Seek
C)a two-variable data table
D)a multi-variable data table

Question

Quizplus · Accepted Answer

A two-variable data table is the best choice for comparing monthly mortgage payments based on varying the interest rate and cost of the house. This type of table allows you to see how changing two variables (interest rate and cost) affects the monthly payment. Scenario Manager and Goal Seek are not suitable for this task, and a multi-variable data table would be unnecessary as only two variables are being compared.

To Compare Monthly Mortgage Payments Based on Varying the Interest