Ex/Eff Date	Type	Cash Amount	Declaration Date	Record Date	Payment Date
9/13/2019	Cash	0.4	7/18/2019	9/16/2019	10/1/2019
6/13/2019	Cash	0.4	4/25/2019	6/14/2019	7/1/2019
3/14/2019	Cash	0.4	2/21/2019	3/15/2019	4/1/2019
11/29/2018	Cash	0.39	10/18/2018	11/30/2018	12/14/2018
9/13/2018	Cash	0.39	7/19/2018	9/14/2018	10/1/2018
6/14/2018	Cash	0.39	4/26/2018	6/15/2018	7/2/2018
3/14/2018	Cash	0.39	2/15/2018	3/15/2018	4/2/2018
11/30/2017	Cash	0.37	10/19/2017	12/1/2017	12/15/2017
9/14/2017	Cash	0.37	7/21/2017	9/15/2017	10/2/2017
6/13/2017	Cash	0.37	4/28/2017	6/15/2017	7/3/2017
3/13/2017	Cash	0.37	2/16/2017	3/15/2017	4/3/2017
11/29/2016	Cash	0.35	10/20/2016	12/1/2016	12/15/2016
9/13/2016	Cash	0.35	7/21/2016	9/15/2016	10/3/2016
6/13/2016	Cash	0.35	4/28/2016	6/15/2016	7/1/2016
3/11/2016	Cash	0.35	2/18/2016	3/15/2016	4/1/2016
11/27/2015	Cash	0.33	10/15/2015	12/1/2015	12/15/2015
9/11/2015	Cash	0.33	7/16/2015	9/15/2015	10/1/2015
6/11/2015	Cash	0.33	4/30/2015	6/15/2015	7/1/2015

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?

3) Create a line chart plotting dividends received over the time period.

4) A sparkline creates a chart in one cell. Create a sparkline for dividends received.