Multiple Choice
Which of these would be a good candidate for a one-variable data table and payment function?
A) Finding how much you can spend on a car with a specific goal of $450 per month payments
B) Checking scenarios with variable interest rates and down payments
C) Solving for a constraint of 3 years of payments
D) Checking scenarios with variable down payments
Correct Answer:

Verified
Correct Answer:
Verified
Q15: Solver is on the Formulas tab.
Q16: Match each of the following terms to
Q17: Goal Seek changes multiple variables to reach
Q18: Associate the following concepts with its corresponding
Q19: If Solver is installed on your computer,
Q21: Goal Seek is a what-if analysis tool.
Q22: Match each of the following tools to
Q23: To set up this two-variable data table,
Q24: Excel must have at least one formula
Q25: A one-variable data table can be built