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

1. Open the file calc-goal-seek-exercise.ods. The spreadsheet calculates the total of sales for all car models.

2. 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 €?

3. Remember to use goal seek you must determine

   • The Formula Cell

   • The Target Value

   • The Variable cell

4. 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.

5. Type the answer or result and Submit.