Question

Usually, you run a formula to calculate a result based upon existing values. By contrast, using you can discover what values will produce the result that you want. ka) Goal Seek (a) (b) (c) Scenario Subtotal Sort Lists​

Answer 1

OPTION A is correct.

Hope it helps you

Mark my answer as Brainliest

Answer 2

Answer:

Using Goal Seek you can discover what values will produce the result that you want.

Explanation:

Goal Seek

Goal seek is used to excel to know what value should be provided in order to achieve the given output.

For example:

We have a list of student marks in four subjects and the fifth subject marks are not known to us. The total is given as 95.32 and we are asked to predict the fifth subject marks.

For doing that we can use the goal seek function and check what marks should  be given in the fifth subject so that the total percentage becomes 95.32

Now let's see how to use goal seek.

• First, select the list of ranges in which you want to apply the prediction.
• Now go to the Data tab and click on what-if analysis.
• Click on goal seek.
• Select that cell in which the result is given.
• Click to the value and press enter.
• You will get the answer.

#SPJ3