Describe a time you have performed a what ifanalysisSolution

Describe a time you have performed a what if-analysis.

Solution

By using What if tool in Excel, you can use several different sets of values in one or more formulas to explore all the various results.

For Example, you can do what if analysis to build two budgets that each assumes a certain level of revenue. or you can specify a result that you want a formula to produce, and then determine what sets of values will produce that result. Excel provides several different tools to help you perform the type of analysis that fits your needs.