Q:
# What Is a "what If" Analysis?

A "what if" analysis occurs when a Microsoft Excel user changes the values of cells to see alterations of formulaic outcomes elsewhere on the worksheet. As of November 2014, three different types of "what if" analysis tools come with Excel, including scenarios, data tables and "Goal Seek." This type of programming allows users to budget for future scenarios, determine prices of items to meet financial goals and more.

Continue ReadingThe scenarios function saves various substitutions for values of cells already in an Excel worksheet. The Scenario Manager saves different groups of values on worksheets that can switch with the regular values. When substitute values go into the regular worksheet, values for formula outputs change. For instance, someone can switch between a "worst case" budget scenario, a "best case" budget and a middle budget without losing original data.

Data tables divide scenarios into columns and rows in a handy chart. The outputs of original formulas are in one data set, and the "what if" analysis occurs in other columns. A data table can have unlimited scenarios with one or two variables.

Goal Seek starts with a goal and works backward. Users input a desired goal, and Excel calculates input values to give that result. For instance, if a company seeks a profit of $1,000 per month, Excel can determine the requisite price per unit and how many units must sell to meet that goal.

Learn more about Software-
Q:
## How Do You Create a Work Schedule on Excel?

A: Designing a work schedule in Microsoft Excel involves creating a table and inputting the appropriate values where necessary. It is also possible to use Exc... Full Answer >Filed Under: -
Q:
## How Do You Perform Linear Regression in Excel?

A: To perform a linear regression in Microsoft Excel, input a set of values, for both the y-axis and the x-axis. A scatter plot will be produced, followed by ... Full Answer >Filed Under: -
Q:
## How Can You Sum in Excel?

A: Add values in Microsoft Excel using the SUM function =SUM ( Number1, Number2, ... Number255 ), which adds up columns or rows of numbers. "Number" represent... Full Answer >Filed Under: -
Q:
## What Does "not Equal" Do in Excel?

A: The comparison operator “not equal” in Microsoft Excel is used to compare whether one of two numerical values is less than or greater than the other. It is... Full Answer >Filed Under: