Instructions

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

I need help with these 3 Sales database named rage is entire table A1:J32

Calibri z Wrap Text General * Cut E Copy Format Painter Paste BIU- Merge & Center $ %) SSA/kim9D1/... YODIwLzRgW... ykhd6fSjuxK... Conditional Format as YZbL+O+KKR... Normal Bad Formatting Table Styles Insert Delete Format AutoSum- Fill Sort & Find 81 Clear Filter - Select - Editing Clipboard Font Alignment Number Cells M14 fo A K L M N O P Q 1 Name 2 Sherlock Holmes: Crimes & Punishments 3 Ace Attorney Investigations 2 4 Metal Fight Beyblade 5 Prison Break: The Conspiracy 6 Total 7 8 Data from "Video Game Sales" compiled by GregorySmith, https://www.kaggle.com/gregorut/videogamesales 9 B C D E Platform Year Genre Publisher PS3 2014 Adventure Focus Home Interactive DS 2011 Adventure Capcom DS 2009 Action Hudson Soft PS3 2010 Action Deep Silver G H 1 J North America Europe Japan Other GlobalSales $ 0.03 $ 0.04 $ - $ 0.01 $ 0.08 $ $ - $0.26 $ $ 0.26 $ $ $ 0.09 $ - $ 0.09 $ 0.05 $ 0.16 $ - $ 0.05 $ 0.26 $ 0.08 $ 0.20 $0.35 $ 0.06 $ 0.69 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Video Game Sales SelectData Database Totals Documentation + Ready @ 1 + 100% AutoSum- Calibri AA Wrap Text General * Cut e Copy Format Painter Paste BIU > Merge & Center $ - % 48.98 SSA/kim9D1/... YODIwLzRgW... ykhd6fsjuxK... Conditional Format as YZbL+O+KR... Normal Bad Formatting Table Styles Insert Delete Format Clear Sort & Find & Filter - Select- Editing Clipboard Font Alignment Number Cells P11 V K L M N O P Q R s V w X Y Z AA A A B D E G H 1 J 1 Name Platform Year Genre Publisher North America Europe Japan Other GlobalSales 2 3 4 5 Field 6 7 Sum 8 Average 9 Count 10 Max 11 Min 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 VideoGameSales SelectData Database Totals Documentation + Ready HHH + 100% Calibri - 11 - ' Be Wrap Text General * Cut e Copy Format Painter Paste U- -A- Merge & Center $ - % +TanxUQS/6... 3F0uQ9rcnsB... 6dvNQh3KBs... Conditional Format as 9spNtgCiAZ6... bUUy/QIPkr... CIDO6Stvvoy... Formatting Table Styles Insert Delete Format AutoSum - As Z Fill - Sort & Find & Clear Filter Select Editing Clipboard Font Alignment Number Cells A1 X fa Name L M N 0 P Genre 0.11 GB Action Adventure PC Fighting Misc PS3 Platform Racing PSV Role-Playing Shooter X360 Simulation Sports Strategy - 2000 C D E G H 1 K Year - Genre Publisher - North America Europe Japan Other - GlobalSales Platform 2000 Misc Hasbro Interactive $ 0.16 $ S $ 0.02 $ 0.29 3DS DS 2016 Action Ubisoft $ 0.03 $ 0.24 $ $ 0.05 $ 0.32 2013 Adventure Success $ $ $ 0.07 $ - $ 0.07 GBA GC 2015 Sports Electronic Arts S $ 0.03 $ - $ 0.01 $ 0.04 PS PS2 2015 Racing Milestone S.r.l. $ 0.03 $ 0.13 $ 0.03 $ 0.03 $ 0.22 2007 Misc Electronic Arts $ $ $ 0.01 $ $ 0.01 PS4 PSP 2014 Adventure Focus Home Interactive $ 0.03 $ 0.04 $ - $ 0.01 $ 0.08 SNES Wii 2011 Adventure Capcom $ $ $ 0.26 $ - $ 0.26 XB 2009 Action Hudson Soft $ $ $ 0.09 $ - $ 0.09 2010 Simulation 505 Games $ 0.18 $ $ - $ 0.01 $ 0.19 2006 Role-Playing Nintendo $ 1.29 $ 0.04 $ 0.73 $ 0.12 $ 2.18 2009 Simulation Konami Digital Entertainment $ $ $ 0.04 $ $ 0.04 Release Year 2007 Shooter Namco Bandai Games $ $ $ 0.12 $ $ 0.12 2007 Simulation 505 Games $ 0.04 $ $ $ $ 0.05 1991 1998 2009 Racing Midas Interactive Entertainmer $ 0.02 S $ - $ $ 0.02 2001 2000 Fighting Electronic Arts $ 0.23 $ 0.15 $ - $ 0.03 $ 0.41 2006 2007 2015 Action Idea Factory $ $ $ 0.02 $ S 0.02 2006 Platform Disney Interactive Studios $ 0.09 $ 0.03 $ - $ $ 0.13 2009 2010 2009 Platform Majesco Entertainment $ 0.02 $ $ $ $ 0.03 2013 2014 2009 Strategy D3Publisher $ $ $ 0.01 S $ 0.01 2001 Role-Playing Banpresto $ $ $ 0.39 $ $ 0.39 2016 2003 Misc Namco Bandai Games $ 0.48 $ 0.12 $ - $ 0.02 $ 0.62 2008 Racing Electronic Arts $ 0.63 $ 0.58 $ 0.01 $ 0.15 $ 1.36 2010 Action Deep Silver $ 0.05 $ 0.16 $ - $ 0.05 S 0.26 2003 Sports Nintendo $ 1.09 $ 0.15 $ 0.25 $ 0.04 $ 1.53 2008 Misc Electronic Arts $ $ 0.01 $ $ - $ 0.01 2009 Action Capcom $ 0.01 $ 0.04 $ - $ 0.01 $ 0.07 2005 Shooter Ubisoft $ 0.32 $ 0.24 $ $ 0.02 $ 0.57 1998 Adventure Take-Two Interactive $ 0.06 $ 0.04 $ - $ 0.01 $ 0.11 1991 Simulation Nintendo $ 0.93 $ 0.27 $ 0.75 $ 0.04 1.98 $ 5.69 $ 2.38 $ 2.78 $ 0.62 $ 11.48 - A B 1 Name Platform 2 Jeopardy! 2nd Edition PS 3 TrackMania Turbo PS4 4 Touch Detective: Nameko Shigeru 3DS 5 NHL 16 PS3 6 Ride PS4 7 Dragon Zakura DS DS 8 Sherlock Holmes: Crimes & Punishments PS3 9 Ace Attorney Investigations 2 DS 10 Metal Fight Beyblade DS 11 Farmtopia DS 12 Pokemon Ranger DS 13 BeatMania IIDX 16: Empress + Premium Best PS2 14 Mobile Suit Gundam Seed: Rengou vs. Z.A.F.T. Portable PSP 15 MiniCopter: Adventure Flight Wii 16 Super Speed Machines DS 17 Knockout Kings 2001 PS 18 Clock Zero: Shuuen no Ichibyou - ExTime PSV 19 Walt Disney Pictures Presents: The Wild 20 Marker Man Adventures DS 21 Tactics Layer: Ritina Guard Senki DS 22 From TV Animation One Piece: Yume no Lufy Kaizokudan Tanji GB 23 Pac-Man Player's Choice Bundle GC 24 Burnout Paradise X360 25 Prison Break: The Conspiracy PS3 26 Mario Golf: Toadstool Tour GC 27 Poker for Dummies PC 28 Resident Evil 5 PC 29 Far Cry Instincts XB 30 Grand Theft Auto: Mission Pack #1, London 1969 PS 31 SimCity SNES 32 Total 33 2003 2005 2008 GBA - 2011 2015 - - uvusi - ses se VideoGameSales SelectData Database Totals Documentation Ready Count: 10 100% Calibri z Wrap Text General * Cut E Copy Format Painter Paste BIU- Merge & Center $ %) SSA/kim9D1/... YODIwLzRgW... ykhd6fSjuxK... Conditional Format as YZbL+O+KKR... Normal Bad Formatting Table Styles Insert Delete Format AutoSum- Fill Sort & Find 81 Clear Filter - Select - Editing Clipboard Font Alignment Number Cells M14 fo A K L M N O P Q 1 Name 2 Sherlock Holmes: Crimes & Punishments 3 Ace Attorney Investigations 2 4 Metal Fight Beyblade 5 Prison Break: The Conspiracy 6 Total 7 8 Data from "Video Game Sales" compiled by GregorySmith, https://www.kaggle.com/gregorut/videogamesales 9 B C D E Platform Year Genre Publisher PS3 2014 Adventure Focus Home Interactive DS 2011 Adventure Capcom DS 2009 Action Hudson Soft PS3 2010 Action Deep Silver G H 1 J North America Europe Japan Other GlobalSales $ 0.03 $ 0.04 $ - $ 0.01 $ 0.08 $ $ - $0.26 $ $ 0.26 $ $ $ 0.09 $ - $ 0.09 $ 0.05 $ 0.16 $ - $ 0.05 $ 0.26 $ 0.08 $ 0.20 $0.35 $ 0.06 $ 0.69 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Video Game Sales SelectData Database Totals Documentation + Ready @ 1 + 100% AutoSum- Calibri AA Wrap Text General * Cut e Copy Format Painter Paste BIU > Merge & Center $ - % 48.98 SSA/kim9D1/... YODIwLzRgW... ykhd6fsjuxK... Conditional Format as YZbL+O+KR... Normal Bad Formatting Table Styles Insert Delete Format Clear Sort & Find & Filter - Select- Editing Clipboard Font Alignment Number Cells P11 V K L M N O P Q R s V w X Y Z AA A A B D E G H 1 J 1 Name Platform Year Genre Publisher North America Europe Japan Other GlobalSales 2 3 4 5 Field 6 7 Sum 8 Average 9 Count 10 Max 11 Min 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 VideoGameSales SelectData Database Totals Documentation + Ready HHH + 100% Calibri - 11 - ' Be Wrap Text General * Cut e Copy Format Painter Paste U- -A- Merge & Center $ - % +TanxUQS/6... 3F0uQ9rcnsB... 6dvNQh3KBs... Conditional Format as 9spNtgCiAZ6... bUUy/QIPkr... CIDO6Stvvoy... Formatting Table Styles Insert Delete Format AutoSum - As Z Fill - Sort & Find & Clear Filter Select Editing Clipboard Font Alignment Number Cells A1 X fa Name L M N 0 P Genre 0.11 GB Action Adventure PC Fighting Misc PS3 Platform Racing PSV Role-Playing Shooter X360 Simulation Sports Strategy - 2000 C D E G H 1 K Year - Genre Publisher - North America Europe Japan Other - GlobalSales Platform 2000 Misc Hasbro Interactive $ 0.16 $ S $ 0.02 $ 0.29 3DS DS 2016 Action Ubisoft $ 0.03 $ 0.24 $ $ 0.05 $ 0.32 2013 Adventure Success $ $ $ 0.07 $ - $ 0.07 GBA GC 2015 Sports Electronic Arts S $ 0.03 $ - $ 0.01 $ 0.04 PS PS2 2015 Racing Milestone S.r.l. $ 0.03 $ 0.13 $ 0.03 $ 0.03 $ 0.22 2007 Misc Electronic Arts $ $ $ 0.01 $ $ 0.01 PS4 PSP 2014 Adventure Focus Home Interactive $ 0.03 $ 0.04 $ - $ 0.01 $ 0.08 SNES Wii 2011 Adventure Capcom $ $ $ 0.26 $ - $ 0.26 XB 2009 Action Hudson Soft $ $ $ 0.09 $ - $ 0.09 2010 Simulation 505 Games $ 0.18 $ $ - $ 0.01 $ 0.19 2006 Role-Playing Nintendo $ 1.29 $ 0.04 $ 0.73 $ 0.12 $ 2.18 2009 Simulation Konami Digital Entertainment $ $ $ 0.04 $ $ 0.04 Release Year 2007 Shooter Namco Bandai Games $ $ $ 0.12 $ $ 0.12 2007 Simulation 505 Games $ 0.04 $ $ $ $ 0.05 1991 1998 2009 Racing Midas Interactive Entertainmer $ 0.02 S $ - $ $ 0.02 2001 2000 Fighting Electronic Arts $ 0.23 $ 0.15 $ - $ 0.03 $ 0.41 2006 2007 2015 Action Idea Factory $ $ $ 0.02 $ S 0.02 2006 Platform Disney Interactive Studios $ 0.09 $ 0.03 $ - $ $ 0.13 2009 2010 2009 Platform Majesco Entertainment $ 0.02 $ $ $ $ 0.03 2013 2014 2009 Strategy D3Publisher $ $ $ 0.01 S $ 0.01 2001 Role-Playing Banpresto $ $ $ 0.39 $ $ 0.39 2016 2003 Misc Namco Bandai Games $ 0.48 $ 0.12 $ - $ 0.02 $ 0.62 2008 Racing Electronic Arts $ 0.63 $ 0.58 $ 0.01 $ 0.15 $ 1.36 2010 Action Deep Silver $ 0.05 $ 0.16 $ - $ 0.05 S 0.26 2003 Sports Nintendo $ 1.09 $ 0.15 $ 0.25 $ 0.04 $ 1.53 2008 Misc Electronic Arts $ $ 0.01 $ $ - $ 0.01 2009 Action Capcom $ 0.01 $ 0.04 $ - $ 0.01 $ 0.07 2005 Shooter Ubisoft $ 0.32 $ 0.24 $ $ 0.02 $ 0.57 1998 Adventure Take-Two Interactive $ 0.06 $ 0.04 $ - $ 0.01 $ 0.11 1991 Simulation Nintendo $ 0.93 $ 0.27 $ 0.75 $ 0.04 1.98 $ 5.69 $ 2.38 $ 2.78 $ 0.62 $ 11.48 - A B 1 Name Platform 2 Jeopardy! 2nd Edition PS 3 TrackMania Turbo PS4 4 Touch Detective: Nameko Shigeru 3DS 5 NHL 16 PS3 6 Ride PS4 7 Dragon Zakura DS DS 8 Sherlock Holmes: Crimes & Punishments PS3 9 Ace Attorney Investigations 2 DS 10 Metal Fight Beyblade DS 11 Farmtopia DS 12 Pokemon Ranger DS 13 BeatMania IIDX 16: Empress + Premium Best PS2 14 Mobile Suit Gundam Seed: Rengou vs. Z.A.F.T. Portable PSP 15 MiniCopter: Adventure Flight Wii 16 Super Speed Machines DS 17 Knockout Kings 2001 PS 18 Clock Zero: Shuuen no Ichibyou - ExTime PSV 19 Walt Disney Pictures Presents: The Wild 20 Marker Man Adventures DS 21 Tactics Layer: Ritina Guard Senki DS 22 From TV Animation One Piece: Yume no Lufy Kaizokudan Tanji GB 23 Pac-Man Player's Choice Bundle GC 24 Burnout Paradise X360 25 Prison Break: The Conspiracy PS3 26 Mario Golf: Toadstool Tour GC 27 Poker for Dummies PC 28 Resident Evil 5 PC 29 Far Cry Instincts XB 30 Grand Theft Auto: Mission Pack #1, London 1969 PS 31 SimCity SNES 32 Total 33 2003 2005 2008 GBA - 2011 2015 - - uvusi - ses se VideoGameSales SelectData Database Totals Documentation Ready Count: 10 100%