Excel Total row and Sort & filter options, display the following statistics. Hint: You will need to change your data to a table format. Enter your answers$/$formulas in cells M$2$:M$4$ on the Customer Survey sheet. $($Show your results with zero decimal places$)$Average age of Undisclosed Gender in Owen Sound who spent money on Gaming. $[$ No one in Owen sound as undisclosed gender $]$Create a header to include yourFirst and Last Name on the left,the answer to question $($a$)$ on the right andthe current date filed in the center, on the Customer Survey worksheet.Average age of males likely to purchase games in the city found to have the highest population.$[$ Toronto has the most highest population. Average of $($ b$11,$ b$48,$ b$237)]$Average age of all genders in all locations.$[=$AVERAGE$($Table$1[$Age$])]$On the Customer Survey sheet, convert your table back to a data range and then create a pivot table to be placed on the Pivot Table & Chart worksheet starting at cell A$1,$ which will display each of the following criteria.Save the information a $3$D column pivot chart on the same worksheet placing the top left corner of the chart in cell G$3.$ Set all monetary values to Accounting format.City with the maximum household income totalAverage population of all citiesThe city where most money was spent on gaming.On the Customer Survey sheet,change your date to a table andsort your data by Customer ID smallest to largest,Using an excel functions$/$formula determine the household income and location for the following customer ID$$s$.$Place your answers$/$formulas in cells M$6$:M$10.$ Be sure to use absolute cell reference when necessary. Hint: You will need to use a lookup function$\mathrm{.}6009660262602306016680276$Filter the Pivot Chart you created in step $2,$ to display only the above $5$ cities to market your new game in$.$On the Customer Survey worksheet, use the lookup table found in K$29$:U$32$ to locate the average game rating related to the locations listed below. Place your answers$/$formulas in cells M$12$:M$16$ Hint: You will need to use a Lookup function.Thunder BayTimiskaming ShoresKitchenerBrantfordBrantOn the Customer Survey worksheet, use the lookup table found in K$29$:U$32$ to locate the average household income related to the locations listed below. Place your answers$/$formulas in cells M$18$:M$22$ Hint: You will need to use a Lookup function.PickeringKitchenerHaldimand CountyQuinte WestNiagara FallsApply the subtotal feature to your data range $($A$1$:I$301),$ to show each city by game rating. Hint: you must convert your data back from Table to Range. Collapse the cities to display only the subtotals and not the summary of each.Remove all subtotals, and then create a formula to display the Most, Average, and Median game ratings placing your answers in cell M$24$:M$26$Using the data collected, explain which city you will choose to market your game and why.Insert $2$ rows above your Data and create a logo for your game placing it in Cell A$1$:B$4.$