Problem #2: Create a chart A. Fill in totals for 2021 using a formula. B. Projected sales for 2022 are expected to rise above the 2021 sales by the percent shown in Row 4. Fill in formula for the Projected Sales for 2022. Use an absolute reference. C. Under "keychains", calculate the totals for each column. D. Add proper formatting (merge/center titles, use borders, put numbers in correct format) E. Add 3D column chart on a new chart sheet, which shows each product and its total sales for 2019. Format it so each column shows data labels, put the legend at the right side of the chart and include an appropriate chart title. Apply formatting to the chart to make it look attractive. F. Add gradient data bars to the product Totals in columns F. Problem #3: Excel Table A. Merge/center the titles, format using borders and shading and/or cell styles. B. Calculate the Total Sales for each employee, format all numbers properly. C. Change the data into an Excel Table. Choose a style that looks attractive. D. Add a Total Row that shows the sum for Total Sales for all the employees. E. Sort the data by Last Name, filter the data to only show only salespeople from CT. Problem #4: Quarter 1 Summary A. Group sheets January, February, March. B. Format the titles using cell styles, format the numbers properly. C. Add formulas for the total in column G and row 12. Ungroup. D. Create a new worksheet, name it "Qtr1 Summary". Add labels (for the stores and products sold) to match the month worksheets. Use cell references (to the month sheets) to display the totals for the months for each item, each store, on the summary sheet. E. Add totals in column G and in row 12. Chocolate Town Gift Shop Sales 2021 Analysis Projected Sales Growth 0.05 Projected Sales for 2021 Product Chocolate Flavored Hats Chocolate Dyed shirts Chocolate Bars Chocolate Toys Chocolate Mugs Chocoate Fudge Choc. Scented Keychains 01 Q2 Q3 Q4 Totals 121200 812645 918945 606332 2459122 152622 307000 347755 229114 1036491 236200 678980 767781 506631 2189592 337563 633533 716580 478855 2166531 487200 439915 325225 236542 1488882 522300 198408 155694 148022 1024424 625112 157880 178874 117411 1079277 Sales Chart Table January February March A B D E F H Silly Sally Soda Sales by Store and Product Cases Sold Stores Elden Catalina Franklin Grant 515 545 560 435 445 435 235 275 240 Products Popgo Diet Popgo Mt. Spring Red Burst Dr Selsa 1&L Totals Flower Totals 670 510 2800 430 410 2155 240 205 1195 150 325 875 160 125 740 125 125 150 160 145 150 325 240 175 245 225 1210 1795 1775 1710 1895 1800 8975 Sales Chart Table January February March Silly Sally Soda Sales by Store and Product Cases Sold Products Popgo Diet Popgo Mt. Spring Red Burst Dr Selsa L&L Totals Stores Elden Catalina 515 545 435 445 235 275 0 0 160 145 Franklin Grant Flower Totals 560 670 510 2800 435 430 410 2155 240 240 205 1195 0 0 0 0 150 160 125 740 35 65 50 230 1420 1565 1300 7120 45 35 1445 1390 Sales Chart Table January February A B C D E F G . I Silly Sally Soda Sales by Store and Product Cases Sold Stores Elden Totals Catalina 145 Franklin Grant 150 Flower 125 160 160 65 45 35 35 50 740 230 480 95 105 140 70 70 Products Popgo Diet Popgo Mt. Spring Red Burst Dr Selsa 1&L Totals 140 60 150 0 440 90 140 155 170 140 805 325 200 240 785 175 245 225 700 1210 3905 920 820 680 Sales Chart Table January February March Problem #2: Create a chart A. Fill in totals for 2021 using a formula. B. Projected sales for 2022 are expected to rise above the 2021 sales by the percent shown in Row 4. Fill in formula for the Projected Sales for 2022. Use an absolute reference. C. Under "keychains", calculate the totals for each column. D. Add proper formatting (merge/center titles, use borders, put numbers in correct format) E. Add 3D column chart on a new chart sheet, which shows each product and its total sales for 2019. Format it so each column shows data labels, put the legend at the right side of the chart and include an appropriate chart title. Apply formatting to the chart to make it look attractive. F. Add gradient data bars to the product Totals in columns F. Problem #3: Excel Table A. Merge/center the titles, format using borders and shading and/or cell styles. B. Calculate the Total Sales for each employee, format all numbers properly. C. Change the data into an Excel Table. Choose a style that looks attractive. D. Add a Total Row that shows the sum for Total Sales for all the employees. E. Sort the data by Last Name, filter the data to only show only salespeople from CT. Problem #4: Quarter 1 Summary A. Group sheets January, February, March. B. Format the titles using cell styles, format the numbers properly. C. Add formulas for the total in column G and row 12. Ungroup. D. Create a new worksheet, name it "Qtr1 Summary". Add labels (for the stores and products sold) to match the month worksheets. Use cell references (to the month sheets) to display the totals for the months for each item, each store, on the summary sheet. E. Add totals in column G and in row 12. Chocolate Town Gift Shop Sales 2021 Analysis Projected Sales Growth 0.05 Projected Sales for 2021 Product Chocolate Flavored Hats Chocolate Dyed shirts Chocolate Bars Chocolate Toys Chocolate Mugs Chocoate Fudge Choc. Scented Keychains 01 Q2 Q3 Q4 Totals 121200 812645 918945 606332 2459122 152622 307000 347755 229114 1036491 236200 678980 767781 506631 2189592 337563 633533 716580 478855 2166531 487200 439915 325225 236542 1488882 522300 198408 155694 148022 1024424 625112 157880 178874 117411 1079277 Sales Chart Table January February March A B D E F H Silly Sally Soda Sales by Store and Product Cases Sold Stores Elden Catalina Franklin Grant 515 545 560 435 445 435 235 275 240 Products Popgo Diet Popgo Mt. Spring Red Burst Dr Selsa 1&L Totals Flower Totals 670 510 2800 430 410 2155 240 205 1195 150 325 875 160 125 740 125 125 150 160 145 150 325 240 175 245 225 1210 1795 1775 1710 1895 1800 8975 Sales Chart Table January February March Silly Sally Soda Sales by Store and Product Cases Sold Products Popgo Diet Popgo Mt. Spring Red Burst Dr Selsa L&L Totals Stores Elden Catalina 515 545 435 445 235 275 0 0 160 145 Franklin Grant Flower Totals 560 670 510 2800 435 430 410 2155 240 240 205 1195 0 0 0 0 150 160 125 740 35 65 50 230 1420 1565 1300 7120 45 35 1445 1390 Sales Chart Table January February A B C D E F G . I Silly Sally Soda Sales by Store and Product Cases Sold Stores Elden Totals Catalina 145 Franklin Grant 150 Flower 125 160 160 65 45 35 35 50 740 230 480 95 105 140 70 70 Products Popgo Diet Popgo Mt. Spring Red Burst Dr Selsa 1&L Totals 140 60 150 0 440 90 140 155 170 140 805 325 200 240 785 175 245 225 700 1210 3905 920 820 680 Sales Chart Table January February March