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​

Answer 1

${\huge{\underline{\underline{\sf{\orange{Answer:-}}}}}}$

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

• A) Goal seek☑️

Thanks!

Answer 2

Answer:

In computing, goal seeking is the ability to calculate backward to obtain an input that would result in a given output. This can also be called what-if analysis or back-solving. It can either be attempted through trial and improvement or more logical means.

Use the SUBTOTAL function to exclude filtered or hidden rows when calculating a total. You can choose any one of the 11 functions that SUBTOTAL can calculate, such as Sum, Average, Count or Max.

The definition of a scenario is a series of events that is projected to occur. When you run through all of the possible outcomes of a conversation in your head, this is an example of a situation where you run through all possible scenarios.