By adding ______ ,you can quickly change the arguments of a formula and view the new results
Answers
Answered by
2
Explanation:
by scenarios
I hope this will help u
Answered by
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
Computer Science,
3 months ago
Math,
3 months ago
Social Sciences,
7 months ago
Biology,
11 months ago
English,
11 months ago
Hindi,
11 months ago