What is the main difference between Goal Seek and variable data tables?
A)Goal Seek produces a list of result values.
B)Goal Seek uses the original worksheet data to change an input.
C)Goal Seek manipulates multiple variables to produce multiple results.
D)Goal Seek shows results in a separate table.

Question

Quizplus · Accepted Answer

The main difference between Goal Seek and variable data tables is that Goal Seek uses the original worksheet data to change an input, whereas variable data tables manipulate multiple variables to produce multiple results. Goal Seek is used when you know the result you want to achieve, but need to find the input value to achieve it. Variable data tables, on the other hand, are used to perform what-if analysis, examining how changing multiple input values will affect the output. Therefore, B is the correct answer.

What Is the Main Difference Between Goal Seek and Variable