Question

what is the following use of the option present in a current scenario dialogue box
1 display order
2 copy entire sheet

Answer 1

The use of both these options is as follows:

Explanation:

1. Display Border

• Display border puts a border around the limit of cells that the scenario alters.  

• To select the colour of the border, use the option to the right of the display border.  

• The border has a title bar presenting the name of the active scenario.

2. Copy Entire Sheet

• Copy Entire Sheet adds a sheet to the document that permanently shows the new scenario in full.  

• This is an add-on to designing the scenario and making it selectable on the original sheet as normal.