I need to get this questions done for excel, I'll leave pictures of the excel and assignment.

A) show sales (totalcharge) by year and by store. (Hint: to get year, add another column and use the -YEAR0 function to get the year of the order's date. Now add items sold (items). Analyze the results. Make a chart which shows items and sales by year and location. What inferences can you make from this data? B) Do separate analysis to show total sales for each year by store location and category Make a chart and then Discuss the results what does your analysis indicate about sales trends for the company? C) Who were the top 3 sales people (totalhold) in 2016? Who were the top 3 in 2017