Question: Please help me with this excel task: Set up the criteria in the row(s) below row 52. Find cars where the value in the Fuel
Please help me with this excel task: Set up the criteria in the row(s) below row 52. Find cars where the value in the Fuel column is Gasoline and the value in the Hwy MPG column is greater than 35. How do I filter or find the criteria for this please? All information is now given.

File Home Insert Page Layout Formulas Data Review View Help Share of Insert Corbel 11 A = General 5 IX Delete v Paste CT BI U A V Sensitivity $ v % , OO V Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Data Filter v Select Analysis Editing Analysis Clipboard Font Alignment Number Cells Sensitivity 91 1 B C D E F H J K L M N o P Q R. S U V W Criteria Model Displ cyl Drive Comb Co: - Trans Auto-1 N/A 0 N/A N/A N/A BMW i3 BEV BMW i3 BEV Filtered Data BMW i3 BEV (60Ah) 2WD 2WD 2WD Fuel Electricity Electricity Electricity Electricity 0 Cert Regic Stnd FA T3B0 CA ZEV FA T3Bo CA ZEV Auto-1 Auto-1 Auto-1 10 Elite 10 Elite 10 Elite 10 Elite N/A NIA o N/A N/A 2WD 0 Veh Class City MPG Hwy MPGmb MPG small car 10 129 106 118 small car 10 129 106 118 small car 10 137 111 124 small car 10 137 111 124 station wagon 10 128 110 119 station wagon 10 128 110 119 small car 10 121 103 112 small car 10 121 103 112 small car 10 118 96 107 CHEVROLET Bolt N/A N/A Auto-1 2WD Electricity FA T3Bo 10 Elite o CHEVROLET Bolt N/A. N/A CA 10 Elite 0 2WD 2WD FIAT 500e N/A N/A FA Auto-1 Auto-1 Auto-1 Auto-1 0 Electricity Electricity Electricity Electricity ZEV T3Bo ZEV 10 Elite 10 Elite NIA N/A CA o FIAT 500e FORD Focus Electric 2WD 2WD NIA N/A FA T3BO 10 Elite 0 NIA NIA 2WD CA 118 96 107 10 Elite 0 10 8 1.6 2WD CA 55 55 10 Yes FORD Focus Electric HYUNDAI Ionig HYUNDAI Ionig HYUNDAI Ioniq Blue HYUNDAI Ioniq Blue Auto-1 4 AutoMan-6 4 AutoMan-6 4 AutoMan-6 4 AutoMan-6 1.6 Electricity Gasoline Gasoline Gasoline Gasoline 54 54 2WD ZEV small car L3SULEV30 large car T3B30 large car L3SULEV30 large car T3B30 large car FA 55 55 10 Yes 8 8 163 163 154 2WD CA 57 59 58 10 Yes 1.6 1.6 2WD FA 8 57 59 58 10 Yes 154 HYUNDAI Ioniq Electric N/A N/A. Auto-1 2WD Electricity FA T3Bo midsize car 10 150 122 136 10 Elite 0 N/A Auto-1 2WD Electricity CA ZEV midsize car 10 150 122 136 10 Elite 0 2 4 AutoMan-6 2WD Gasoline CA L3ULEV125 midsize car 6 38 43 40 9 Yes 222 HYUNDAI Ioniq Electric N/A HYUNDAI Sonata Hybrid HYUNDAI Sonata Hybrid HYUNDAI Sonata Hybrid SE HYUNDAI Sonata Hybrid SE 2 4 AutoMan-6 2WD Gasoline FA T3B125 midsize car 6 38 43 40 9 Yes 222 2 4 AutoMan-6 2WD Gasoline CA L3ULEV125 midsize car 6 39 45 42 9 Yes 221 2 4 AutoMan-6 2WD Gasoline FA T3B125 6 39 45 42 9 Yes 221 KIA Niro 1.6 4 AutoMan-6 2WD Gasoline CA L3SULEV30 midsize car station wagon station wagon 8 51 46 49 10 Yes 183 KIA Niro 1.6 4 AutoMan-6 2WD Gasoline FA T3B30 8 51 46 49 10 Yes 183 My Car Data MPG Data MPG Pivot Table Bakery Business + File Home Insert Page Layout Formulas Data Review View Help Share of Insert Corbel 11 A = General 5 IX Delete v Paste CT BI U A V Sensitivity $ v % , OO V Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Data Filter v Select Analysis Editing Analysis Clipboard Font Alignment Number Cells Sensitivity 91 1 B C D E F H J K L M N o P Q R. S U V W Criteria Model Displ cyl Drive Comb Co: - Trans Auto-1 N/A 0 N/A N/A N/A BMW i3 BEV BMW i3 BEV Filtered Data BMW i3 BEV (60Ah) 2WD 2WD 2WD Fuel Electricity Electricity Electricity Electricity 0 Cert Regic Stnd FA T3B0 CA ZEV FA T3Bo CA ZEV Auto-1 Auto-1 Auto-1 10 Elite 10 Elite 10 Elite 10 Elite N/A NIA o N/A N/A 2WD 0 Veh Class City MPG Hwy MPGmb MPG small car 10 129 106 118 small car 10 129 106 118 small car 10 137 111 124 small car 10 137 111 124 station wagon 10 128 110 119 station wagon 10 128 110 119 small car 10 121 103 112 small car 10 121 103 112 small car 10 118 96 107 CHEVROLET Bolt N/A N/A Auto-1 2WD Electricity FA T3Bo 10 Elite o CHEVROLET Bolt N/A. N/A CA 10 Elite 0 2WD 2WD FIAT 500e N/A N/A FA Auto-1 Auto-1 Auto-1 Auto-1 0 Electricity Electricity Electricity Electricity ZEV T3Bo ZEV 10 Elite 10 Elite NIA N/A CA o FIAT 500e FORD Focus Electric 2WD 2WD NIA N/A FA T3BO 10 Elite 0 NIA NIA 2WD CA 118 96 107 10 Elite 0 10 8 1.6 2WD CA 55 55 10 Yes FORD Focus Electric HYUNDAI Ionig HYUNDAI Ionig HYUNDAI Ioniq Blue HYUNDAI Ioniq Blue Auto-1 4 AutoMan-6 4 AutoMan-6 4 AutoMan-6 4 AutoMan-6 1.6 Electricity Gasoline Gasoline Gasoline Gasoline 54 54 2WD ZEV small car L3SULEV30 large car T3B30 large car L3SULEV30 large car T3B30 large car FA 55 55 10 Yes 8 8 163 163 154 2WD CA 57 59 58 10 Yes 1.6 1.6 2WD FA 8 57 59 58 10 Yes 154 HYUNDAI Ioniq Electric N/A N/A. Auto-1 2WD Electricity FA T3Bo midsize car 10 150 122 136 10 Elite 0 N/A Auto-1 2WD Electricity CA ZEV midsize car 10 150 122 136 10 Elite 0 2 4 AutoMan-6 2WD Gasoline CA L3ULEV125 midsize car 6 38 43 40 9 Yes 222 HYUNDAI Ioniq Electric N/A HYUNDAI Sonata Hybrid HYUNDAI Sonata Hybrid HYUNDAI Sonata Hybrid SE HYUNDAI Sonata Hybrid SE 2 4 AutoMan-6 2WD Gasoline FA T3B125 midsize car 6 38 43 40 9 Yes 222 2 4 AutoMan-6 2WD Gasoline CA L3ULEV125 midsize car 6 39 45 42 9 Yes 221 2 4 AutoMan-6 2WD Gasoline FA T3B125 6 39 45 42 9 Yes 221 KIA Niro 1.6 4 AutoMan-6 2WD Gasoline CA L3SULEV30 midsize car station wagon station wagon 8 51 46 49 10 Yes 183 KIA Niro 1.6 4 AutoMan-6 2WD Gasoline FA T3B30 8 51 46 49 10 Yes 183 My Car Data MPG Data MPG Pivot Table Bakery Business +
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
