Question

write short note on goalseek feature of excel 2016​

Answer 1

Goal Seek is a built-in Excel tool that allows you to see how one data item in a formula impacts another. You might look at these as “cause and effect” scenarios. It's useful to answer “what if” type questions because you can adjust one cell entry to see the result.

On the Data tab, in the Data Tools group, click What-If Analysis, and then click Goal Seek. In the Set cell box, enter the reference for the cell that contains the formula that you want to resolve.