How to Make a Data Table for What-If Analysis in Excel
Microsoft Excel offers a few features for performing analyses on what-if scenarios. One of these tools is a Data Table. With it, you can experiment with different values to see various outcomes.
Source: howtogeek.com