please answer QUESTION 2 only

Home Insert Draw Page Layout Formulas Data Review View X v Calibri (Body) 11 ' ' Genera Paste B I Uv IMM $ y B21 x fx http://www.nasdaq.com/symbol/ko/dividend-history H 0.4 B D E F G Ex/eff Date Type Cash Declaration Date Record Payment Date 1 Amount Date 2 9/13/19 Cash 7/18/19 9/16/19 10/1/19 3 6/13/19 Cash 0.4 4/25/19 6/14/19 7/1/19 4 3/14/19 Cash 0.4 2/21/19 3/15/19 4/1/19 5 11/29/18 Cash 0.39 10/18/18 11/30/18 12/14/18 6 9/13/18 Cash 0.39 7/19/18 9/14/18 10/1/18 7 6/14/18 Cash 0.39 4/26/18 6/15/18 7/2/18 8 3/14/18 Cash 0.39 2/15/18 3/15/18 4/2/18 9 11/30/17 Cash 0.37 10/19/17 12/1/17 12/15/17 10 9/14/17 Cash 0.37 7/21/17 9/15/17 10/2/17 11 6/13/17 Cash 0.37 4/28/17 6/15/17 7/3/17 12 3/13/17 Cash 0.37 2/16/17 3/15/17 4/3/17 13 11/29/16 Cash 0.35 10/20/16 12/1/16 12/15/16 14 9/13/16 Cash 0.35 7/21/16 9/15/16 10/3/16 15 6/13/16 Cash 0.35 4/28/16 6/15/16 7/1/16 16 3/11/16 Cash 0.35 2/18/16 3/15/16 4/1/16 17 11/27/15 Cash 0.33 10/15/15 12/1/15 12/15/15 18 9/11/15 Cash 0.33 7/16/15 9/15/15 10/1/15 19 6/11/15 Cash 0.33 4/30/15 6/15/15 7/1/15 20 Source - http://www.naschq.com/symbol/ko/dividend history 22 23 Above is the recent dividend history for Coca-Cola Company. Use the data to complete the questions below: 25 1) If you owned 10,000 shares of Coca-Cola stock since 4/1/2016, how much in dividends would you have collected? (Hint 26 27 28 29 2) Using the function AVG, what is the average amount of dividends received? 30 31 0.368333333 32 33 3) Create a line chart plotting dividends received over the time period. Hint: Use the following Learning Objectives Fees & Credits Analysis + Ready