Once Each Month, the Acsaunting Staff Meets in the Sanference

Multiple Choice

Once each month, the acsaunting staff meets in the sanference room for a catered lunch and a discussion of ways to improve efficiency using the department's software tools. Today's meeting savers a few of Excel's advanced features. As the senior acsauntant 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 samplex 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 instead
B) the Solver feature finds a solution by manipulating a single variable while Goal Seek uses multiple sanstrained variables to find a solution
C) a better approach to finding solutions to samplex worksheet projections is to set data validation rules for each cell in a worksheet
D) the Goal Seek feature finds a solution by manipulating a single variable while Solver uses multiple sanstrained variables to find a solution