please answer 11-20 on the instructions for a like! please and thank you!

Complete the Database Totals worksheet using the appropriate database functions using the Sales Database named range use GlobalSalou 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 Wi 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 reated On12/14/2019 Y019 Excel_Ch06_PS2 - Video Game Sales 10 Instructions 12 13 Using the data on the VideoGameSales worksheet create a ProTable on a new worksheet and rename the worksheet Pivot Analysis Structure the Pivot Table on the PivotAnalysis worksheet according to the following Filters Publisher Rows Platform and Year Columns Genre Values Sum of GlobalSales 14 Configure the Pivot Table on the PivotAnalysis worksheet according to the following Create a custom name for Sum of GlobalSales to be Total Global Sales (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 Using the data on the VideoGameSales worksheet insert a PivotChart on a new worksheet Rename the worksheet with the PivotChart and Pivot Table North American Sales By Platform 15 16 17 Structure the PivotChart on the North American Sales ByPlatform worksheet according to the following Filters Genre Axis (Categories) Platform Values Sum of North America Configure the PivotChart on the North American Sales ByPlatform 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 Sales By PlatformPivotChart Using the Pivot Table on the North AmericanSales ByPlatform worksheet create a drill-down of the DS sales and rename the worksheet created North American Saless Using the PivotChart on the Sales ByPlatformPivotChart worksheet modify the Genre filter to only show data for Action Adventure and Fighting genres Save and close Excel_Ch06_PS2_Video GameSales.xlsx Exit Excel Submit the file as directed 18 19 20 (AM 0.01 0.39 0.13 1 Publisher 2 3. Total GlobalSales (in millions) Column Labels 4 Row Labels -Action 5 3DS 6 2013 7 DS $ 0.09 8 2006 9 2007 10 2009 s 0.09 11 2010 12 2011 13 GA 14 2001 15 GBA 16 2006 17 GC 13 2003 19 PC $ 0.07 20 2001 21 2009 S 22 PS 0.07 20 24 2000 25 PS2 26 2009 27 PSE $ 20 0.26 2010 5 20 0.26 2014 30 2015 31 PS4 $ 32 2015 0.12 13 2010 S PSP 0.32 35 2007 10 PSV 17 S 2015 3 $ SNES Adventure Fighting Misc Platform Racing Role Playing Shooter Simulation Sports Strategy Grand Total 0.07 0.07 0.07 0.07 0.26 0.01 0.03 0.02 2.18 0.19 2.79 2.18 2.18 0.01 0.02 0.03 0.02 0.01 0.15 0.19 0.26 0.19 0.26 0.39 0.39 0.39 0.13 0.13 0.62 0.13 1.53 0.62 2.15 0.01 1.53 2.15 0.01 0.08 0.01 0.11 0.41 0.29 0.07 0.11 0.41 0.29 0.12 0.2 0.04 DOR 0.04 0.04 0.041 0.04 0.38 0.26 0.09 0.22 0.00 0.54 0.81 0.0 TotalGlobalSales in millions) Value No value RowPS3 Column Simulation 0.22 0.02 0.02 0.12 0.12 0.22 0.32 0.12 0.12 0.02 0.02 PivotAnalysis Sales Platformivot chart Northamerican Sale Byplatform Type here to search Video Game Sales 1.98 SelectData 1.98 Database Totals i Documentation 0.19 0.39 0.10 0.13 1.53 1.53 0.62 0.62 0.01 0.01 200 0.07 0.41 0.29 0,11 011 11 GB 14 2001 15 - GBA 15 2005 17 GC 18 2003 19 PC 20 2008 21 2009 22 PS 1990 24 2000 25 PS2 26 2005 27 PS) 20 2010 29 2014 30 2015 31 PS4 32 2015 2016 PSP 2003 0.41 0.29 0.04 0.04 $ S 0.08 0.26 0.20 0.04 0.08 0.39 0.39 0.13 0.13 2.15 2.15 0.08 0.01 0.07 0.81 0.11 0.7 0.04 0.04 0.38 0.26 0.08 0.04 0,54 0.22 0.32 0.12 0.12 0.02 0.02 1.98 1.98 0.05 0.05 1.36 LM 0.57 0.52 11.40 $ 0.32 0.04 0.22 0.22 5 PE CE 96 PSV $ 0.12 0.12 13 $ 002 0.02 + 2015 SNES 1991 WH 200) X360 1.98 40 41 42 1.98 0.05 0.05 2000 44 1.16 1.30 45 2005 46 Grand Total 47 0.76 0.52 0.41 0.93 0.16 0.57 0157 0.64 1.6 2.57 2.26 49 1.57 0.01 North American Sales By Platform Our DOS Dubro bon G N How to moth 40 50 PS PS4 10 PM . 30 10 11 ES 17 1 12 She 34 23 LE 26 21 38 North American Platform te OS HMS 4 I TI Any AC SI TY al Hube DIV 1 Name 2 Sherlock Holmes Chments Ace Attorney investigations 2 Metalcht Beyte Driven reak: The Company 5 Total 7 D Platform Year Gewe North America e tapan Other Global 14 Adventure Too meni 0.03 $0.043 5001 DS 1 Adventure Capcom 5 50.05 $ 0.26 Ds 2009 A $0:09 S 0.00 2010 Action Deep Silver $ 00S0.165 . $ 0.00 10 11 13 13 14 19 16 17 11 19 NO 21 23 24 25 26 27 20 29 30 11 335 15 16 3 30 Distanalysis Cachachant Northanam wideo Selector DoToDecor A5 Field sh 2 2 5 stel . BARN CH TO MAN 11 Min 12 13 14 15 16 17 10 10 20 21 22 31 24 25 20 27 20 OE TE L 11 35 10 37 33 VideoGameSales Select Database tals Documentation G he Description Moi. Description WorkbookName Toss Excel Ch06 PS2 Video GameSales.xlsx Last Velocipants 5 Create Date By Wom 5/12/2022 samantha Vee 7 Mod Dan by whom 8 9 10 11 12 13 14 Sample data of tobal video game sales Filtered data for focused analyst ploring data with database functions Pivottable analysis to explore Global Sales Pivot Table analysis to explore North American Sales Data about North American sales for the Nintendo DS To explore sales by platform vill 16 17 1 19 Create Date Shame CANAL 20 5/12/2022 Videogames Samantha Vee 21 7/12/2022 Select Data Samantha Vee 22 5/12/2022 Database Total Samantha Vee 21 5/12/2022 ProtAnalysis Samantha 24 5/12/2022 North Americansatestlyplatform Samantha Vee 25 5/12/2022 North American Saless Samantha Vee 26 5/12/2022. SalesbyplatformPivotChart Samantha Vee 22 28 29 30 31 32 3a 14 35 16 37 38 30 59 40 41 PrvotAnalysis Salesylatform ProChart NorthAmerican sledyplatform Video GameSales SelectData Database Total Documentation Complete the Database Totals worksheet using the appropriate database functions using the Sales Database named range use GlobalSalou 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 Wi 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 reated On12/14/2019 Y019 Excel_Ch06_PS2 - Video Game Sales 10 Instructions 12 13 Using the data on the VideoGameSales worksheet create a ProTable on a new worksheet and rename the worksheet Pivot Analysis Structure the Pivot Table on the PivotAnalysis worksheet according to the following Filters Publisher Rows Platform and Year Columns Genre Values Sum of GlobalSales 14 Configure the Pivot Table on the PivotAnalysis worksheet according to the following Create a custom name for Sum of GlobalSales to be Total Global Sales (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 Using the data on the VideoGameSales worksheet insert a PivotChart on a new worksheet Rename the worksheet with the PivotChart and Pivot Table North American Sales By Platform 15 16 17 Structure the PivotChart on the North American Sales ByPlatform worksheet according to the following Filters Genre Axis (Categories) Platform Values Sum of North America Configure the PivotChart on the North American Sales ByPlatform 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 Sales By PlatformPivotChart Using the Pivot Table on the North AmericanSales ByPlatform worksheet create a drill-down of the DS sales and rename the worksheet created North American Saless Using the PivotChart on the Sales ByPlatformPivotChart worksheet modify the Genre filter to only show data for Action Adventure and Fighting genres Save and close Excel_Ch06_PS2_Video GameSales.xlsx Exit Excel Submit the file as directed 18 19 20 (AM 0.01 0.39 0.13 1 Publisher 2 3. Total GlobalSales (in millions) Column Labels 4 Row Labels -Action 5 3DS 6 2013 7 DS $ 0.09 8 2006 9 2007 10 2009 s 0.09 11 2010 12 2011 13 GA 14 2001 15 GBA 16 2006 17 GC 13 2003 19 PC $ 0.07 20 2001 21 2009 S 22 PS 0.07 20 24 2000 25 PS2 26 2009 27 PSE $ 20 0.26 2010 5 20 0.26 2014 30 2015 31 PS4 $ 32 2015 0.12 13 2010 S PSP 0.32 35 2007 10 PSV 17 S 2015 3 $ SNES Adventure Fighting Misc Platform Racing Role Playing Shooter Simulation Sports Strategy Grand Total 0.07 0.07 0.07 0.07 0.26 0.01 0.03 0.02 2.18 0.19 2.79 2.18 2.18 0.01 0.02 0.03 0.02 0.01 0.15 0.19 0.26 0.19 0.26 0.39 0.39 0.39 0.13 0.13 0.62 0.13 1.53 0.62 2.15 0.01 1.53 2.15 0.01 0.08 0.01 0.11 0.41 0.29 0.07 0.11 0.41 0.29 0.12 0.2 0.04 DOR 0.04 0.04 0.041 0.04 0.38 0.26 0.09 0.22 0.00 0.54 0.81 0.0 TotalGlobalSales in millions) Value No value RowPS3 Column Simulation 0.22 0.02 0.02 0.12 0.12 0.22 0.32 0.12 0.12 0.02 0.02 PivotAnalysis Sales Platformivot chart Northamerican Sale Byplatform Type here to search Video Game Sales 1.98 SelectData 1.98 Database Totals i Documentation 0.19 0.39 0.10 0.13 1.53 1.53 0.62 0.62 0.01 0.01 200 0.07 0.41 0.29 0,11 011 11 GB 14 2001 15 - GBA 15 2005 17 GC 18 2003 19 PC 20 2008 21 2009 22 PS 1990 24 2000 25 PS2 26 2005 27 PS) 20 2010 29 2014 30 2015 31 PS4 32 2015 2016 PSP 2003 0.41 0.29 0.04 0.04 $ S 0.08 0.26 0.20 0.04 0.08 0.39 0.39 0.13 0.13 2.15 2.15 0.08 0.01 0.07 0.81 0.11 0.7 0.04 0.04 0.38 0.26 0.08 0.04 0,54 0.22 0.32 0.12 0.12 0.02 0.02 1.98 1.98 0.05 0.05 1.36 LM 0.57 0.52 11.40 $ 0.32 0.04 0.22 0.22 5 PE CE 96 PSV $ 0.12 0.12 13 $ 002 0.02 + 2015 SNES 1991 WH 200) X360 1.98 40 41 42 1.98 0.05 0.05 2000 44 1.16 1.30 45 2005 46 Grand Total 47 0.76 0.52 0.41 0.93 0.16 0.57 0157 0.64 1.6 2.57 2.26 49 1.57 0.01 North American Sales By Platform Our DOS Dubro bon G N How to moth 40 50 PS PS4 10 PM . 30 10 11 ES 17 1 12 She 34 23 LE 26 21 38 North American Platform te OS HMS 4 I TI Any AC SI TY al Hube DIV 1 Name 2 Sherlock Holmes Chments Ace Attorney investigations 2 Metalcht Beyte Driven reak: The Company 5 Total 7 D Platform Year Gewe North America e tapan Other Global 14 Adventure Too meni 0.03 $0.043 5001 DS 1 Adventure Capcom 5 50.05 $ 0.26 Ds 2009 A $0:09 S 0.00 2010 Action Deep Silver $ 00S0.165 . $ 0.00 10 11 13 13 14 19 16 17 11 19 NO 21 23 24 25 26 27 20 29 30 11 335 15 16 3 30 Distanalysis Cachachant Northanam wideo Selector DoToDecor A5 Field sh 2 2 5 stel . BARN CH TO MAN 11 Min 12 13 14 15 16 17 10 10 20 21 22 31 24 25 20 27 20 OE TE L 11 35 10 37 33 VideoGameSales Select Database tals Documentation G he Description Moi. Description WorkbookName Toss Excel Ch06 PS2 Video GameSales.xlsx Last Velocipants 5 Create Date By Wom 5/12/2022 samantha Vee 7 Mod Dan by whom 8 9 10 11 12 13 14 Sample data of tobal video game sales Filtered data for focused analyst ploring data with database functions Pivottable analysis to explore Global Sales Pivot Table analysis to explore North American Sales Data about North American sales for the Nintendo DS To explore sales by platform vill 16 17 1 19 Create Date Shame CANAL 20 5/12/2022 Videogames Samantha Vee 21 7/12/2022 Select Data Samantha Vee 22 5/12/2022 Database Total Samantha Vee 21 5/12/2022 ProtAnalysis Samantha 24 5/12/2022 North Americansatestlyplatform Samantha Vee 25 5/12/2022 North American Saless Samantha Vee 26 5/12/2022. SalesbyplatformPivotChart Samantha Vee 22 28 29 30 31 32 3a 14 35 16 37 38 30 59 40 41 PrvotAnalysis Salesylatform ProChart NorthAmerican sledyplatform Video GameSales SelectData Database Total Documentation