Question

A ___________________ feature provides a target based result and informs the user about the changes in value in the applied formula

Goal Seek

SubTotal

Sum

Scenario

Cropping off image means:​

Answer 1

Answer:

Goal Seek

Explanation:

Goal Seek is Excel's built-in What-If Analysis tool that shows how one value in a formula impacts another. More precisely, it determines what value you should enter in an input cell to get the desired result in a formula cell. ... The cell to change in order to achieve the target.

Answer 2

Answer:

A Goal seek features provide a target based result and informs the user about the changes in value in the applied formula