Chapter 7 Excel

https://edu.gcfglobal.org/en/excel2016/whatif-analysis/1/

Problem 1

Challenge!

1. Open our  practice workbook .

2. Click the Challenge tab in the bottom-left of the workbook.

3. In cell B8, create a function that calculates the average of the sales in B2:B7.

4. The workbook shows Dave's monthly sales amounts for the first half of the year. If he reaches a $200,000 mid-year average, he will receive a 5% bonus. Use Goal Seek to find how much he needs to sell in June in order to make the $200,000 average.

5. When you're finished, your workbook should look like this:

Problem 2