I need help on #9 on filling out the database totals worksheet. Complete the Database Totals worksheet using the appropriate

database functions using the CarDatahase named range, use

the M5RP as the field in your calculations, and only calculate

vehicles that meet all the followng criteria:

Vehicle year is newer than 2015

Transmission type is Automatic

Highway MPG is greater than 25

9 20 Complete the Database Totals worksheet using the appropriate database functions using the CarDatabase named range, use the MSRP as the field in your calculations, and only calculate vehicles that meet all the following criteria: Vehicle year is newer than 2015 Transmission type is Automatic Highway MPG is greater than 25 10 17 . Using the data on the AutoSample worksheet, create a Pivot Table on a new worksheet and rename the worksheet, PivotAnalysis The Pivot Table should use the Make field as the Rows and MSRP as the Values. Change the MSRP calculation so that it calculates the Average of MSRP and format the field as Accounting with 2 decimal places Change Row Labels in cell A3 to Vehicle Make and adjust the column width as necessary so that all data are visible. . be es B 1 Make 2 Model Year Transmission Type Number of Doors Vehicle Size Vehicle Style highway MPG city mps MSRP 4 S 6 7 Make Model Year Transmission Type Number of Doors Vehicle Site 8 Lincoln MKS 2016 AUTOMATIC 4 Large 9 Toyota Camry Solara 2008 AUTOMATIC 2 Midsize 10 Volkswagen Passat 2016 AUTOMATIC 4 Midsize 11 Ford Mustang SVT Cobra 1998 MANUAL 2 Compact 12 Chevrolet Tahoe 2015 AUTOMATIC 4 Large 13 Chevrolet Cobalt 2009 MANUAL 2. Compact 14 Lamborghini Huracan 2016 AUTOMATED MANUAL 2 Compact 15 Buick Verano 2016 AUTOMATIC 4 Midaire 16 Toyota Sienna 2015 AUTOMATIC 4 ore 17 Maserati Coupe 2004 MANUAL 2 Compact 18 Chevrolet C/K 1500 Series 1997 MANUAL 2 Large 19 Suzuki Aerio 2005 MANUAL 4 Compact 20 Ford Freestar 2005 AUTOMATIC 4 Midsize 21 Chevrolet TrailBlazer 2008 AUTOMATIC 4 Midsize 22 Scion xD 2013 AUTOMATIC A Compact 23 Toyota Highlander 2015 AUTOMATIC 4 Midsize 24 Volkswagen Jetta SportWagen 2013 AUTOMATIC 4 Compact 25 Ford Transit Connect 2017 AUTOMATIC 4 Compact 26 HUMMER H3 2010 AUTOMATIC 4 Midsize 27 Audi A3 2015 AUTOMATED MANUAL 2 Compact 28 Volkswagen Beetle Convertible 2015 AUTOMATED MANUAL 2 Compact 29 Ferrari California 2015 AUTOMATED MANUAL 2 Compact AutoSample Selected Vehicles Database Totals Vehicle Style highway MPG city mps MSRP Sedan 26 17 $ 19,010.00 Coupe 31 22 S 21.010.00 Sedan 18 25 S 23,975.00 Convertible 24 16 S4,059.00 Adi SUV 22 16 5 49,300.00 Coupe 25 25 S 15,660.00 Coupe 21 14 5218,500.00 Sedan 12 21 S 24,475.00 Passenger Minivan 25 18 5 28,700.00 Coupe 15 10 S 81.013.00 Regular Cab Pickup 18 14 S 2,992.00 Wagon 28 22 5 15,449.00 Passenger Minivan 21 16 $ 32,755.00 4dr SUV 20 16 S 33,945.00 Adr Hatchback 33 27 S 16,565.00 4dr SUV 25 19 $ 36,590.00 Wacon 31 24 S 26,195,00 Passenger Minivan 27 19 S 25,590.00 4dr SUV 18 14 S 38,365.00 Convertible 32 23 $ 47,050.00 Convertible 29 23 $ 32,595.00 Convertible 23 16 $198,973.00 mating Table Styles 61 1 D 10 Volkswagen Passat 2016 AUTOMATIC 11 Ford Mustang SVT Cobra 1998 MANUAL 12 Chevrolet Tahoe 2015 AUTOMATIC 13 Chevrolet Cobalt 2009 MANUAL 14 Lamborghini Huracan 2016 AUTOMATED MANUAL 15 Buick Verano 2016 AUTOMATIC 16 Toyota Sienna 2015 AUTOMATIC 17 Maserati Coupe 2004 MANUAL 10 Chevrolet C/K 1500 Series 1997 MANUAL 19 Suruki Ario 2005 MANUAL 20 Ford Freesta 2005 AUTOMATIC 21. Chevrolet Trailarer 2008 AUTOMATIC 22 Scion ND 2011 AUTOMATIC 2) Toyota Richlander 2015 AUTOMATIC 24 Volkswagen Jetta SportWagen 2013 AUTOMATIC 25 Ford Transit Connect 2012 AUTOMATIC 26 HUMMER R 2010 AUTOMATIC 27 Audi A3 2015 AUTOMATED MANUAL 28 Volkswagen Beetle Convertible 2015 AUTOMATED MANUAL 29 Ferrari California 2015 AUTOMATED MANUAL 30 Lexus GS 410 2006 AUTOMATIC 31 Subaru WRX 2016 AUTOMATIC 32 Dodge Charger 2015 AUTOMATIC 33 Acura Intera 2000 MANUAL 34 FIAT 500L 2016 MANUAL 35 Aston Martin DBS 2012 AUTOMATIC 36 Suzuki X-90 1998 MANUAL 37 Midsize 2 Compact 1 Large 2 Compact > Compact 4 Midsize 4 Large 2 compact 2 tar 4 Compact 4 Misire 4 Midi 4 Compact 4 Midsize 4 Compact 4 Compact 4 Midsize 2 Compact 2 Compact 2. Compact 4 Midsize 4 Compact 4 Large 2 Compact 4 Compact 2 Midsize 2. Compact Sedan Convertible dr SUV Coupe Coupe Sedan Passenget Minivan Coupe Regular Cab Pickup Wacon Passenger Minivan ASUM Adr Hatchback Adr SUV Wagon Passenger Miniven de SUV Convertible Convertible Convertible Sedan Sedan Sedan 2dr Hatchback Wagon Convertible 2de SUV 35 24 22 35 21 12 25 15 18 2N 21 20 11 25 31 27 18 32 29 23 2.3 24 25 78 33 18 26 K 25 5 23,975.00 16 S 6,059.00 16 549,300.00 25 5 15.660.00 14 $2,500.00 21 5 24.475.00 18 $ 7.700.00 10 5 11.013.00 14 5 2,992.00 22 $ 15,499.00 16 5 12.755.00 14 5 35,045.00 27 5 16,545.00 19 5 16.900.00 36 5.26.195.00 19 5 25,500.00 14 58,365.00 23 5.47,050.00 23 $ 12:595.00 16 $100,973.00 16 $ 51,375.00 18 5 31,595.00 15 $ 47,995.00 22 S 7,398.00 25 $ 19,495.00 12 5290,861.00 22 $2,000.00 Xcut Hvor View Help Acrobat - BTU General romatine Doba A Waplert Merge Center Alignment $ . % Conditional format and Formatting table- H2 umber A Make 2 Toyota 3 Volkswagen 4 Buick 5 Model Camry Solar Passat Verano D G Year Transmission Number o Vehicle Sl Vehicle St highway city mps MSRP 2008 AUTOMATIC 2 Midsize Coupe 31 22 S 21.010.00 2016 AUTOMATIC 4 Midsize Sedan 38 25 5 23,975.00 2016 AUTOMATIC 4 Midsire Sedan 32 21 $24.475.00 M 2 8 9 10 11 12 13 14 15 TG 17 18 19 20 21 22 23 24 25 26 27 28 29 AutoSample Selected Vehicles Database Totals Ready Calon Il copy Format Painter Clipboard BTW- A. Font S A1 fo B D E 1000- 1 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 AutoSample Selected vehides Database Totals Ready ELE 9 20 Complete the Database Totals worksheet using the appropriate database functions using the CarDatabase named range, use the MSRP as the field in your calculations, and only calculate vehicles that meet all the following criteria: Vehicle year is newer than 2015 Transmission type is Automatic Highway MPG is greater than 25 10 17 . Using the data on the AutoSample worksheet, create a Pivot Table on a new worksheet and rename the worksheet, PivotAnalysis The Pivot Table should use the Make field as the Rows and MSRP as the Values. Change the MSRP calculation so that it calculates the Average of MSRP and format the field as Accounting with 2 decimal places Change Row Labels in cell A3 to Vehicle Make and adjust the column width as necessary so that all data are visible. . be es B 1 Make 2 Model Year Transmission Type Number of Doors Vehicle Size Vehicle Style highway MPG city mps MSRP 4 S 6 7 Make Model Year Transmission Type Number of Doors Vehicle Site 8 Lincoln MKS 2016 AUTOMATIC 4 Large 9 Toyota Camry Solara 2008 AUTOMATIC 2 Midsize 10 Volkswagen Passat 2016 AUTOMATIC 4 Midsize 11 Ford Mustang SVT Cobra 1998 MANUAL 2 Compact 12 Chevrolet Tahoe 2015 AUTOMATIC 4 Large 13 Chevrolet Cobalt 2009 MANUAL 2. Compact 14 Lamborghini Huracan 2016 AUTOMATED MANUAL 2 Compact 15 Buick Verano 2016 AUTOMATIC 4 Midaire 16 Toyota Sienna 2015 AUTOMATIC 4 ore 17 Maserati Coupe 2004 MANUAL 2 Compact 18 Chevrolet C/K 1500 Series 1997 MANUAL 2 Large 19 Suzuki Aerio 2005 MANUAL 4 Compact 20 Ford Freestar 2005 AUTOMATIC 4 Midsize 21 Chevrolet TrailBlazer 2008 AUTOMATIC 4 Midsize 22 Scion xD 2013 AUTOMATIC A Compact 23 Toyota Highlander 2015 AUTOMATIC 4 Midsize 24 Volkswagen Jetta SportWagen 2013 AUTOMATIC 4 Compact 25 Ford Transit Connect 2017 AUTOMATIC 4 Compact 26 HUMMER H3 2010 AUTOMATIC 4 Midsize 27 Audi A3 2015 AUTOMATED MANUAL 2 Compact 28 Volkswagen Beetle Convertible 2015 AUTOMATED MANUAL 2 Compact 29 Ferrari California 2015 AUTOMATED MANUAL 2 Compact AutoSample Selected Vehicles Database Totals Vehicle Style highway MPG city mps MSRP Sedan 26 17 $ 19,010.00 Coupe 31 22 S 21.010.00 Sedan 18 25 S 23,975.00 Convertible 24 16 S4,059.00 Adi SUV 22 16 5 49,300.00 Coupe 25 25 S 15,660.00 Coupe 21 14 5218,500.00 Sedan 12 21 S 24,475.00 Passenger Minivan 25 18 5 28,700.00 Coupe 15 10 S 81.013.00 Regular Cab Pickup 18 14 S 2,992.00 Wagon 28 22 5 15,449.00 Passenger Minivan 21 16 $ 32,755.00 4dr SUV 20 16 S 33,945.00 Adr Hatchback 33 27 S 16,565.00 4dr SUV 25 19 $ 36,590.00 Wacon 31 24 S 26,195,00 Passenger Minivan 27 19 S 25,590.00 4dr SUV 18 14 S 38,365.00 Convertible 32 23 $ 47,050.00 Convertible 29 23 $ 32,595.00 Convertible 23 16 $198,973.00 mating Table Styles 61 1 D 10 Volkswagen Passat 2016 AUTOMATIC 11 Ford Mustang SVT Cobra 1998 MANUAL 12 Chevrolet Tahoe 2015 AUTOMATIC 13 Chevrolet Cobalt 2009 MANUAL 14 Lamborghini Huracan 2016 AUTOMATED MANUAL 15 Buick Verano 2016 AUTOMATIC 16 Toyota Sienna 2015 AUTOMATIC 17 Maserati Coupe 2004 MANUAL 10 Chevrolet C/K 1500 Series 1997 MANUAL 19 Suruki Ario 2005 MANUAL 20 Ford Freesta 2005 AUTOMATIC 21. Chevrolet Trailarer 2008 AUTOMATIC 22 Scion ND 2011 AUTOMATIC 2) Toyota Richlander 2015 AUTOMATIC 24 Volkswagen Jetta SportWagen 2013 AUTOMATIC 25 Ford Transit Connect 2012 AUTOMATIC 26 HUMMER R 2010 AUTOMATIC 27 Audi A3 2015 AUTOMATED MANUAL 28 Volkswagen Beetle Convertible 2015 AUTOMATED MANUAL 29 Ferrari California 2015 AUTOMATED MANUAL 30 Lexus GS 410 2006 AUTOMATIC 31 Subaru WRX 2016 AUTOMATIC 32 Dodge Charger 2015 AUTOMATIC 33 Acura Intera 2000 MANUAL 34 FIAT 500L 2016 MANUAL 35 Aston Martin DBS 2012 AUTOMATIC 36 Suzuki X-90 1998 MANUAL 37 Midsize 2 Compact 1 Large 2 Compact > Compact 4 Midsize 4 Large 2 compact 2 tar 4 Compact 4 Misire 4 Midi 4 Compact 4 Midsize 4 Compact 4 Compact 4 Midsize 2 Compact 2 Compact 2. Compact 4 Midsize 4 Compact 4 Large 2 Compact 4 Compact 2 Midsize 2. Compact Sedan Convertible dr SUV Coupe Coupe Sedan Passenget Minivan Coupe Regular Cab Pickup Wacon Passenger Minivan ASUM Adr Hatchback Adr SUV Wagon Passenger Miniven de SUV Convertible Convertible Convertible Sedan Sedan Sedan 2dr Hatchback Wagon Convertible 2de SUV 35 24 22 35 21 12 25 15 18 2N 21 20 11 25 31 27 18 32 29 23 2.3 24 25 78 33 18 26 K 25 5 23,975.00 16 S 6,059.00 16 549,300.00 25 5 15.660.00 14 $2,500.00 21 5 24.475.00 18 $ 7.700.00 10 5 11.013.00 14 5 2,992.00 22 $ 15,499.00 16 5 12.755.00 14 5 35,045.00 27 5 16,545.00 19 5 16.900.00 36 5.26.195.00 19 5 25,500.00 14 58,365.00 23 5.47,050.00 23 $ 12:595.00 16 $100,973.00 16 $ 51,375.00 18 5 31,595.00 15 $ 47,995.00 22 S 7,398.00 25 $ 19,495.00 12 5290,861.00 22 $2,000.00 Xcut Hvor View Help Acrobat - BTU General romatine Doba A Waplert Merge Center Alignment $ . % Conditional format and Formatting table- H2 umber A Make 2 Toyota 3 Volkswagen 4 Buick 5 Model Camry Solar Passat Verano D G Year Transmission Number o Vehicle Sl Vehicle St highway city mps MSRP 2008 AUTOMATIC 2 Midsize Coupe 31 22 S 21.010.00 2016 AUTOMATIC 4 Midsize Sedan 38 25 5 23,975.00 2016 AUTOMATIC 4 Midsire Sedan 32 21 $24.475.00 M 2 8 9 10 11 12 13 14 15 TG 17 18 19 20 21 22 23 24 25 26 27 28 29 AutoSample Selected Vehicles Database Totals Ready Calon Il copy Format Painter Clipboard BTW- A. Font S A1 fo B D E 1000- 1 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 AutoSample Selected vehides Database Totals Ready ELE