Computer Science, asked by nitinthakursinghrajp, 7 months ago

By adding ______ ,you can quickly change the arguments of a formula and view the new results​

Answers

Answered by deveshpathak8989
2

Explanation:

by scenarios

I hope this will help u

Answered by vishakasaxenasl
0

Answer:

By adding scenarios, you can quickly change the arguments of the formula and view the new results​

Explanation:

Scenarios in Excel

The name itself implies multiple views or opinions on something. Scenarios are used in Excel in to store multiple views on the same data.

Let's understand it with an example:

Suppose you have a sheet of your monthly budget in which you have entered your income, expenditures, saving, etc.

Now, lets you want to have the views by which you can increase your savings. That could be possible in two ways either you can reduce your expenses or increase your current income or you can follow both.

This thing can be implemented by the scenarios in Excel.

Creating a Scenario

  • First, click on the Data Tab and go on What-if analysis
  • A drop-down appears to click on the Scenario Manager.
  • Then click on add button and type the name for your scenario.
  • Add the rest details and click the ok button.

#SPJ3

Similar questions