A user wishes to change values in a cell and see what the effects are on calculated values elsewhere in the worksheet.The user has executed a(n)________.
A) AutoFill
B) what-if analysis
C) formula
D) function

Question

Quizplus · Accepted Answer

What-if analysis allows the user to change the input values and observe the impact on the output values. AutoFill is used to quickly copy down a formula or data to adjacent cells. Formula and function are both used for performing calculations based on the input values.

A User Wishes to Change Values in a Cell and See