Answer Happy

please read.
4. a. Benicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 sales data stored in a separate workbook. Add the 2020 sales data to the All Locations worksheet as follows: Open the workbook Support_EX19_CS5-8a_2020.xlsx b. Return to the All Locations worksheet in the original workbook. o C. In cell G5, enter a formula using an external reference to display the total sales of Mini products in 2020 (cell F5). d. In the formula in cell GS, change the absolute reference to a mixed reference, with a relative reference to the row number. e. Fill the range G6:G8 with the formula in cell G5, filling without formatting. Close the workbook Support_EX19_CS5-8a_2020.xlsx
A 00 B с E E F G H => ba 3 Type 5 Mini 5 Voice-activated - Waterproof 3 Total 2020 Sales: United States Q1 Q2 Q3 Q4 Total $ 986 $ 985 $ 988 $ 982 $ 3,941 801 805 806 802 $ 3.214 682 687 684 688 $ 2.741 $ 2,469 $ 2,477 $ 2,478 $ 2,472 $ 9,896 20 in $000 1 2 3 _4
B с H 1 2 3 4 Type 5 Mini $ 6 Voice activated 5 7 Waterproof 3 Total $ 2021 Sales All Locations 01 02 03 04 Total 2020 Toti 2.3665 2,374 5 2.421 $ 2.379 $ 0.5405 9,540 1.8125 1,797 5 1844 5 1.8035 7.316 $ 7310 1,748 1.7555 1784 5 1.7971 7.0045 7.004 5,926 $5.926 $ 6,020 $ 6,039 $ 23,920 5 23.920 County US Canada Mexico Managers Name Location Todd Fenton Knoxville Natale Pierre Windsor Vicente Medina Juarez Email Address tento example.com temple.com modina sample.com Management Detas 10 in 3000 12 Performance 13 14 Revenue Amts 5 15 Rating 16 5.7003 Poor 5,800 $ Fair 5.900 5 6,000 $ 6,100 Good Very 000 Fantastic