Which what-if analysis tool is the best option for complex calculations requiring constrained optimization?
Solver
New cards
2
What tool is used to view existing range names?
Name Manager
New cards
3
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
New cards
4
This tool calculates the value required in a single cell to produce a result within a related cell.
Goal Seek
New cards
5
This analysis tool can handle multiple adjustable cells while minimizing, maximizing, or meeting goals.
Solver
New cards
6
Which of the following is an Excel add-in?
Solver
New cards
7
Which of the following is not an acceptable range name?
2021_Rate
New cards
8
What is the keyboard shortcut to open the Paste Name dialog box?
F3
New cards
9
Which of the following tools can incorporate constraints?
Solver
New cards
10
The Solver add-in displays on this tab in the ribbon.
Studied by 96 people
