Shortly after graduation from Lambton College in Toronto, you started working at a local bank. Your job requires a lot of analysis, and you make sure to utilize the available technology to accomplish this task. Your manager was discussing the below investment with you and provided you with some data, which is listed below. The manager is not sure how to present this data. You'd like to make sure that it's easy to understand the information for the unsophisticated investor. So, you decided to use excel to accomplish this task. Use the "adj. close" to make a chart in excel. Your chart x-axis should show the date.Submit a 1 sheet excel document showing this information. Date Open High Low Close Volume Chg % Chg Adj. Close 02/15/2019 21.49 21.51 21.03 21.32 3.83m -0.23 -1.07% 21.32 02/14/2019 21.24 21.62 21.08 21.55 2.38m 0.34 1.60% 21.55 02/13/2019 21.24 21.34 21.06 21.21 1.35m 0.03 0.14% 21.21 02/12/2019 21.17 21.24 21.09 21.18 1.22m 0.08 0.38% 21.18 02/11/2019 20.89 21.16 20.84 21.10 1.17m 0.17 0.81% 21.10 02/08/2019 20.71 20.95 20.63 20.93 1.6m 0.23 1.11% 20.93 02/07/2019 20.85 20.93 20.59 20.70 3.42m -0.17 -0.81% 20.70 02/06/2019 20.79 20.98 20.73 20.87 1.12m 0.08 0.38% 20.87 02/05/2019 20.92 21.03 20.62 20.79 1.45m -0.05 -0.24% 20.79 02/04/2019 20.90 21.01 20.64 20.84 1.25m -0.04 -0.19% 20.84 02/01/2019 21.13 21.14 20.80 20.88 1.6m -0.24 -1.14% 20.88 01/31/2019 21.29 21.31 21.02 21.12 1.4m -0.10 -0.47% 21.12 01/30/2019 21.44 21.44 21.12 21.22 1.31m 0.02 0.09% 21.22 01/29/2019 21.15 21.36 21.01 21.20 1.22m 0.16 0.76% 21.20 01/28/2019 21.00 21.07 20.64 21.04 1.04m 0.03 0.14% 21.04 01/25/2019 21.03 21.19 20.87 21.01 1.15m 0.06 0.29% 21.01 01/24/2019 20.75 21.015 20.65 20.95 948.79k 0.26 1.26% 20.95 01/23/2019 21.25 21.25 20.58 20.69 1.31m -0.48 -2.27% 20.69 01/22/2019 21.49 21.49 21.04 21.17 1.12m -0.23 -1.07% 21.17 01/21/2019 21.79 21.79 21.40 21.40 696.1k -0.18 -0.83% 21.40 01/18/2019 21.45 21.68 21.41 21.58 1.72m 0.31 1.46% 21.58 01/17/2019 21.11 21.32 21.02 21.27 931.12k 0.13 0.61% 21.27

Evaluation: Creating a chart in excel (3%) X-axis is shows date (1%) Y-axis shows "adj close" (1%)