0
0
Excelspreadsheet~10 mins

Scenario Manager in Excel - Interactive Code Practice

Choose your learning style9 modes available
Practice - 5 Tasks
Answer the questions below
1fill in blank
easy

Complete the code to open the Scenario Manager in Excel using the ribbon shortcut.

Excel
Go to the [1] tab and click on 'What-If Analysis' to find Scenario Manager.
Drag options to blanks, or click blank then click option'
AData
BHome
CInsert
DReview
Attempts:
3 left
💡 Hint
Common Mistakes
Choosing the Home tab instead of Data tab.
Looking under Insert or Review tabs.
2fill in blank
medium

Complete the sentence to describe what you do after opening Scenario Manager.

Excel
Click on [1] to create a new scenario with different input values.
Drag options to blanks, or click blank then click option'
AAdd
BShow
CDelete
DEdit
Attempts:
3 left
💡 Hint
Common Mistakes
Clicking Edit instead of Add to create a new scenario.
Clicking Delete which removes scenarios.
3fill in blank
hard

Fix the error in the description of input cells for a scenario.

Excel
When adding a scenario, you must select the [1] cells that will change in the scenario.
Drag options to blanks, or click blank then click option'
Aheader
Boutput
Cinput
Dtotal
Attempts:
3 left
💡 Hint
Common Mistakes
Selecting output cells instead of input cells.
Selecting header or total cells which are not scenario inputs.
4fill in blank
hard

Fill both blanks to describe how to view a scenario and exit Scenario Manager.

Excel
Select a scenario and click [1] to view it. To exit Scenario Manager, click [2].
Drag options to blanks, or click blank then click option'
AShow
BAdd
CClose
DDelete
Attempts:
3 left
💡 Hint
Common Mistakes
Clicking Add instead of Show to view a scenario.
Clicking Delete instead of Close to exit.
5fill in blank
hard

Fill all three blanks to explain how to create and name a scenario with input cells.

Excel
Click [1] to add a scenario, enter a [2] for it, and select the [3] cells that will change.
Drag options to blanks, or click blank then click option'
AAdd
Bname
Cinput
DShow
Attempts:
3 left
💡 Hint
Common Mistakes
Using Show instead of Add to create a scenario.
Confusing input cells with output cells.