Question: which what-if analysis tool is the best option for complex calculations requiring constrained optimization?

Answer: Solver

Question: What tool is used to edit pre-existing range names?

Answer: name box & name manager

Question: which tool is most effective when comparing the impact of various combinations of interest rates and down payments on a mortgage?

Answer: two-variable data table

Question: this tool calculates the value required in a single cell to produce a desired result within a related cell

Answer: goal seek

Question: this analysis tool has the ability to handle multiple adjustable cells while minimizing, maximizing, or meeting goals

Answer: solver

Question: which of the following is an excel add-in?

Answer: solver

Question: which of the following is not an acceptable range name?

Answer: 2018_Rate

Question: What is the keyboard shortcut to paste range names?

Answer: F3

Question: which of the following tools can incorporate constraints?

Answer: solver

Question: how can you determine if the solver add-in is active?

Answer: solver appears in the data tab