Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Advanced
The following formula is present in D10: =D7+F8/G8-H5+2. What is the best way to work out which value should go in F8 in order to end up with a result of 850?
Use the Scenario manager to place 850 in D10
Use Goal Seek to set D10 to 850 by changing F8
Use Goal Seek to set F8 to 850 by changing D10
Don’t know
2
Advanced
The following formula is present in D10: =D7+F8/G8-H5+2. Your manager has asked you to review the potential outcomes where F8 is equal to 45, 85, and 97. What tool would be most appropriate to use if you wanted to be able to call up each option quickly?
Goal Seek
Manually changing the values and printing the results
Scenario Manager
Don’t know
3
Advanced
When working with the Scenario Manager, in order to preserve the original information, it is 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
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement