The What-If Analysis has three functions that can be in store to use. The first function is the ability to create different scenarios, this is helpful when needing to know what the outcome of your data is when having chances of multiple end scenarios. For example I would use this if I were to want to know what would the change be if I raised the prices to my nail tech services. Then you can use the next function to see the different scenarios compared to one another, which would be the scenario summary of the data. I would use this type of What If function to decipher if I should continue to raise my nail tech services. The following What If function would be seeking goals, this helps with suggesting what needs to be done to get to a goal. I would use this to find out what I should price my nail tech service to get the end goal profit. 

Answer rating: 100% (QA)

1 Creating Different Scenarios Explanation This function allows you to create alternative scenarios by changing input variables and analyzing the impa... View the full answer