This is, in fact, true. What-if analysis is done by altering values in cells to see what outcomes are produced due to the changes. All data is kept on a worksheet to analyze. There are three types of What-if Analysis tools available in Excel, Data tables, Goal Seek, and Scenarios.