Question

Write the steps to perform Goal Seek .​

Answer 1

Steps to Use Goal Seek Excel:

1.Put the cursor on the cell that contains the output you want to change (revenue)

2.On the Data ribbon, select What-if-analysis, then select Goal Seek (keyboard shortcut. ...

3.When the dialog box appears (as shown below) make “Set cell” equal to the revenue cell (E10)