N 3 Start Excel. Download and open the file named Excel_Ch06_PS2_Video Gamo Salos.xlsx. Grader has automatically added your last name to the beginning of the filename. The data on the VideoGameSales worksheet includes sales (in millions) for several video games on various platforms and from various genres. On the Video GameSales worksheet. insert a table with headers using the data. Apply the Light Blue, Table Style Medium 27 to the table and with the table selected, including the headers, create a Salas Database named range to be used in dalabase functions later. Add a Total Row to the table to have the sales values in the North America, Europe, Japan. Other, and GlobalSales columns summed. Slicers are an easy way to explore data in a table. Insert slicers for Platform, Year, and Genre. on Move the Platform slicer so that its top-loft comer 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. 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. 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 roads Release Year. Apply the White, Slicer Style Other 2 style to the slicer. 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. 10 Clear the filters applied to the Video Game Sales data. Copy the headings and paste them onto the Database Totals 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. 11 Complete the Database Totals worksheet using the appropriate database functions using the Sales Database named rango, use GlobalSales as the field in your calculations, and only calculato games that meet the following criteria: In row 2, specify the criteria for games on the Wil 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. 0.32 0.19 Name leopardy 2nd Edition TrackMania Turbo Touch Detective: Nameko Shigeru NHL 16 Ride Dragon Bakura DS Sherlock Holmes Crimes & Purishments Ace Attorney investigations 2 0 Metal Fight Beyblade 11 Farmtopia 12 Pokemon Ranger 13 BeatMania X 16: Empress Premium Best 24 Mobile Suit Gundam Seed: Rengon VEZAET Portable 25 MiniCopter Adventure Hight 16 Super Speed Machines 17 Knockout Kings 2001 18 Cock Zero: Shuu no ichibyou - Extime 19 Walt Disney Pictures Presents The Wild 20 Marker Man Adventures 21 Tactics Layer Rutina Gund Senki 22 From TV Animation One Piece Yume notury Kairokidan Tanjout 23 Pa Man Player's Choice hundle 24 Burnout Paradise 25 Prison Break The Conspiracy 26 Mario Golf Toadstool Tour 27 Poker for Dummies 20 Resident Evil 29 Far Cry instincts 30 Grand Theft Auto Mission Pack London 1969 31 Simcity 32 33 34 35 36 37 C D Platform Year Genre Publisher PS 2000 Misc Hasbro Interactive PS4 2016 Action Ubiso 305 2013 Adventure Succes PS3 2015 Sports Electronic Arts PSA 2015 Racing Milestone S.r.l. OS 2007 Mise Electronic Arts PS3 2014 Adventure Focus Home interactive DS 2011 Adventure Capcom DS 2009 Action Hudson Soft DS 2010 Simulation SOS Games OS 2006 Role-Playing Nintendo PS2 2009 Simulation Konami Digital Entertainment PSP 2007 Shooter Namco Banda Games Wii 2007 Simulation SOS Games OS 2009 Racing Midas interactive Entertainment PS 2000 Fighting Electronics PSV 2015 Action Idea Factory 2006 Platform Disney Interactive Studios DS 2009 Platform Mesco Entertainment DS 2009 Strategy Publisher GS 2001 Role Playing Banpresto GC 2003 M Namco Badal Games X360 2001 Racing Blectronic Arts PS 2010 Action Deep Silver GC 2003 Sports Nintendo PC 2008 M Dectronic Arts PC 2009 Action Capcom X 2005 Shooter Ubiso PS 1998 Adventure Take-Two interactive SNES 1991 mutation Nintendo HI North America Europe loan Other Global Sales $ 0.16 $0.11 5 50.025 0.29 $ 0.03 50.24 S 50.055 $ - 5 $0.07 5. $ 0.02 $ $ 0.03 $ $0.015 0.04 $ 0.03 $0.13 $0.0 500 0.22 $ $ S0.01$ $ 0.01 S 0.03 $0.045 50015 DOR 5 S- $0.26 $ $ 0.26 $ $ $0.00 $ $ 0.09 5 0.18 S- $ $0.015 $ 1.29 $0.04 50.73 50 12 $ 2 12 $ $ $0.04 $ 0.04 5 $- $0.125- 5 0.12 $ 0.04 5 $ $ 5 0.05 5 0.02 - 5. 5 0.02 $ 0.23 $0.155 $0.00 $ 0.41 S $ S0.025 5 0.02 $ 0.09 $ 0.03 S 5 0.13 5 0.025 - S. $ $ 0.03 5 S- $0.01 - 5 0.01 s $ $0395 5 0.39 $ 0.48 50.125 $ 0.025 0.62 S 0.63 $0.58 0.01 0.15S 136 S 0.0550165 50.055 026 5 1.09 50.15 S025 $0.045 1.53 5 $ 0.015 5 5 5 0.01 0.04 $0.015 0.07 5 0.32 0.245 $0.OZS 0.57 5 0.06 $0.00 $ S0015 0.31 5 093 50.27 0.75 50.00 5 1.90 GA 001 5 Field Sum B Avereze Count 11 min N 3 Start Excel. Download and open the file named Excel_Ch06_PS2_Video Gamo Salos.xlsx. Grader has automatically added your last name to the beginning of the filename. The data on the VideoGameSales worksheet includes sales (in millions) for several video games on various platforms and from various genres. On the Video GameSales worksheet. insert a table with headers using the data. Apply the Light Blue, Table Style Medium 27 to the table and with the table selected, including the headers, create a Salas Database named range to be used in dalabase functions later. Add a Total Row to the table to have the sales values in the North America, Europe, Japan. Other, and GlobalSales columns summed. Slicers are an easy way to explore data in a table. Insert slicers for Platform, Year, and Genre. on Move the Platform slicer so that its top-loft comer 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. 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. 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 roads Release Year. Apply the White, Slicer Style Other 2 style to the slicer. 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. 10 Clear the filters applied to the Video Game Sales data. Copy the headings and paste them onto the Database Totals 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. 11 Complete the Database Totals worksheet using the appropriate database functions using the Sales Database named rango, use GlobalSales as the field in your calculations, and only calculato games that meet the following criteria: In row 2, specify the criteria for games on the Wil 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. 0.32 0.19 Name leopardy 2nd Edition TrackMania Turbo Touch Detective: Nameko Shigeru NHL 16 Ride Dragon Bakura DS Sherlock Holmes Crimes & Purishments Ace Attorney investigations 2 0 Metal Fight Beyblade 11 Farmtopia 12 Pokemon Ranger 13 BeatMania X 16: Empress Premium Best 24 Mobile Suit Gundam Seed: Rengon VEZAET Portable 25 MiniCopter Adventure Hight 16 Super Speed Machines 17 Knockout Kings 2001 18 Cock Zero: Shuu no ichibyou - Extime 19 Walt Disney Pictures Presents The Wild 20 Marker Man Adventures 21 Tactics Layer Rutina Gund Senki 22 From TV Animation One Piece Yume notury Kairokidan Tanjout 23 Pa Man Player's Choice hundle 24 Burnout Paradise 25 Prison Break The Conspiracy 26 Mario Golf Toadstool Tour 27 Poker for Dummies 20 Resident Evil 29 Far Cry instincts 30 Grand Theft Auto Mission Pack London 1969 31 Simcity 32 33 34 35 36 37 C D Platform Year Genre Publisher PS 2000 Misc Hasbro Interactive PS4 2016 Action Ubiso 305 2013 Adventure Succes PS3 2015 Sports Electronic Arts PSA 2015 Racing Milestone S.r.l. OS 2007 Mise Electronic Arts PS3 2014 Adventure Focus Home interactive DS 2011 Adventure Capcom DS 2009 Action Hudson Soft DS 2010 Simulation SOS Games OS 2006 Role-Playing Nintendo PS2 2009 Simulation Konami Digital Entertainment PSP 2007 Shooter Namco Banda Games Wii 2007 Simulation SOS Games OS 2009 Racing Midas interactive Entertainment PS 2000 Fighting Electronics PSV 2015 Action Idea Factory 2006 Platform Disney Interactive Studios DS 2009 Platform Mesco Entertainment DS 2009 Strategy Publisher GS 2001 Role Playing Banpresto GC 2003 M Namco Badal Games X360 2001 Racing Blectronic Arts PS 2010 Action Deep Silver GC 2003 Sports Nintendo PC 2008 M Dectronic Arts PC 2009 Action Capcom X 2005 Shooter Ubiso PS 1998 Adventure Take-Two interactive SNES 1991 mutation Nintendo HI North America Europe loan Other Global Sales $ 0.16 $0.11 5 50.025 0.29 $ 0.03 50.24 S 50.055 $ - 5 $0.07 5. $ 0.02 $ $ 0.03 $ $0.015 0.04 $ 0.03 $0.13 $0.0 500 0.22 $ $ S0.01$ $ 0.01 S 0.03 $0.045 50015 DOR 5 S- $0.26 $ $ 0.26 $ $ $0.00 $ $ 0.09 5 0.18 S- $ $0.015 $ 1.29 $0.04 50.73 50 12 $ 2 12 $ $ $0.04 $ 0.04 5 $- $0.125- 5 0.12 $ 0.04 5 $ $ 5 0.05 5 0.02 - 5. 5 0.02 $ 0.23 $0.155 $0.00 $ 0.41 S $ S0.025 5 0.02 $ 0.09 $ 0.03 S 5 0.13 5 0.025 - S. $ $ 0.03 5 S- $0.01 - 5 0.01 s $ $0395 5 0.39 $ 0.48 50.125 $ 0.025 0.62 S 0.63 $0.58 0.01 0.15S 136 S 0.0550165 50.055 026 5 1.09 50.15 S025 $0.045 1.53 5 $ 0.015 5 5 5 0.01 0.04 $0.015 0.07 5 0.32 0.245 $0.OZS 0.57 5 0.06 $0.00 $ S0015 0.31 5 093 50.27 0.75 50.00 5 1.90 GA 001 5 Field Sum B Avereze Count 11 min