Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Marketing The New Profit Frontier

Authors: Ed Burnett

1st Edition

0964535629, 978-0964535626

More Books

Students also viewed these Databases questions

Question

List the commonly used accuracy metrics for KNN.

Answered: 1 week ago