Apply 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.

MkT$150$ Assignment

Student Name: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ Student Number: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$8.$ 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$

$9.$ Using the data collected, explain which city you will choose to market your game

and why.

$10.$ Insert $2$ rows above your Data and create a logo for your game placing it in Cel