excel chapter 6 questions

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

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

Solver

What tool is used to view existing range names?

Name Manager

Which tool is most effective when comparing the impact of various combinations of production expenses and new customer acquisition on net sales profit?

Two-variable data table

This tool calculates the value required in a single cell to produce a result within a related cell.

Goal Seek

This analysis tool can handle multiple adjustable cells while minimizing, maximizing, or meeting goals.

Solver

Which of the following is an Excel add-in?

Solver

Which of the following is not an acceptable range name?

2021_Rate

What is the keyboard shortcut to open the Paste Name dialog box?

F3

Which of the following tools can incorporate constraints?

Solver

The Solver add-in displays on this tab in the ribbon.

Data tab.