After scenarios are added to a spreadsheet, you can jump to a particular scenario by using the__________, then selecting a scenario from the list.
a) Toggle option
b) Navigator
c) Contents option
d) None of these
Answers
Answer:
Scenarios are a tool to test “what-if” questions. Each scenario is named, and can be edited and formatted separately. When you print the spreadsheet, only the contents of the currently active scenario is printed.
A scenario is essentially a saved set of cell values for your calculations. You can easily switch between these sets using the Navigator or a drop-down list which can be shown beside the changing cells. For example, if you wanted to calculate the effect of different interest rates on an investment, you could add a scenario for each interest rate, and quickly view the results. Formulas that rely on the values changed by your scenario are updated when the scenario is opened. If all your sources of income used scenarios, you could efficiently build a complex model of your possible income.
Creating scenarios
Tools > Scenarios opens a dialog with options for creating a scenario. To create a new scenario:
Select the cells that contain the values that will change between scenarios. To select multiple ranges, hold down the Ctrl key as you click. You must select at least two cells.
Choose Tools > Scenarios.
On the Create Scenario dialog, enter a name for the new scenario. It’s best to use a name that clearly identifies the scenario, not the default name as shown in the illustration. This name is displayed in the Navigator and on the title bar of the scenario on the sheet itself.
Creating a scenario
Optionally add some information to the Comment box. The example shows the default comment. This information is displayed in the Navigator when you click the Scenarios icon and select the desired scenario.
Optionally select or deselect the options in the Settings section. See below for more information about these options.
Click OK to close the dialog. The new scenario is automatically activated.
You can create several scenarios for any given range of cells.
Settings
The lower portion of the Create Scenario dialog contains several options. In most cases the default settings (shown selected in the example) are likely to be suitable in most situations.