Question

write the steps to use what if scenarios use what if tools​

Answer 1

• The situation Manager permits you to substitute input values for multiple cells (up to 32).
• In this method, you'll be able to read the results of various input values (or scenarios) at an identical time.
• A what-if situation is off-the-cuff speculation regarding however a given scenario may well be handled.
• The additional queries that square measure asked, answered, and reviewed throughout every stage of the project lifecycle, the additional hip to the project manager is, and therefore the additional foreseeable the project outcome.

Scenarios square measure used for write steps to feature eventualities within the sheet:

• On the Ribbon's knowledge tab, click What-If Analysis.
• Click situation Manager.
• In the situation Manager, click the Add button.
• Type name for the situation. ...
• Press the tab, to maneuver to the dynamic cells box.
• On the worksheet, choose cells B1.
• Hold the Ctrl key, and choose cells B3:B4.