hello. this is what i did so far! Can someone please do all 7 steps so i make sure im on the right track? thankyou!! ill definitely give thumbs up

You are asked to do Part 1 (0%) 1 Calculate the year to year change in number of units sold per country, in absolute value and in percentage 2 Highlight the drop in sales 3 Provide the sales revenue) sparkline for each country in 2019 and 2020 in US dollars 4 Calculate the year-to-year change in revenue per country, in absolute value and in percentage 5 Highlight the drop in revenue 6 Does the change in dof unit sold reflects in the change in revenue in all countries where the answer is no, explain why (use on country to explain your answer? Part 2 (20%) 7 Show the impact of the fluctuation in exchange rate on the revenue figure in each country in 2020 Part 3 (20%) 8 The outcome of this exercise should be presented in a readable, clean, presentable and Printable format 4 5 Units Sald 6 2 3 (300) Country Russia India Germany Canada Chita Australia USA UK Total 2019 Sales aty 2020 Sales Qty Qty Change Nchange 3,605 3.853 248 7% 3,966 2.500 111466) -37% 4,200 3.000 7 3,777 4,063 286 886 3,974 3,850 (124) 396 3,656 3,937 281 816 3,554 3.875 321 9% 3,844 3,344 (500) 1346 30,576 29,322 (1,254) 196 Price that Equip. LHUILLILLLLLL Country Sale Price in local currency (Unit Price) Russia 730.00 e India 1.300.00 Germany 30.00 Canada CAD 30.00 China 160.00 Australia AUD 30.00 TUSA $ 25.00 UK B 20.00 10 11 12 12 14 15 16 17 18 19 Revenue 20 22 23 24 Answer to Number 6! The change in Number of units sold and change in revenue is consistent for each country. It remains the same Country 2019 Sales 2020 Sales $ Change 36 change sparkline Russia $ 90,12500 5 96,325.00 $ 6,200.00 -20% India $ 99,150.00 $ 62,500.00 S (36,650.00) 117% Germany 105,000.00 97,500.00 $ 17.500.00) 24 Canada 5 94.425.00 $ 101.575.00$ 7,150.00 -23% China $ 99,350.00 5 95.250.00 S 3.100.00) 10% Australia S 91.400.00 $ 98.425.00 $ 7,025.00 -22% USA 5 88.850.00 $ 96875.00 $ 8,025.00 -26% UK S 96,100.00 $ 83,600.00 $ (12,500.00) 40% Total $ 754,400.00 $ 733,050.00 $ (31,850.00) 100% 126 -27 26 29