What is the use of a Scenarios tool in a spreadsheet?
Answers
Answered by
2
Answer:
There are three kinds of What-If Analysis tools that come with Excel: Scenarios, Data Tables and Goal Seek. Scenarios and Data Tables take sets of input values and project forward to determine possible results.
Answered by
8
With Scenarios in Excel , you can store multiple versions of data , in the same cells . For example , when preparing a budget , the Marketing and Finance departments may have different forecasts for sales . You can store each forecast as a Scenario , print them separately , or compare them side-by-side .
PLEASE MARK ME AS BRAINLEIST AND FOLLOW ME FOR ANY QUERIES AND THANKS MY ALL ANSWERS .
Similar questions