Goal Seek exercise
Goal Seek exercise
In this exercise you will help a Car Dealer to find how many cars he must sold in order to reach his 1,000,000 € sales target.
Instructions

Open the file calcgoalseekexercise.ods. The spreadsheet calculates the total of sales for all car models.

The Toyota Avalon is a new car and has not been sold so far. Use Goal Seek to find the answer to the question: How many cars of car model Toyota Avalon the car dealer must sell in order to reach the Sales Total of 1.000.000 €?

Remember to use goal seek you must determine

The Formula Cell

The Target Value

The Variable cell


The Goal Seek result will probably be a real number with decimals (for example 3,344). Round the number UP to the first integer and fill the number in Variable Cell.

Type the answer or result and Submit.
 11 January 2018, 8:48 PM