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...
The Page Header contains the information printed once at the beginning of a report
Indicate whether the statement is true or false
A contigous segment of an array is given by specifying two subscripts, lower and upper. Which of the following expressions gives the subscript of the array element that is three quarters of the way from lower to upper?
A) lower + 3 * upper /4 B) lower /3 + upper C) (upper — lower) * 3 /4 D) lower + (upper — lower) * 3 / 4