Question

Explain the use of 'Copy back' option present in a Create Scenario dialog box.​

Answer 1

Answer:

•Tools > Scenarios opens a dialog with optionsfor creating a scenario.

•Display border.

•Copy back.

•Copies any changes you make to the values of scenario cells back into the active scenario.

•Copy entire sheet.

•Prevent changes.

•Prevents changes to a Copy back-enabled scenario when the sheet is protected but the cells are not.