Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Tactics layer ritina guard senki

27/11/2021 Client: muhammad11 Deadline: 2 Day

YO19_Excel_Ch06_Assessment_Video_Game_Sales_Instructions.docx
Grader - Instructions Excel 2019 Project

YO19_Excel_Ch06_Assessment_Video_Game_Sales
Project Description:
Samantha Vee, the owner of a local video game store, is interested in how video games sales vary by platform and region. She has acquired a sample data set and needs your help to explore the data.

Steps to Perform:
Step

Instructions

Points Possible

1

Start Excel. Download and open the file named Excel_Ch06_PS2_VideoGameSales.xlsx. Grader has automatically added your last name to the beginning of the filename.

0

2

The data on the VideoGameSales worksheet includes sales (in millions) for several video games on various platforms and from various genres. On the VideoGameSales worksheet, insert a table with headers using the data.

0.8

3

Apply the Light Blue, Table Style Medium 27 to the table and with the table selected, including the headers, create a SalesDatabase named range to be used in database functions later.

1

4

Add a Total Row to the table to have the sales values in the NorthAmerica, Europe, Japan, Other, and GlobalSales columns summed.

1

5

Slicers are an easy way to explore data in a table. Insert slicers for Platform, Year, and Genre.

1

6

Move the Platform slicer so that its top-left corner is just inside the border of cell K1. Modify its Layout property so that it has 3 columns and resize the slicer so that all options are visible and extra white space is minimal. Apply the White, Slicer Style Other 2 style to the slicer.

0.4

7

Move the Genre slicer so that its top-left corner is just inside cell N1. Modify its Layout property so that it has 2 columns and resize the slicer so that all options are visible and extra white space is minimal. Apply the White, Slicer Style Other 2 style to the slicer.

0.4

8

Move the Year slicer so that its top-left corner is inside cell K13. Modify its Layout property so that it has 3 columns and resize the slicer so that all options are visible and extra white space is minimal. Modify the setting so that the caption reads Release Year. Apply the White, Slicer Style Other 2 style to the slicer.

0.4

9

Using the slicers, filter the Table to only show records where the Platform is PS3 and DS and the Genre is either Adventure or Action. Select the filtered data, including column headings and the Total row, and paste the data on the SelectData worksheet, starting in cell A1. Adjust the column widths as necessary so that all data are visible.

1.2

10

Clear the filters applied to the VideoGameSales data. Copy the headings and paste them onto the DatabaseTotals worksheet, starting in cell A1 to begin to setup and create database functions to further analyze the data. If necessary, adjust the column widths so that all data are visible.

1

11

Complete the DatabaseTotals worksheet using the appropriate database functions using the SalesDatabase named range, use GlobalSales as the field in your calculations, and only calculate games that meet the following criteria: In row 2, specify the criteria for games on the Wii platform with a release year of newer than 2006 In row 3, specify the criteria for games on the DS platform in the Adventure genre.

4

12

Using the data on the VideoGameSales worksheet, create a PivotTable on a new worksheet and rename the worksheet, PivotAnalysis.

1

13

Structure the PivotTable on the PivotAnalysis worksheet according to the following: Filters: Publisher Rows: Platform and Year Columns: Genre Values: Sum of GlobalSales

1.2

14

Configure the PivotTable on the PivotAnalysis worksheet according to the following: Create a custom name for Sum of GlobalSales to be Total GlobalSales (in millions) Format Total GlobalSales as Accounting with 2 decimal places Change Row Labels in cell A4 to Platform and Year Change Column Labels in cell B3 to Genre Apply Light Blue, Pivot Style Light 9 Adjust the column widths, if necessary.

1.2

15

Using the data on the VideoGameSales worksheet, insert a PivotChart on a new worksheet. Rename the worksheet with the PivotChart and PivotTable, NorthAmericanSalesByPlatform.

1

16

Structure the PivotChart on the NorthAmericanSalesByPlatform worksheet according to the following: Filters: Genre Axis (Categories): Platform Values: Sum of NorthAmerica

1.2

17

Configure the PivotChart on the NorthAmericanSalesByPlatform worksheet according to the following: Change the Chart Type to Clustered Bar. Apply a Style 4 Chart Style Apply a Layout 1 Quick Layout Edit the chart title to North American Sales by Platform Delete the Legend Move the PivotChart to a new worksheet with the name SalesByPlatformPivotChart

1.2

18

Using the PivotTable on the NorthAmericanSalesByPlatform worksheet, create a drill-down of the DS sales and rename the worksheet created NorthAmericanSalesDS.

1

19

Using the PivotChart on the SalesByPlatformPivotChart worksheet, modify the Genre filter to only show data for Action, Adventure, and Fighting genres.

1

20

Save and close Excel_Ch06_PS2_VideoGameSales.xlsx. Exit Excel. Submit the file as directed.

0

Total Points

20

Created On: 12/14/2019 1 YO19_Excel_Ch06_PS2 - Video Game Sales 1.0

