Question

What term refers to a specific set of values saved with the workbook ?

• A. Range
• B. Trend line
• C. Scenario
• D. What if analysis

Answer 1

Answer:

C. Scenario

Scenario

In Microsoft Excel, a Scenario is a specific set of input values that you can save and automatically substitute on your worksheet. It is part of Excel's What-If Analysis tools and is used to forecast outcomes based on different conditions (for example, saving a "Worst Case" and a "Best Case" set of budget numbers to see how they impact your total profit).

• What-If Analysis: This is the overarching process or feature group in Excel, rather than the specific saved set of values itself. Scenario Manager, Goal Seek, and Data Tables are all tools under the What-If Analysis umbrella.

• Range: This simply refers to a block of two or more selected cells on a worksheet (for example, A1:B10).

• Trendline: This is a visual graphic added to a chart to show the general direction or data trends over time, often used for forecasting or regression analysis.