If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on which the formula depends.
A)verification seeking
B)the IF function
C)goal seeking
D)what-if analysis

Question

Quizplus · Accepted Answer

Goal seeking is a function in Excel that allows you to determine the value of a cell that will produce the result you want using a formula. It is helpful when you know the desired outcome, but not the input needed to produce it. By using goal seeking, you can "reverse-engineer" the formula to find the input needed to produce the result you want.

If You Know the Result You Want a Formula to Produce