please answer question 1 by making chart.

E General Conditional Formatting ste BI UV A $ ~ % 9 Format as Table v Cell Styles v X V fx A B C D E F G H I J K L M Ex/Eff Date Type Cash Declaration Date Record Payment Date Amount Date 9/13/19 Cash 0.4 7/18/19 9/16/19 10/1/19 6/13/19 Cash 0.4 4/25/19 6/14/19 7/1/19 3/14/19 Cash 0.4 2/21/19 3/15/19 4/1/19 11/29/18 Cash 0.39 10/18/18 11/30/18 12/14/18 9/13/18 Cash 0.39 7/19/18 9/14/18 10/1/18 6/14/18 Cash 0.39 4/26/18 6/15/18 7/2/18 3/14/18 Cash 0.39 2/15/18 3/15/18 4/2/18 11/30/17 Cash 0.37 10/19/17 12/1/17 12/15/17 9/14/17 Cash 0.37 7/21/17 9/15/17 10/2/17 6/13/17 Cash 0.37 4/28/17 6/15/17 7/3/17 3/13/17 Cash 0.37 2/16/17 3/15/17 4/3/17 11/29/16 Cash 0.35 10/20/16 12/1/16 12/15/16 9/13/16 Cash 0.35 7/21/16 9/15/16 10/3/16 6/13/16 Cash 0.35 4/28/16 6/15/16 7/1/16 3/11/16 Cash 0.35 2/18/16 3/15/16 4/1/16 11/27/15 Cash 0.33 10/15/15 12/1/15 12/15/15 9/11/15 Cash 0.33 7/16/15 9/15/15 10/1/15 6/11/15 Cash 0.33 4/30/15 6/15/15 7/1/15 Source- http://www.nasdag.com/symbol/ko/dividend-history Above is the recent dividend history for Coca-Cola Company. Use the data to complete the questions below: 1) If you owned 10,000 shares of Coca-cola stock since 4/1/2016, how much in dividends would you have collected? (Hint: Create a chart showing cash dividend per share, # shares, total) 2) Using the function AVG, what is the average amount of dividends received? 0.368333333 Hint: Use the following resources on how to create a chart and modify axis 3) Create a line chart plotting dividends received over the time period