Give three examples of how you could use Goal Seek. Describe how Goal Seek uses iteration to find the solution
What will be an ideal response?
Some examples includehow much to save each month to reach a specific goal, what grade to earn on a final exam to get an A in a course, and so on. Goal Seek uses iteration to find a solution. Through this process, Goal Seek repeatedly enters new values in the variable cell to find a solution to the problem. Iteration continues until Excel has run the problem 100 times or has found an answer within .001 of the target value specified. Because Goal Seek calculates so fast, significant time and effort is saved. Without Goal Seek, you would have to manually type one number after another in the formula or a related cell to attempt to find the solution.
You might also like to view...
Suicide hackers are similar to suicide bombers, who sacrifice their life for an attack and are thus not concerned with the consequences of their actions
a. true b. false
In Microsoft Excel 2016, which of the following date data format displays dates in mm/dd/yyyy format?
A. ?Cardinal Date format B. ?Long Date format C. ?Short Date format D. ?Universal Date format