Question

Q.31 What is the difference between Subtotal and Goal Seek functions in a Spreadsheet?​

Answer 1

Answer:

Spreadsheet :-

• The Goal Seek Excel function (often referred to as What-if-Analysis) is a method of solving for a desired output by changing an assumption that drives it. The function essentially uses a trial and error approach to back-solving the problem by plugging in guesses until it arrives at the answer.

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