Which of the following tools in a spreadsheet performs "what if" analysis?
A)Excel Solver
B)Excel filter manager
C)Excel chart
D)Excel scenario manager

Question

Quizplus · Accepted Answer

Excel scenario manager is a tool used for "what if" analysis, where the user can create and save different scenarios to see how changes in inputs affect the outputs of a spreadsheet model. Excel Solver is also used for optimization and can be used as a "what if" analysis tool in certain situations, but it is primarily designed for finding a solution that maximizes or minimizes a set of constraints. Excel filter manager and chart are not relevant to "what if" analysis.

Which of the Following Tools in a Spreadsheet Performs "What