4 1a. Create a new sheet titled "Sales 2013&2014" 5 1b, Import data into this sheet from the text file: VideoGame Sales Raw Data (2541 rows of data) 6 2. In column E, use a formula to calculate the Total Sales for each game in that country. 7 3. In columns F,G,H Populate the Genre, Platform & Publisher for each video Game 8 4. On a new sheet labeled Pivot Chart & Pivot Table, create the following three charts, modifying your chart/table each time. 9 Sales by Genre, Design with Genre on the X axis and Sales on the Y. 10 Sort from high to low,Title, label and format the chart & table appropriately. Title must include your last name. 11 Copy your chart as a JPG and place it on a PowerPoint slide 12 Sales by Platform, Design with Platform on the X axis and Sales on the Y. Sort from high to low, Title, label and format the chart & table appropriately. Title must include your last name. Copy your chart as a JPG and place it on a PowerPoint slide * Action & Role-Playing Sales by Location: See sample chart Sort from high to low, Title, label and format the chart & table appropriately. Title must include your last name. Copy your chart as a JPG and place it on a PowerPoint slide 18 5. All 3 charts should now be in one PowerPoint file. 19 6. On each of the 3 slides, place at least one bullet point note, explaining the graph and what it tells us. Your note should point something out on the chart - not tell the reader that this is a chart. 21 13 14 15 16 17 20 22 E Game Name 1/2 Summer + 1/2 Summer + 1/2 Summer 5 1/2 Summer + 6 12 Sai, Honto no Kimochi 7 12-Sai. Honto no Kimochi 8 12-Sai. Honto no Kimochi 9 12-Sai, Honto no Kimochi 10 2 in 1 Combo Pack: Sonic Heroes / Super Monkey Ball Deluxe 11 2 in 1 Combo Pack: Sonic Heroes / Super Monkey Ball Deluxe 12 2 in 1 Combo Pack: Sonic Heroes / Super Monkey Ball Deluxe 13 2 in 1 Combo Pack: Sonic Heroes / Super Monkey Ball Deluxe 14 2014 FIFA World Cup Brazil 15 2014 FIFA World Cup Brazil 16 2014 FIFA World Cup Brazil 17 2014 FIFA World Cup Brazil 18 3rd Super Robot Wars Zhigoku Hen 19 3rd Super Robot Wars 2 Jigoku Hen 20 3rd Super Robot Wars 2 Jigoku Hen 21 3rd Super Robot Wars 2 Jigoku Hen 22 7th Dragon 2020-18 2000 Instructions Pivot Chart and Prot Table Sales 2013&_2014 D Unit Cost M Qty Sold Location 46 NA Sales 46 EU Sales 46 217 UP Sales 46 Other Sales 47 NA Sales 47 EU Sales 47 1,489 JP Sales 47 Other Sales SO 1.800 NA Sales 50 200 EU Sales SO JP Sales 50 200 Other Sales 47 6,170 NA Sales 47 14,255 EU Sales 47 213 JP Sales 47 4,255 Other Sales 46 NA Sales 46 EU Sales 46 9.130 JP Sales 46 Other Sales 49 NA Sales CULCAN Porno Publisher Genre
