1. Compute the 2019 estimates for each group using the following formula: [2019 quantity sold + (2019 quantity sold * the increase estimate)]. The increase estimate is shown in cell B7.
2. Change the increase estimate to .10. The values should change automatically. When student create the formula they need to use an absolute reference: =B3+(B3*$B$7)
3. Format the title at the top so it stands out. Add distinct formatting to the column and row headings. Format the data in the cells to be whole numbers.
4. Create a chart showing the distribution of quantity sold in 2018 for each product category. Add a title to the chart.

A D E F G I B Quantity Sold Year 2019 1 2 Product Category 3 FURNITURE 4 OFFICE SUPPLIES 5 TECHNOLOGY 6 7 2019 increase estimate 8 Year 2020 (est) 2438 6824 3075 0.07 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23