McDonald_Excel_Ch06_PS2_VideoGameSales.xlsx
VideoGameSales
Name Platform Year Genre Publisher NorthAmerica Europe Japan Other GlobalSales
Jeopardy! 2nd Edition PS 2000 Misc Hasbro Interactive $ 0.16 $ 0.11 $ - 0 $ 0.02 $ 0.29
TrackMania Turbo PS4 2016 Action Ubisoft $ 0.03 $ 0.24 $ - 0 $ 0.05 $ 0.32
Touch Detective: Nameko Shigeru 3DS 2013 Adventure Success $ - 0 $ - 0 $ 0.07 $ - 0 $ 0.07
NHL 16 PS3 2015 Sports Electronic Arts $ - 0 $ 0.03 $ - 0 $ 0.01 $ 0.04
Ride PS4 2015 Racing Milestone S.r.l. $ 0.03 $ 0.13 $ 0.03 $ 0.03 $ 0.22
Dragon Zakura DS DS 2007 Misc Electronic Arts $ - 0 $ - 0 $ 0.01 $ - 0 $ 0.01
Sherlock Holmes: Crimes & Punishments PS3 2014 Adventure Focus Home Interactive $ 0.03 $ 0.04 $ - 0 $ 0.01 $ 0.08
Ace Attorney Investigations 2 DS 2011 Adventure Capcom $ - 0 $ - 0 $ 0.26 $ - 0 $ 0.26
Metal Fight Beyblade DS 2009 Action Hudson Soft $ - 0 $ - 0 $ 0.09 $ - 0 $ 0.09
Farmtopia DS 2010 Simulation 505 Games $ 0.18 $ - 0 $ - 0 $ 0.01 $ 0.19
Pokemon Ranger DS 2006 Role-Playing Nintendo $ 1.29 $ 0.04 $ 0.73 $ 0.12 $ 2.18
BeatMania IIDX 16: Empress + Premium Best PS2 2009 Simulation Konami Digital Entertainment $ - 0 $ - 0 $ 0.04 $ - 0 $ 0.04
Mobile Suit Gundam Seed: Rengou vs. Z.A.F.T. Portable PSP 2007 Shooter Namco Bandai Games $ - 0 $ - 0 $ 0.12 $ - 0 $ 0.12
MiniCopter: Adventure Flight Wii 2007 Simulation 505 Games $ 0.04 $ - 0 $ - 0 $ - 0 $ 0.05
Super Speed Machines DS 2009 Racing Midas Interactive Entertainment $ 0.02 $ - 0 $ - 0 $ - 0 $ 0.02
Knockout Kings 2001 PS 2000 Fighting Electronic Arts $ 0.23 $ 0.15 $ - 0 $ 0.03 $ 0.41
Clock Zero: Shuuen no Ichibyou - ExTime PSV 2015 Action Idea Factory $ - 0 $ - 0 $ 0.02 $ - 0 $ 0.02
Walt Disney Pictures Presents: The Wild GBA 2006 Platform Disney Interactive Studios $ 0.09 $ 0.03 $ - 0 $ - 0 $ 0.13
Marker Man Adventures DS 2009 Platform Majesco Entertainment $ 0.02 $ - 0 $ - 0 $ - 0 $ 0.03
Tactics Layer: Ritina Guard Senki DS 2009 Strategy D3Publisher $ - 0 $ - 0 $ 0.01 $ - 0 $ 0.01
From TV Animation One Piece: Yume no Lufy Kaizokudan Tanjou! GB 2001 Role-Playing Banpresto $ - 0 $ - 0 $ 0.39 $ - 0 $ 0.39
Pac-Man Player's Choice Bundle GC 2003 Misc Namco Bandai Games $ 0.48 $ 0.12 $ - 0 $ 0.02 $ 0.62
Burnout Paradise X360 2008 Racing Electronic Arts $ 0.63 $ 0.58 $ 0.01 $ 0.15 $ 1.36
Prison Break: The Conspiracy PS3 2010 Action Deep Silver $ 0.05 $ 0.16 $ - 0 $ 0.05 $ 0.26
Mario Golf: Toadstool Tour GC 2003 Sports Nintendo $ 1.09 $ 0.15 $ 0.25 $ 0.04 $ 1.53
Poker for Dummies PC 2008 Misc Electronic Arts $ - 0 $ 0.01 $ - 0 $ - 0 $ 0.01
Resident Evil 5 PC 2009 Action Capcom $ 0.01 $ 0.04 $ - 0 $ 0.01 $ 0.07
Far Cry Instincts XB 2005 Shooter Ubisoft $ 0.32 $ 0.24 $ - 0 $ 0.02 $ 0.57
Grand Theft Auto: Mission Pack #1, London 1969 PS 1998 Adventure Take-Two Interactive $ 0.06 $ 0.04 $ - 0 $ 0.01 $ 0.11
SimCity SNES 1991 Simulation Nintendo $ 0.93 $ 0.27 $ 0.75 $ 0.04 $ 1.98
Data from “Video Game Sales” compiled by GregorySmith, https://www.kaggle.com/gregorut/videogamesales
SelectData
DatabaseTotals
Field
Sum
Average
Count
Max
Min
Documentation
Video Game Sales
Create Date By Whom Description Workbook Name
5/12/22 Samantha Vee Excel_Ch06_PS2_VideoGameSales_solution.xlsx
Mod. Date By Whom Mod. Description Last Version Backup Name
Create Date Sheet Name Creator Purpose
5/12/22 VideoGameSales Samantha Vee Sample data of global video game sales
5/12/22 SelectData Samantha Vee Filtered data for focused analysis
5/12/22 DatabaseTotals Samantha Vee Exploring data with database functions
5/12/22 PivotAnalysis Samantha Vee PivotTable analysis to explore Global Sales
5/12/22 NorthAmericanSalesByPlatform Samantha Vee PivotTable analysis to explore North American Sales
5/12/22 NorthAmericanSalesDS Samantha Vee Data about North American sales for the Nintendo DS
5/12/22 SalesByPlatformPivotChart Samantha Vee To explore sales by platform visually

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Engineering Guru
Math Guru
Professional Coursework Help
Quality Assignments
Buy Coursework Help
Top Writing Guru
Writer Writer Name Offer Chat
Engineering Guru

