Which feature allows you to display different scenarios in Excel?

The correct answer is Scenario Manager, which is a powerful feature within Excel specifically designed to handle different scenarios by changing multiple input values in a spreadsheet and observing the outcome. This tool allows users to create multiple groups of input variables and view how those changes affect results in the worksheet. It is particularly useful for performing sensitivity analysis or evaluating how various combinations of inputs can impact final results, enabling users to make more informed decisions based on various potential outcomes.

While there are other features in Excel that analyze data, such as What-If Analysis and Solver Parameters, Scenario Manager is distinct in its ability to organize and display multiple scenarios side by side for comparison. Data Filtering, on the other hand, simply allows users to display a subset of data based on specific criteria, which does not facilitate the evaluation of alternative scenarios in the same way.