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
Share
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
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
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.