Microsoft Excel 2010 Expert — Question 10

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have two budget situations in which one is the worst case and the other is the best case. You want to create both situations on the same worksheet and then switch between them with the change in requirements. Which of the following will you use to accomplish the task?

Answer options

• A. Goal Seek
• B. Data table
• C. Scenario
• D. Solver add-in

Correct answer: C

Explanation

The correct answer is C, Scenario, because it allows you to create and manage multiple sets of values for your worksheet, enabling easy switching between different budget situations. Goal Seek (A) is used for finding a specific input value to achieve a desired result, while Data table (B) is more suited for analyzing multiple scenarios with different inputs, and Solver add-in (D) is for optimization problems rather than scenario management.