Question

why do you use goal seek function?

Answer 1

Goal Seek is a process of calculating a value by performing what-if analysis on a given set of values. For our purposes, Excel's Goal Seek feature lets you adjust a valueused in a formula to achieve a specificgoal. 
Hope it help you.

Answer 2

In computing, goal seeking is the ability to calculate backward to obtain an input that would result in a given output. This can also be called what-if analysis or back-solving. It can either be attempted through trial and improvement or more logical means.



HOPE IT'S HELP YOU