When to use scenarios
You can use scenarios to take snapshots of data as you change certain variables or conditions in a science project. For example, what would happen to the temperature of a material if you gradually increased the temperature of the environment?
What-if" scenarios are helpful for data analyses.
You can create and save different groups of values on a worksheet and then switch to any of those scenarios to view different results. In the following example, a user can switch between scenarios that show what happens to a personal budget when payments on a second car are added and what happens when a second car is added with lower working hours.