Question

Using ______ option under tools menu you can discover what values will produce the result

that you want.

class 10 , IT code 402​

Answer 1

goal seek is the correct answer

Answer 2

Answer:

The fill up along with the answer is as under-

because by contrast using goal seek , you can discover what values will produce the result that you want.

Explanation:

A Goal Seek in Excel

A spreadsheet program like Microsoft Excel has a goal seeking tool built-in. It allows the user to determine the desired input value for a formula when the output value is already known.

Using Goal Seek in Excel

• Set up our data so that we have a formula cell and a changing cell dependent on the formula cell.

• Go to the Data tab > Forecast group, click the What if Analysis button, and select Goal Seek…
• In the Goal Seek dialog box, define the cells/values to test and click OK: