9
AssignmentMultiple Choice

Forecasting Data

Question 9 • TX-Business Information Management (BIM) I

For which task is the Goal Seek feature most helpful?

Answer
A
selecting random values for the result of a formula
B
identifying calculations that are missing from a function
C
adjusting a formula to export its result to a separate worksheet
D
working backward to identify the input values for a specific result

Explanation

Goal Seek works backward from a desired result in a formula and finds the input value that would produce it. For example, you can specify a target profit and have Goal Seek find the sales amount needed to reach it. So it is most helpful for identifying input values for a specific result.

AI-written and checked against the verified answer.

Previous
Next