203k views
0 votes
Which statement best describes an Excel What-If Analysis Goal Seeking?

answer choices
A. Allows you to define output results and then shows what input values are needed to generate that result.
B. Allows you to investigate how changes to one or two input variables in a formula changes output results
C. Allows you to define input variables in various situations. The output result for each situation is show in a summary table.

1 Answer

3 votes

Answer:A

Step-by-step explanation:

What if analysis Goal seeking works with only one input value therefore it can't be B or C because they both work with one or more input values . Also goal seeking works when you already know the output results therefore the answer is A.

User Glen Little
by
5.6k points