In Goal Seek, if the target value cannot be reached exactly, the ____.
A) Goal Seek dialog box asks for your input
B) value of zero is listed as the current value
C) closest value found is listed as the current value
D) none of the above

Question

Quizplus · Accepted Answer

If the target value cannot be reached exactly in Goal Seek, the closest value found is listed as the current value. The Goal Seek dialog box does not ask for your input, nor is the value of zero listed as the current value.

In Goal Seek, If the Target Value Cannot Be Reached