ONLINE

Engineering Guru

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$48 Chat With Writer
Math Guru

ONLINE

Math Guru

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$25 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$26 Chat With Writer
Quality Assignments

ONLINE

Quality Assignments

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$45 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$35 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$28 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Alcoa foundation grant application - Visualization tool analysis on a dataset - The perfect ceo case study solution - Which pope commanded the artist to paint the ceiling - Lpkf pcb milling machine - Hamilton new zealand postcode - Final week - Figurative language in the song hall of fame - Purification of Bovine Brian Tubulins - Eastern creek waste management centre - Fictional character case study examples - George eliot hospital chronic fatigue - Civilize them with a stick summary - Erikson's stages of development summary - Werribee mercy hospital values - Each chef at sushi emperor prepares - Orthogonal trajectories x 2 y 2 cx - Starbucks employee training and development - Test definition in education - Summary/response paper 4 pages. - Chapter 9 statistics answers - Symbols for statistical significance - Oculus biomed pty ltd - Fluid volume overload nursing diagnosis - Introduction to sociology openstax citation - Globe telecom number of subscribers - Ashdon primary school essex - Give me liberty 5th edition volume 2 - Florida nurse practitioner scope of practice - Clinical Supervision - Enron the smartest guys in the room ethical issues - Human resource - Conclusion of the ugly duckling story - Significance (why this issue matters) 1-PARAGRAPH - Dunkin donuts application pdf 2020 - Sydney south west cross country - Does mcdonalds use beef in fries - Ideal gas law worksheet - Sea company reports the following information regarding its production cost - Power Point with strong reference - Franchising decisions in retailing ppt - Interactivity Research Assignment - Grease spot test definition - Scale drawings and models homework answer key - Dank null docking station extract - Unit 12 it technical support - Detroit 60 series running rough - Longhorn corporation provides low cost food delivery - How to use endnote uq - Unit IV assignment - Valleylab force triad service manual - Las islas galápagos están cerca de la costa - Goal Statement - Conditional formatting rtf template+xml publisher - Routine Message Exercise - Case Study - Ocls indiana wesleyan - Advantages and disadvantages of full factorial design - Observational Studies and Coding - Determination of iron by titration with potassium permanganate - Power point discussion - Reflection (R1) - Browns hotel london chef - Week 6 Case Study - Initial value problem khan - Limitations of the tri component model - Face time vs screen time the technological impact on communication - Case Study 3 & 4 - Non sequitur examples in commercials - How was martin luther king jr a good leader - The absence a gift for the obsessed rar - Diocese of steubenville seminarians - Local safeguarding children's board hampshire - How to use turtle in pycharm - Annotated Bibliography Assignment - Which of the following statements is true about ethical decision making in business? - Shadow health focused exam abdominal pain subjective - DISCUSSION 8 - Woolworths south africa advertising - Biozone crossword puzzle answers - Foundation of Mathematics - Aboriginal dance lesson plan - Delta airlines 10k report 2017 - Http learn genetics utah edu content epigenetics - See if i care readworks - 24 hour bottle shop prahran - Security Data - Assigm 5 IPT - Introduction to sociology seagull tenth edition online - I need help with this assignment from HRM/498T Strategic Human Resource Management and Emerging Issues - Anamarc college reviews - Criminal law - What's stifling the creativity at coolburst - Narrative poems for middle school - A reality check on renewables david mackay - International encyclopedia of marriage and family 2003 - Ads b transponder australia - Week8 discussion - An open letter to his serene majesty leopold ii - Econ test