All questions, please. with Format

o Q A B C D E F G H J K L M N P R S 1 Given below are annual data for total assets for Apple AAPL and Coca Cola KO for the period 2010-2020 as of January 31st of each year. 2 Perform the following analysis: 3 1 25pts Calculate ARITHMETIC and GEOMETRIC AVERAGE GROWTH RATE in assets for each company using an array function 4 Show average growth rates in percent (%) with two decimals! 5 2 10pts Which company had higher compound annual growth rate in assets over the period 2010-2020? 6 What was that growth rate? Provide answers in the green space on the right. 7 3 10pts Graph the trend in assets for each company using SPARKLINE charts. 8 4 15pts Graph asset values for both companies in one chartusing two different chart types in the same chart. One chart can be a column chart and the other a scatter chart with years on the X axis. 9 Place an appropriate chart title, axes titles and a legend on the graph. Make sure that the legend identifies the companies. 10 5 Label and format all results such that they are easy to read and identify 11 60pts 12 13 Note: you can add as many rows or columns to the data presented below as you find necessary. 14 15 Total Assets in $ million 16 Year APPL KO 17 2010 75,183 72,921 18 2011 116,371 79,974 19 2012 176,064 86,174 20 2013 207,000 90,055 21 2014 231,839 92,023 22 2015 290,345 89,996 23 2016 321,686 87,270 24 2017 375,319 87,896 25 2018 365,725 83,216 26 2019 338,516 86,381 27 2020 323,888 87,296 28 Arithmetic Average Growth Rate 29 Geometric Average Growth Rate