9. Apply a new custom conditional formatting rule to cells N57:N72 to show the 4 Ratings icon set. Show the icon only, 10. Continue working with the filtered data that has the conditional formatting applied. Sort the table first alphabetically by the values in the Model column and then by icon in the Cmb MPG Icon column so the Signal Meter With Four Filled Bars icon appears at the top. 11. Go back to the main data set at the top of the My Car Data worksheet and add subtotals for each change in Model to calculate the average for the following: Air Pollution Score, City MPG, Hwy MPG, and Cmb MPG 12. Collapse the data to show just the total rows. fm the data on the Home Page Data Vw etab He Cat Central Naman CF Normal NORLAR Title# IF 6 In the fun C AB 9 CAROLIT H o # 1. Clo NA D C www CH wy MPGSMO IW AR 10 10 50 MA w ww W WO CA FA CA PA OM A 1 Set CH 20VOLT HA HUR fet . . . V AR 10 TO 10 10 10 PORT CR TA CA WO w He 2 G 13111111 001 we w CA TA LE CA Yes T 15. 16 UNGA TWO WO WO PA CA 8 10 10 A w 18 1 ww TA 30 DA ESS SS SS SS SE SES 5 33 32 33 33 . WW PA ONE w w 23 3 ago . BEBE AM OM . ES WA 1 WO 1 AR ad G + Om fic 6 CA ra HA CA ww WO WO w 0 AS 12 NA DEN My Car Dute MO Bary 0 Honde imet Page Layout Formulas Data View New Tab Help X Cu Cupy - Corel BTW. A. plot as Merge Center General Normal per NotewaLAR $ %) Sandro komite Normal Bad Formatting to Number stys Title# Good Chipboard Pan Alignmand AG CHEVROLET Bolt M N 0 11 13 NA NA NA NW 10 sos 15 93 E ww ww WO WD WD WD WD 0 F Gasse Electro City Elect Electro Eccy Electricity C 2 Mens TO AL NA A- Tes NA Autos NA Auto- N Autos NA At w Autos SU Atos 10 lite Me ENE G TA ca FA FA CA FA CA FA H Tas id Do on won ZEV son T300 mida ZEV mec je waar EV w 10 10 10 10 10 10 ET 10 MA 13 113 in be 10 E u 300 NU NA . wy 30 die wew 1 11 29 KIO 30 de 31 Sot 12 MERCEDES-BENZ 33 MERCEDES-BENZ Bage 34 MITSUBISHMEV 35 MITSUSMEY 36 NISSAN 37 NISSAN 38 TESLA Models 29 TESLA 40 TESLA Mode 575 41 TESLA Models TESLA MSP 4 TESLA Model 44 TESLA MO 45. TESLA MO 46 TESLA MXD 47 TESLA Modo 20 TESLA MED 49. VOLKSWAGEN 50 10 ZEV To TO Ty 10 Non TA FA 99 03 ca 395 WD 4WD 10 WO WO 4w WO 4WD 4WD Electric Electricity Electricity Eco Electric Et IN RIA A Anes 10 10 TO 10 10 150 10 10 10 10 10 10 10 10 95 si SSSSSSSS SUV SUV NA he 91 WO TA FA NA NA A NA A NA Auto Ty lect Electricity Elroy Electricity Elect 4WO w MU M 3 to it Et WO TA 119 52 53 56 52 59 50 51 02 6 64 65 66 Scenario y Calon My Car Data MG Data Pile resi Ready X In Corbeledy A A General $ - % 9 JOZ Peute Merge Center Condo Format Formatting Tables Dwi Format AZ * Fx Model A H K M 0 0 5 n A All Models ORY Hy 34 of GO De Yeah CA 41 ** HOW WWE 14 ME OT WE - i Y he 5 CE we ALFA ROMEO HALFARO ALFA ROMEO 15 LANKOWO TOMAR MW AITON MARTIN AUTUNUT 45 ALTON ASTON MARTIN ASORT 1 TA CA FA CA 1 A . 9 6 VE Th Us CA . ww . in Site 4 AM IP 1 AUDI 9 GA STUDIA O 19 A wala + . 1 SF CA FA F 1 1 A. le + AM ADA AVAN 1 M . 1 5 ADA ww WO A TA 18 THE FEDE 11 EEE FEEL FR 11 EEE ISK - F 8355 55 55 55 55 SSES 53 RUDA ASE IT AU WA . AV nel M Te 1 w BA PL . . 1 11 FR CA M CA N 6 ARA Corbel (Body - A A Wrap Test General OEM 3 Conan Format Formatting style Formal * Fx Model A 0 G 1 M N D T All Models cm Ce 3! DH WOMA 100 ww Ve ALTAMO ALFA ROMEO ALAGANO ALFA RODAD AT . 18 . V WE 1 G to This Us LOGY ww . 1 ww ASTMARTRE + ALTOR AMMA HA CA CA . . . N LA AM V WE HA ATUA 4 TRR EEE SI + FA 1 AM . . 18 TE La V AUD PRO 15 15 1 PM * N 21 RRAL 12 HIT RESSER . AL . E 333 SE 55 56 33 33 888 5: AUDR LA EEEEEE . AUD AUSAR + NE NE + LE + T1 ALIA ALAL . . 4 D LLEY 4 AM AM . . 3 AUDI ALDA WD . mer 1 * PF ** AMS ww CA AUDIA 66 ALBIAR . A My Car Data MPG Data MPG Pivot Table Bakery Business Air Pollution Score Greenhouse Gas Score City Cmb MPG Hwy MPG SmartWay MPG Comb Coa small car e e 6 6 25 25 35 35 29 29 - 7 Yes 7 Yes 309 309 e 19 27 S No 404 6 5 No e he le 391 20 19 20 27 27 27 23 22 23 5 No 6 5 No 404 391 re 6 18 26 21 4 No 424 6 26 22 re be he 19 18 5 No 6 6 21 26 26 6 No 404 424 404 19 22 5 No 21 he he he 21 21 4 No 22 22 28 4 No OOOOO 20 21 23 23 22 20 Cert Region Sind Veh Class LJULEV CA 125 FA T38:25 small car LUULEV CA 125 small SUV LJULEV CA 125 small SUV FA T38125 small SUV FA T38125 small SUV LJULEV CA 125 small SUV LJULEV 125 Small SUV FA TyB125 Small SUV FA T3B125 small SUV LJULEV CA 325 small car FA T3Baas small car FA T3B125 small SUV CA Ua Small SUV FA T3B125 small SUV Ua Small SUV L3SULE CA V30 midsize car FA T3B20 midsize car FA Tuas midsize car CA U midsize car FA TyBaas small car ICA U2 small car FA Taas small car small car FA TB125 small car CA Us CA small car FA T30160 small car CA Ty@so midsize car FA To midsize car LZULEY CA FA Tuas midsize car CA Tyto midsize car FA Tytse midsize car FA Tas Small CW Bakery Business 2B he 420 420 386 386 402 402 5 No 5 NO 5 No 5 No 19 19 6 27 27 22 he 8 8 7 Yes 29 29 20 ne ne 6 6 306 306 380 380 323 ne ne 30 30 30 30 35 35 34 34 20 24 24 6 7 Yes 5 No 5 No 6 No 6 No 5 NO 6 ne ne Ua 29 29 23 23 28 28 25 25 25 25 28 28 27 27 6 6 6 358 ne S No 31 small car 6 31 ne 34 5 5 6 6 24 24 24 24 Ine 5 No 5 No 6 No 6 No 6 No 6 No 34 33 33 358 358 357 317 330 330 ne ine midsecar 6 27 20 20 dine line 16 6 6 6 23 23 14 24 24 31 33 21 26 26 NO 4 No 6 No 6 No 3 No 49 451 348 340 533 37 able + 9. Apply a new custom conditional formatting rule to cells N57:N72 to show the 4 Ratings icon set. Show the icon only, 10. Continue working with the filtered data that has the conditional formatting applied. Sort the table first alphabetically by the values in the Model column and then by icon in the Cmb MPG Icon column so the Signal Meter With Four Filled Bars icon appears at the top. 11. Go back to the main data set at the top of the My Car Data worksheet and add subtotals for each change in Model to calculate the average for the following: Air Pollution Score, City MPG, Hwy MPG, and Cmb MPG 12. Collapse the data to show just the total rows. fm the data on the Home Page Data Vw etab He Cat Central Naman CF Normal NORLAR Title# IF 6 In the fun C AB 9 CAROLIT H o # 1. Clo NA D C www CH wy MPGSMO IW AR 10 10 50 MA w ww W WO CA FA CA PA OM A 1 Set CH 20VOLT HA HUR fet . . . V AR 10 TO 10 10 10 PORT CR TA CA WO w He 2 G 13111111 001 we w CA TA LE CA Yes T 15. 16 UNGA TWO WO WO PA CA 8 10 10 A w 18 1 ww TA 30 DA ESS SS SS SS SE SES 5 33 32 33 33 . WW PA ONE w w 23 3 ago . BEBE AM OM . ES WA 1 WO 1 AR ad G + Om fic 6 CA ra HA CA ww WO WO w 0 AS 12 NA DEN My Car Dute MO Bary 0 Honde imet Page Layout Formulas Data View New Tab Help X Cu Cupy - Corel BTW. A. plot as Merge Center General Normal per NotewaLAR $ %) Sandro komite Normal Bad Formatting to Number stys Title# Good Chipboard Pan Alignmand AG CHEVROLET Bolt M N 0 11 13 NA NA NA NW 10 sos 15 93 E ww ww WO WD WD WD WD 0 F Gasse Electro City Elect Electro Eccy Electricity C 2 Mens TO AL NA A- Tes NA Autos NA Auto- N Autos NA At w Autos SU Atos 10 lite Me ENE G TA ca FA FA CA FA CA FA H Tas id Do on won ZEV son T300 mida ZEV mec je waar EV w 10 10 10 10 10 10 ET 10 MA 13 113 in be 10 E u 300 NU NA . wy 30 die wew 1 11 29 KIO 30 de 31 Sot 12 MERCEDES-BENZ 33 MERCEDES-BENZ Bage 34 MITSUBISHMEV 35 MITSUSMEY 36 NISSAN 37 NISSAN 38 TESLA Models 29 TESLA 40 TESLA Mode 575 41 TESLA Models TESLA MSP 4 TESLA Model 44 TESLA MO 45. TESLA MO 46 TESLA MXD 47 TESLA Modo 20 TESLA MED 49. VOLKSWAGEN 50 10 ZEV To TO Ty 10 Non TA FA 99 03 ca 395 WD 4WD 10 WO WO 4w WO 4WD 4WD Electric Electricity Electricity Eco Electric Et IN RIA A Anes 10 10 TO 10 10 150 10 10 10 10 10 10 10 10 95 si SSSSSSSS SUV SUV NA he 91 WO TA FA NA NA A NA A NA Auto Ty lect Electricity Elroy Electricity Elect 4WO w MU M 3 to it Et WO TA 119 52 53 56 52 59 50 51 02 6 64 65 66 Scenario y Calon My Car Data MG Data Pile resi Ready X In Corbeledy A A General $ - % 9 JOZ Peute Merge Center Condo Format Formatting Tables Dwi Format AZ * Fx Model A H K M 0 0 5 n A All Models ORY Hy 34 of GO De Yeah CA 41 ** HOW WWE 14 ME OT WE - i Y he 5 CE we ALFA ROMEO HALFARO ALFA ROMEO 15 LANKOWO TOMAR MW AITON MARTIN AUTUNUT 45 ALTON ASTON MARTIN ASORT 1 TA CA FA CA 1 A . 9 6 VE Th Us CA . ww . in Site 4 AM IP 1 AUDI 9 GA STUDIA O 19 A wala + . 1 SF CA FA F 1 1 A. le + AM ADA AVAN 1 M . 1 5 ADA ww WO A TA 18 THE FEDE 11 EEE FEEL FR 11 EEE ISK - F 8355 55 55 55 55 SSES 53 RUDA ASE IT AU WA . AV nel M Te 1 w BA PL . . 1 11 FR CA M CA N 6 ARA Corbel (Body - A A Wrap Test General OEM 3 Conan Format Formatting style Formal * Fx Model A 0 G 1 M N D T All Models cm Ce 3! DH WOMA 100 ww Ve ALTAMO ALFA ROMEO ALAGANO ALFA RODAD AT . 18 . V WE 1 G to This Us LOGY ww . 1 ww ASTMARTRE + ALTOR AMMA HA CA CA . . . N LA AM V WE HA ATUA 4 TRR EEE SI + FA 1 AM . . 18 TE La V AUD PRO 15 15 1 PM * N 21 RRAL 12 HIT RESSER . AL . E 333 SE 55 56 33 33 888 5: AUDR LA EEEEEE . AUD AUSAR + NE NE + LE + T1 ALIA ALAL . . 4 D LLEY 4 AM AM . . 3 AUDI ALDA WD . mer 1 * PF ** AMS ww CA AUDIA 66 ALBIAR . A My Car Data MPG Data MPG Pivot Table Bakery Business Air Pollution Score Greenhouse Gas Score City Cmb MPG Hwy MPG SmartWay MPG Comb Coa small car e e 6 6 25 25 35 35 29 29 - 7 Yes 7 Yes 309 309 e 19 27 S No 404 6 5 No e he le 391 20 19 20 27 27 27 23 22 23 5 No 6 5 No 404 391 re 6 18 26 21 4 No 424 6 26 22 re be he 19 18 5 No 6 6 21 26 26 6 No 404 424 404 19 22 5 No 21 he he he 21 21 4 No 22 22 28 4 No OOOOO 20 21 23 23 22 20 Cert Region Sind Veh Class LJULEV CA 125 FA T38:25 small car LUULEV CA 125 small SUV LJULEV CA 125 small SUV FA T38125 small SUV FA T38125 small SUV LJULEV CA 125 small SUV LJULEV 125 Small SUV FA TyB125 Small SUV FA T3B125 small SUV LJULEV CA 325 small car FA T3Baas small car FA T3B125 small SUV CA Ua Small SUV FA T3B125 small SUV Ua Small SUV L3SULE CA V30 midsize car FA T3B20 midsize car FA Tuas midsize car CA U midsize car FA TyBaas small car ICA U2 small car FA Taas small car small car FA TB125 small car CA Us CA small car FA T30160 small car CA Ty@so midsize car FA To midsize car LZULEY CA FA Tuas midsize car CA Tyto midsize car FA Tytse midsize car FA Tas Small CW Bakery Business 2B he 420 420 386 386 402 402 5 No 5 NO 5 No 5 No 19 19 6 27 27 22 he 8 8 7 Yes 29 29 20 ne ne 6 6 306 306 380 380 323 ne ne 30 30 30 30 35 35 34 34 20 24 24 6 7 Yes 5 No 5 No 6 No 6 No 5 NO 6 ne ne Ua 29 29 23 23 28 28 25 25 25 25 28 28 27 27 6 6 6 358 ne S No 31 small car 6 31 ne 34 5 5 6 6 24 24 24 24 Ine 5 No 5 No 6 No 6 No 6 No 6 No 34 33 33 358 358 357 317 330 330 ne ine midsecar 6 27 20 20 dine line 16 6 6 6 23 23 14 24 24 31 33 21 26 26 NO 4 No 6 No 6 No 3 No 49 451 348 340 533 37 able +