What-if analysis allows users to ________.
A) create graphs and charts of existing data.
B) insert built-in programs that perform tasks like SUM and AVERAGE.
C) change values in spreadsheet cells to investigate the effects on calculated values of interest.
D) create an equation that produces a result.

Question

Quizplus · Accepted Answer

What-if analysis is a technique that allows users to change values in spreadsheet cells to investigate the effects on calculated values of interest. This is particularly useful for exploring various scenarios and making informed decisions based on the analysis of those scenarios. The other options listed (creating graphs and charts of existing data, inserting built-in programs, and creating an equation) are all functions that can be performed within a spreadsheet, but they are not specifically related to what-if analysis.

What-If Analysis Allows Users to ________