Back to lesson
1. Suppose the formula =D7+F8/G8-H5+2 is in cell D10. Which is the best method to work out the value required in F8 to get a value of 850 from the formula?
Use Goal Seek to set D10 to 850 by changing F8.
Use the Scenario manager to place 850 in D10.
Use Goal Seek to set F8 to 850 by changing D10.
2. Suppose the formula =D7+F8/G8-H5+2 is in cell D10, and you want to review the potential outcomes where F8 is equal to 45, 85 and 97. Which is the best method or tool to be able to call up each option quickly?
Manually changing the values and printing the results.
3. When working with the Scenario Manager, in order to preserve the original information, it's best to ...
Set up a Goal Seek to find out the original values needed.
Save the workbook so you can toss it away and restore the original values.
Create a base case Scenario first to allow you to reset to the original values.
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement