CGS 2518 Chapter 6

9 September 2022
4.7 (114 reviews)
10 test answers

Unlock all answers in this set

Unlock answers (6)
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