contestada

You owe $8,000 in student loans and would like to pay it all off with your commissions. Use Goal Seek to determine the amount you must sell (cell G5) in order for cell G3 (your commission) to equal $8,000 so you can fully pay off your student loans

Respuesta :

Answer:

If we select G3 cell in the spreadsheet the limit will be set to $10,000

Explanation:

Goal seeking is technique used in Excel to calculate the input value that will give out the current output value. It can be used for trial or logical means. This can be referred to as what if analysis or back solving technique. In the current problem the cell G3 has the value of $8,000 that is owed as a student loan. We select the Goal seek in excel, set cell as G3 and set limit as $10,000.

Otras preguntas