used in problems when a person has a preferred result
and has numerous inputs needed to attain this result.
the GOAL is what is already known, and the several
inputs are being calculated in order to achieve
An example of this would be a monthly payment
or a piece of machinery for farming and a targeted
price is in mind.This tool helps you achieve this targeted
learn about the scenario function on Microsoft
Excel we must first define what a scenario is:
group of possible circumstances one would want
to look into when concluding a spreadsheet
by programming desired settings into the
scenario manage field.
are set up and used to look at problems with
sales increase by10%, what would happen to your
net income? Instead of creating awkward "if
analyses”, you may want to use Excel’s
scenarios. Scenarios are just versions of the
same set of data, like the usual best- and
worst-case scenarios. You can easily use Excel’s
Scenario Manager to develop your scenarios and
then switch between them.