Using the given data and steps create an Excel Sheet .

1. Create the excel sheet with the following data and save it as Question 2 & your name 2. Calculate the Total sales for each sales person in the Total Sales column 3. Find the Minimum, Maximum, and Average sales for each year 4. Using Quick Analysis Tool apply any formatting 5. Using the Quick Analysis Tool create a chart based on the data.

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|c|}{ Sales for Farmers \& Co } \\ \hline Name of Sales Person & Region & Product & Sales 2015 & Sales 2016 & Sales 2017 & Sales 2018 & Total Sales \\ \hline Tom Lu & East & Apples & 759.40 & 87.29 & 94.27 & 90.32 & \\ \hline John Brown & East & Bananas & 707.65 & 81.31 & 87.81 & 84.13 & \\ \hline Mike Jane & South & Bananas & 689 & 79.24 & 85.57 & 81.99 & \\ \hline Tim Patrick & South & Oranges & 345 & 39.68 & 42.85 & 41.06 & \\ \hline Lindy Munsch & South & Oranges & 755 & 86.83 & 93.77 & 89.85 & \\ \hline Robin Jon & South & Bananas & 305 & 3.45 & 3.73 & 3.57 & \\ \hline Jan Paul & East & Bananas & 979.45 & 112.59 & 121.59 & 116.50 & \\ \hline Lindsay Dane & East & Apples & 123 & 14.15 & 4.89 & 14.64 & \\ \hline Harvey Wood & South & Apples & 562 & 64.63 & 69.80 & 22.61 & \\ \hline Mccoy Bredin & South & Pears & 190 & 21.85 & 233.60 & 22.61 & \\ \hline Greg Heather & North & Pears & 300.98 & 21.85 & 87.80 & 35.70 & \\ \hline Peter Crow & West & Oranges & 300 & 567.80 & 102.90 & 83.78 & \\ \hline Andy Bail & West & Bananas & 138 & 15.87 & 17.14 & 16.42 & \\ \hline Carey Carr & North & Apples & 430 & 49.45 & 53.41 & 51.17 & \\ \hline \multicolumn{8}{|c|}{ Average } \\ \hline \multicolumn{8}{|c|}{ Maximum } \\ \hline & & Minimum & & & & & \\ \hline \end{tabular}