Final answer:
In Excel, the Scenario Manager helps track multiple what-if models by creating and comparing different sets of values for cells. Contingency tables and least-squares regression lines are also valuable in organizing data and analyzing models.
Step-by-step explanation:
In Microsoft Excel, the feature that helps you keep track of multiple what-if models is called Scenario Manager. Using Scenario Manager, you can create different sets of values, or scenarios, for various cells in your worksheet and switch between these scenarios to compare different models. This tool is very useful for financial modeling, budgeting, or any situation where you want to assess the impact of different assumptions on the outcome of your models.
When dealing with probabilities and dependent variables, tools like contingency tables are also useful as they help you organize and display data to easily calculate probability outcomes. Along with contingency tables, using Excel to graph least-squares regression lines can also provide insights as you can compare the slopes and fit of these lines to your data, aiding in predictive what-if analysis.