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.

File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do * Cut Calibri 11 A ab Wrap Text Accounting NH AutoSum Fill AT HA e Copy Paste A B I U - 1 = = Insert Delete Format Merge & Center 9 $ % 2000 Format Painter Conditional Format as Cell Formatting Table Styles Styles Clear Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing K27 X fic SsSs L M N 0 Genre > GB Action Adventure - PC Fighting Misc PS3 Platform Racing PSV Role-Playing Shooter X360 Simulation Sports - Strategy B C D E F G H K 1 Platform - Year - Genre Publisher North America - Europe - Japan Other GlobalSales - Platform 2 PS 2000 Misc Hasbro Interactive $ 0.16 $ 0.11 $ $ 0.02 $ 0.29 3 PS4 2016 Action Ubisoft $ 0.03 $ 0.24 $ $ 0.05 $ 0.32 3DS DS 4 3DS 2013 Adventure Success $ $ $ 0.07 $ $ 0.07 GBA GC 5 PS3 2015 Sports Electronic Arts $ $ 0.03 $ $ 0.01 $ 0.04 2015 Racing 6 PS4 $ Milestone S.r.l. 0.03 PS2 $ PS 0.13 $ 0.03 $ 0.03 $ 0.22 7 DS 2007 Misc Electronic Arts $ $ $ 0.01 $ $ 0.01 PS4 PSP 8 PS3 2014 Adventure Focus Home Interactive $ 0.03 $ 0.04 $ $ 0.01 $ 0.08 Wii 9 DS 2011 Adventure Capcom $ $ SNES $ $ 0.26 $ 0.26 10 DS 2009 Action Hudson Soft $ $ $ 0.09 $ S 0.09 XB 11 DS 2010 Simulation 505 Games $ 0.18 $ $ $ 0.01 $ 0.19 12 DS 2006 Role-Playing Nintendo $ 1.29 $ 0.04 $ 0.73 $ 0.12 $ 2.18 13 PS2 2009 Simulation Konami Digital Entertainment $ $ $ 0.04 $ S 0.04 Release Year 14 PSP 2007 Shooter Namco Bandai Games $ $ $ 0.12 $ S 0.12 15 Wii 2007 Simulation 505 Games $ 0.04 $ $ $ S 0.05 1998 16 DS 2009 Racing Midas Interactive Entertainment $ 0.02 $ $ $ S 0.02 2001 2003 17 PS 2000 Fighting Electronic Arts S 0.23 $ 0.15 $ $ 0.03 $ 0.41 18 PSV 2015 Action Idea Factory S $ $ 0.02 2006 $ 0.02 2007 19 GBA 2006 Platform Disney Interactive Studios S 0.09 $ 0.03 $ $ 0.13 2009 2010 20 DS 2009 Platform Majesco Entertainment S 0.02 $ $ $ 0.03 2013 21 DS 2009 Strategy D3Publisher $ $ 2014 $ 0.01 $ 0.01 22 GB 2001 Role-Playing Banpresto S $ $ 0.39 $ 0.39 2016 23 GC 2003 Misc Namco Bandai Games $ 0.48 $ 0.12 $ - $ 0.02 $ 0.62 24 X360 2008 Racing Electronic Arts S 0.63 $ 0.58 $ 0.01 $ 0.15 $ 1.36 25 PS3 2010 Action Deep Silver $ 0.05 $ 0.16 $ $ 0.05 $ 0.26 26 GC 2003 Sports Nintendo $ 1.09 $ 0.15 $ 0.25 $ 0.04 $ 1.53 27 PC 2008 Misc Electronic Arts $ $ 0.01 $ $ 0.01 SsSs 28 PC 2009 Action Capcom $ 0.01 $ 0.04 $ $ 0.01 $ 0.07 29 XB 2005 Shooter Ubisoft $ 0.32 $ 0.24 $ $ 0.02 $ 0.57 VideoGameSales SelectData Database Totals Documentation + 1991 2000 - 2005 2008 2011 2015 wwwwwwwwwwwww - INSEIL romuias Dala View Tell me what you Calibri 11 ab Wrap Text General * Cut E Copy Format Painter 1 Inser Paste B I U A $ % 9 Merge & Center 6.0 .00 .00 .0 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Y24 X fic B G J K 1 M N A 1 Platform 2 F F Publisher North America Europe H Other Year Genre Japan GlobalSales im + WONDER 4 5 Field 6 7 Sum 8 Average Count 10 Max 11 Min 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 VideoGameSales SelectData Database Totals Documentation +