Question

7) Explain the utility of the following feature used in Spreadsheet: (3M)
GoalSeek
(ii) Scenario
(iii) SubTotal
(iv) goalseek​

Answer 1

Answer:

(iv),Goal seeking is the process of finding the correct input value when only the output is known. The function of goal seeking can be built into different kinds of computer software programs like Microsoft Excel.

(iii),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.

(ii),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.

If you know the result you want from a formula, use Goal Seek in Excel to find the input value that produces this formula results (3m)

Answer 2

Answer:

(iv),Goal seeking is the process of finding the correct input value when only the output is known. The function of goal seeking can be built into different kinds of computer software programs like Microsoft Excel.

(iii),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.

(ii),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.