A

$1$

Instructions

$2$

$31.$ For this assignment, we will begin the process of selecting the correct "tool" or Excel function to answer a question.

$41$a$.$ Create a new sheet titled "Sales $2013$&$2014"$

$51$b$.$ Import data into this sheet from the text file: VideoGame Sales Raw Data $(2541$ rows of data$)$

$62.$ In column E$,$ use a formula to calculate the Total Sales for each game in that country.

$73.$ In columns F$,$G$,$H Populate the Genre, Platform & Publisher for each video Game

$84.$ 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 Power Point slide

$12-$ Sales by Platform, Design with Platform on the X axis and Sales' on the Y$.$

$13$ Sort from high to low, Title, label and format the chart & table appropriately. Title must include your last name.

$14$ Copy your chart as a $.$JPG and place it on a Power Point slide

$15-$ Action & Role$-$Playing Sales by Location: See sample chart

$16$ Sort from high to low, Title, label and format the chart & table appropriately. Title must include your last name.

$17$ Copy your chart as a $.$JPG and place it on a PowerPoint slide