Critical Thinking QuestionsCase 9-2Once each month, the accounting staff meets in the conference room for a catered lunch and a discussion of ways to improve efficiency using the department's software tools. Today's meeting covers a few of Excel's advanced features. As the senior accountant and most experienced Excel user in the department, you have volunteered to mediate the discussion.
Mel, who develops budgets and financial forecasts, asks you to explain the difference between using Goal Seek and Solver to find solutions to complex worksheet projections. You tell Mel that ____.
a.
he should forget about using Goal Seek or Solver; he needs to focus on using the trial and error method insteadc.
a better approach to finding solutions to complex worksheet projections is to set data validation rules for each cell in a worksheetb.
the Solver feature finds a solution by manipulating a single variable while Goal Seek uses multiple constrained variables to find a solutiond.
the Goal Seek feature finds a solution by manipulating a single variable while Solver uses multiple constrained variables to find a solution
What will be an ideal response?
Answer: D
You might also like to view...
Risk analysis is the same activity as risk management.
Answer the following statement true (T) or false (F)
We use iterators with sequences—these can be input sequences or output sequences, or they can be _____________.
Fill in the blank(s) with the appropriate word(s).
JRadioButtons are useful when you want to give the user the ability to select more than one of the presented options.
Answer the following statement true (T) or false (F)
The _________________________ Tool selects a rectangular or square portion of the image or photo.
Fill in the blank(s) with the appropriate word(s).