Question

Saving different set of input values under different name is known as which in excel

Answer 1

Saving different set of input values under different name is known as Scenario in excel.

Explanation:

A scenario is a group of values which Excel saves and also substitutes automatically on the worksheet. The user can build and save various combinations of values as scenarios and then toggle between these scenarios to view the different type of results.

The scenarios are managed using the Scenario Manager option from the "What-If Analysis" group on the "Data" tab. The user can create a summary report which integrated information from all the scenarios.