a) Goal Seek
b) Scenario Solver
d) Subtotal
Fatimalus inserted a picture in a document. But she wants to cut off a part of the picture
Which option she should use to accomplish the task?
al Cut
b) Copy
Layout
Answers
Answer:
a goal seek
b copy
it will help you
Answer:
What is GoalSeek?
Goalseek is an advanced spreadsheet feature that allows us to provides the values for the target based input. Just decide the target value and you can select which cell should be changed in goalseek dialog box.
Steps to apply goal seek in MS Excel
To apply goalseek in MS excel worksheet, enter the data, and perform the calculations as you want. I have prepared the following data to perform goalseek in MS Excel.
Goalseek Data
GoalSeek Data
In the above screenshot, Rate and Quantity are given and the amount is computed accordingly. Now I want to achieve the target amount 500, so what should be rate can be or how many quantities required for the same, goalseek helps to do the same.
Select the cell where the formula is written. For my example, I have placed the cursor in B4.
Click on Data → What-if Analysis → Goal Seek option from the forecast group.
Data - What if Analysis - GoalSeek
Data – What if Analysis – GoalSeek
A GoalSeek dialog box will appear as displayed in the following screenshot:
GoalSeek in MS Excel 2019
GoalSeek in MS Excel 2019
Type the desired value i.e. 500 in To Value box and select the cell address for by changing cell option as displayed in the following screenshot.
GoalSeek Input
GoalSeek input
Click on OK button the values will be displayed in your worksheet as displayed in the following screen shot.
GoalSeek Output
Click on OK button to accept the result, click cancel to return with original data.
Goal Seek in OO Calc
Place the cursor in B4 cell and click on Tools → GoalSeek option.
A Goal Seek dialog box appears as displayed in the following screenshot.
GoalSeek dialog box in OO Calc
Type the desired value for target value and select the variable cell to display the changed value. Observe this dialog box.
Setting up GoalSkeet input in OO Calc
Now click on OK button. A result will be displayed in a new dialog box. Observe the following screenshot.
Click on Yes button to accept the value. The result will be displayed as below given screen shot.
Final result GoalSeek in OO Calc
Solver in OO Calc
GoalSeek allows to display the target based results on single value or condition. Whereas the solver is used to optimize the result based on conditions. Follow the given steps to use solver:
Place the cursor in the cell where formula is entered.
Now Click on Tools → Solver.
Solver Option in OO Calc
Now solver dialog box will appear as displayed in the following screen shot.
Solver dialog box in OO Calc
Select the optimize result to option, select the by changing cells and provide the value in limiting conditions. Observe the following screen shot what I have done!
Solver input and result optimization`
Click on Keep result button to accept the changes otherwise click on restore previous.
Explanation: