The purpose of Scenario Manager is to Group of answer choices a.Manage multiple scenario where calculations are unclear b.Predict the resulting changes in the data when certain aspects of the output is changed c.Predict the resulting changes in the outputs when certain aspects of the data is changed d.Help managers manage various scenarios e.Demonstrate typical scenario in spreadsheets

What does the term "Scenario Manager" refer to in Excel?

When setting up the spreadsheet for using Scenario Manager, all calculations must be made by using cell references if possible. This is because Group of answer choices 1.So that no values will be updated when changes in the data are made 2.Using cell references is cool 3.This is a required practice for any spreadsheets 4.So that all related values will be updated whenever changes in the data are made 5.Scenario Manager cannot be started without cell references used

he major purpose of Scenario Analysis in Excel is A. To evaluate different sets of assumptionsB.  To run simulations to predict future outcomes

After you have already created several different scenarios in Scenario Manager, you can still create, edit and delete those scenarios.Group of answer choicesTrueFalse

Which of the following does the Scenario Manager allow you to do?Group of answer choicesAdd or Delete ScenariosCreate a Summary ReportMerge ScenariosAll of the above