Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ____.
A)verification seeking
B)the IF function
C)goal seeking
D)what-if analysis

Question

Quizplus · Accepted Answer

What-if analysis allows the user to change input values and see how they affect the output of a formula. This is useful for predicting different outcomes based on different scenarios. Verification seeking is not a term commonly used in Excel, the IF function is used to return one value if a condition is true and another value if it is false. Goal seeking is a specific type of what-if analysis that involves setting a target value for a formula and finding the input value that produces that result.

Using Excel to Scrutinize the Impact of Changing Values in Cells