what is the purpose of goal seek? to find a missing workbook when the user cannot remember which folder it…

what is the purpose of goal seek? to find a missing workbook when the user cannot remember which folder it was saved in. to figure out which cells to change in order to reach a desired goal. to find the dependent cells of a given cell.

what is the purpose of goal seek? to find a missing workbook when the user cannot remember which folder it was saved in. to figure out which cells to change in order to reach a desired goal. to find the dependent cells of a given cell.

Answer

Brief Explanations:

Goal Seek in spreadsheet - like Excel is used to determine the input value in a formula - based model to achieve a specific output goal. It tries to find the value of one variable that will make the result of a formula equal to a desired value.

Answer:

To figure out which cells to change in order to reach a desired goal.