Ar to me Or make and description based on model number input Estimated annual cost of gas based on the selected type of driving, weight class, annual Estimated annual insurance premium based on the owner's region of residence, driving mynd, and residential status (Hint: Include an intermediate calculation in the form that looks up the region number associated with the state of residence, and then refer Estimated average annual maintenance cost for the first three years of operation, based on the sclected car model and annual miles traveled (total 3-year maintenance costs dided by 3 plus the cost of 1 year of oil changes): to the base maintenance cost, add $39 per oil change for cach 3,500 miles driven Estimated total cost of operation per year 22,500 File Excel Edit View inser X (2) Excel range name manager X D (2) YouTube google.com/search?rlz=1C5CHFA_enUS815US820&sxsrf=ALekko AutoSave OFF Data Formulas Review View Te Home Insert Draw Page Layout v = ' ' 10 Arial X Cut Le Copy Format V B E E V I UP Paste A 12 D A B Customer Information on Estimate Form Data Input Expected number of driving miles per year 22,500 Type of driving-High way. Mixed. City Mixed State of residence CA Residencial status: City, Suburban, or Rural City Driving safety record: Exellent. Average, Poor Exellent Gas Price adjusmnet Percentage 0.611 Region Number 5 Veiclo Model Profilo Number of Model number Make and Description Cylinders 2 Voltage Wagon 4 3 Mia 6 6 Dorf Sport 8 9 Zemb Turbo Avo Gas Styr Ma 3 2 + 5 B 7 8 9 0 1 2 3 4 5 8 Estimate Form Models Mileage States Insurance Gas Price: Ready 9.789 21 Tools Data Window Help Format View Insert Excel File Edit Ghunan c X O (2) Excel range name manager X O (2) YouTube .google.com/search?rlz=1C5CHFA_enUS815US820&sxsrf=ALekkofj2NWuBd AutoSave Dom Insert Draw Page Layout Formulas Data Review View Tell me Home a Wrap Tex Merge & fx Number of Miles per Oil Change: X Cut Arial ~ 10 Ar [b Copy v Pasto B v Format a. Av C16 4 x A B D E G H 1 KG Auto Car Model Information 2 Maintenance Cost Base 3 Model Car Model Description Engine Weight Class 1st Year 2 nd Year 3rd Year 4 1 Voltage Compact sedan 14 $ 275$ 325$ 475 5 2 Voltage Wagon Compact hatchback 4,6 1 275 325 475 6 3 Mia Mid-size sedan 4,6 2 275 325 475 7 4 Mia XL Md-size luxury sedan 6.8 2 50 50 50 B 5 Tiar SUV 6.8. turto 3 0 0 0 66 Dort Sport Compact sports.cor 6.8. turbo 1 325 375 500 10 7 Sunn.V Nexus Md-size sports.com 8 turbo 2 325 375 500 11 8 RunAbout Full-size van 8, turbo 3 50 50 500 12 9 Zemb Mid-sizo truck 8. turbo 3 375 425 500 14 15 16 17 Oil Change Informations Number of Miles per Oil Chango: 3500 Cost per Oil Change $ 39 19 20 21 22 23 - 25 20 27 28 dari 30 31 32 33 35 30 Estimate Form Models Mileage States Insurance Ready Gas Prices + 200 SER 21 M esc F1 GOD F2 80 F3 Data Window Help Tools Format Insert View Excel File Edit Gh X D (2) Excel range name manager X D (2) YouTube C .google.com/search?rlz=1C5CHFA_enUS815US820&sxsrf=ALekkofj2N AutoSave OFF Formulas Data Review View Tell me Home Insert Draw Page Layout 10 v A A a. Av M X Cut Arial Le Copy v Format BIU. x fx Paste 125 G F H E A B D 1 Highway Driving: Miles per Gallon 3 Weight Class 1 2 3 4 40.7 41.0 NA Engine 6 34.1 30.81 26.4 8 turbo 31.9 27.5 24.2) 29.7 26.4 23.1 9 Mixed Driving: Miles per Gallon Engine 6 29.7 26.4 23.1 - 23 4 5 6 78gm=b 8 turbo 26.4 22.0 19.8 25.3 20.9 18.7 11 Weight Class 4 12 1 36.3 13 2 36.0 3 NA 15 16 17 City Driving: Miles per Gallon 18 19 Weight Class 4 1 33.3 21 2 3 NA Engine 6 27.3 24.2 21.2 37.3 8 turbo 24.2 20.2 18.2 27.80 23.0 20.61 Estimate Form Models Mileage States Ready Insurance Gas Prices + * 21 esc F1 F2 20 F3 000 DOO FA Draw Page Home Insert ' ' = a. A v V v G H E F 2 5 Region Listing SE W sw NE MW 4 1 3 CO 10 X cut Arial Le Copy v Paste BIU Format G13 Ax & fx B D A 1 Name Abbreviation Region Region AL 2 SE 2 ALABAMA AK 5 W 3. ALASKA AZ 4 SW 4 ARIZONA AR SE 2 5 ARKANSAS CA 6 CALIFORNIA 5 W 7 COLORADO w 5 8 CONNECTICUT CT NE 1 9 DELAWARE DE NE 1 DISTRICT OF DC 10 COLUMBIA NE 1 11 FLORIDA FL SE 2 12 GEORGIA GA SE 2 13 HAWAII HI W 5 14 IDAHO ID W 5 15 ILLINOIS IL MW 3 16 INDIANA IN MW 3 17 TOWA IA MW 3 18 KANSAS KS MW 3 19 KENTUCKY KY 2 20 LOUISIANA LA 2 21 MAINE ME NE 1 22 MARYLAND MD NE 1 23 MASSACHUSETTS MA NE 1 24 MICHIGAN MI MW 3 25 MINNESOTA MN MW 3 26 MISSISSIPPI MS SE 2 27 MISSOURI MO MW 3 28 MONTANA MT W 29 NEBRASKA 5 NE 30 NEVADA MW 3 NV W 31 NEW HAMPSHIRE 5 NH 27. INEW JERSEY NE NJ INE Estimate Form Models SE SE Mileage States Insurance Gas Pri Ready 9.700 g FEU 21 esc F1 F2 Bo F3 DOO 000 F4 # $ 1 2 3 4. Home Insert v 10 v ' ' Arial X Cut [b Copy ~ = = === BIU v a. Av Paste Format E32 X fx G H A B D E F Insurance Estimate Calculator Deduction for Addition Addition for Deduction Excellent for Poor City for Rural Base Cost Driver Driver Residence Residence 1 $ 2.200 S 350 $ 550 $ 415$ 400 2 1,750 325 475 415 220 3 1,425 300 450 415 200 4 1.120 300 450 415 100 5 2,650 350 625 415 500 2 Region 3 4 5 6 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Estimate Form Models Mileage Ready States Insuxance Gas Prices 0.700 1 21 HE esc F1 F2 80 F3 000 DOO F4 # 1 $ 2 % 3 4 Arial X Cut [b Copy Format a. Av E Paste BIU F8 x fx D E F A B Average Gas Prices Average price per gallon 1 $4.00 2 3.59 3 3.69 4 3.39 4.12 2 Region 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Estimate Form Models Mileage Ready States Insurance Gas Prices 9.769 TES 21 WO esc F2 80 F3 OOO OOO FA ! # 1 $ 2 % 3 4 5 Ar to me Or make and description based on model number input Estimated annual cost of gas based on the selected type of driving, weight class, annual Estimated annual insurance premium based on the owner's region of residence, driving mynd, and residential status (Hint: Include an intermediate calculation in the form that looks up the region number associated with the state of residence, and then refer Estimated average annual maintenance cost for the first three years of operation, based on the sclected car model and annual miles traveled (total 3-year maintenance costs dided by 3 plus the cost of 1 year of oil changes): to the base maintenance cost, add $39 per oil change for cach 3,500 miles driven Estimated total cost of operation per year 22,500 File Excel Edit View inser X (2) Excel range name manager X D (2) YouTube google.com/search?rlz=1C5CHFA_enUS815US820&sxsrf=ALekko AutoSave OFF Data Formulas Review View Te Home Insert Draw Page Layout v = ' ' 10 Arial X Cut Le Copy Format V B E E V I UP Paste A 12 D A B Customer Information on Estimate Form Data Input Expected number of driving miles per year 22,500 Type of driving-High way. Mixed. City Mixed State of residence CA Residencial status: City, Suburban, or Rural City Driving safety record: Exellent. Average, Poor Exellent Gas Price adjusmnet Percentage 0.611 Region Number 5 Veiclo Model Profilo Number of Model number Make and Description Cylinders 2 Voltage Wagon 4 3 Mia 6 6 Dorf Sport 8 9 Zemb Turbo Avo Gas Styr Ma 3 2 + 5 B 7 8 9 0 1 2 3 4 5 8 Estimate Form Models Mileage States Insurance Gas Price: Ready 9.789 21 Tools Data Window Help Format View Insert Excel File Edit Ghunan c X O (2) Excel range name manager X O (2) YouTube .google.com/search?rlz=1C5CHFA_enUS815US820&sxsrf=ALekkofj2NWuBd AutoSave Dom Insert Draw Page Layout Formulas Data Review View Tell me Home a Wrap Tex Merge & fx Number of Miles per Oil Change: X Cut Arial ~ 10 Ar [b Copy v Pasto B v Format a. Av C16 4 x A B D E G H 1 KG Auto Car Model Information 2 Maintenance Cost Base 3 Model Car Model Description Engine Weight Class 1st Year 2 nd Year 3rd Year 4 1 Voltage Compact sedan 14 $ 275$ 325$ 475 5 2 Voltage Wagon Compact hatchback 4,6 1 275 325 475 6 3 Mia Mid-size sedan 4,6 2 275 325 475 7 4 Mia XL Md-size luxury sedan 6.8 2 50 50 50 B 5 Tiar SUV 6.8. turto 3 0 0 0 66 Dort Sport Compact sports.cor 6.8. turbo 1 325 375 500 10 7 Sunn.V Nexus Md-size sports.com 8 turbo 2 325 375 500 11 8 RunAbout Full-size van 8, turbo 3 50 50 500 12 9 Zemb Mid-sizo truck 8. turbo 3 375 425 500 14 15 16 17 Oil Change Informations Number of Miles per Oil Chango: 3500 Cost per Oil Change $ 39 19 20 21 22 23 - 25 20 27 28 dari 30 31 32 33 35 30 Estimate Form Models Mileage States Insurance Ready Gas Prices + 200 SER 21 M esc F1 GOD F2 80 F3 Data Window Help Tools Format Insert View Excel File Edit Gh X D (2) Excel range name manager X D (2) YouTube C .google.com/search?rlz=1C5CHFA_enUS815US820&sxsrf=ALekkofj2N AutoSave OFF Formulas Data Review View Tell me Home Insert Draw Page Layout 10 v A A a. Av M X Cut Arial Le Copy v Format BIU. x fx Paste 125 G F H E A B D 1 Highway Driving: Miles per Gallon 3 Weight Class 1 2 3 4 40.7 41.0 NA Engine 6 34.1 30.81 26.4 8 turbo 31.9 27.5 24.2) 29.7 26.4 23.1 9 Mixed Driving: Miles per Gallon Engine 6 29.7 26.4 23.1 - 23 4 5 6 78gm=b 8 turbo 26.4 22.0 19.8 25.3 20.9 18.7 11 Weight Class 4 12 1 36.3 13 2 36.0 3 NA 15 16 17 City Driving: Miles per Gallon 18 19 Weight Class 4 1 33.3 21 2 3 NA Engine 6 27.3 24.2 21.2 37.3 8 turbo 24.2 20.2 18.2 27.80 23.0 20.61 Estimate Form Models Mileage States Ready Insurance Gas Prices + * 21 esc F1 F2 20 F3 000 DOO FA Draw Page Home Insert ' ' = a. A v V v G H E F 2 5 Region Listing SE W sw NE MW 4 1 3 CO 10 X cut Arial Le Copy v Paste BIU Format G13 Ax & fx B D A 1 Name Abbreviation Region Region AL 2 SE 2 ALABAMA AK 5 W 3. ALASKA AZ 4 SW 4 ARIZONA AR SE 2 5 ARKANSAS CA 6 CALIFORNIA 5 W 7 COLORADO w 5 8 CONNECTICUT CT NE 1 9 DELAWARE DE NE 1 DISTRICT OF DC 10 COLUMBIA NE 1 11 FLORIDA FL SE 2 12 GEORGIA GA SE 2 13 HAWAII HI W 5 14 IDAHO ID W 5 15 ILLINOIS IL MW 3 16 INDIANA IN MW 3 17 TOWA IA MW 3 18 KANSAS KS MW 3 19 KENTUCKY KY 2 20 LOUISIANA LA 2 21 MAINE ME NE 1 22 MARYLAND MD NE 1 23 MASSACHUSETTS MA NE 1 24 MICHIGAN MI MW 3 25 MINNESOTA MN MW 3 26 MISSISSIPPI MS SE 2 27 MISSOURI MO MW 3 28 MONTANA MT W 29 NEBRASKA 5 NE 30 NEVADA MW 3 NV W 31 NEW HAMPSHIRE 5 NH 27. INEW JERSEY NE NJ INE Estimate Form Models SE SE Mileage States Insurance Gas Pri Ready 9.700 g FEU 21 esc F1 F2 Bo F3 DOO 000 F4 # $ 1 2 3 4. Home Insert v 10 v ' ' Arial X Cut [b Copy ~ = = === BIU v a. Av Paste Format E32 X fx G H A B D E F Insurance Estimate Calculator Deduction for Addition Addition for Deduction Excellent for Poor City for Rural Base Cost Driver Driver Residence Residence 1 $ 2.200 S 350 $ 550 $ 415$ 400 2 1,750 325 475 415 220 3 1,425 300 450 415 200 4 1.120 300 450 415 100 5 2,650 350 625 415 500 2 Region 3 4 5 6 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Estimate Form Models Mileage Ready States Insuxance Gas Prices 0.700 1 21 HE esc F1 F2 80 F3 000 DOO F4 # 1 $ 2 % 3 4 Arial X Cut [b Copy Format a. Av E Paste BIU F8 x fx D E F A B Average Gas Prices Average price per gallon 1 $4.00 2 3.59 3 3.69 4 3.39 4.12 2 Region 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Estimate Form Models Mileage Ready States Insurance Gas Prices 9.769 TES 21 WO esc F2 80 F3 OOO OOO FA ! # 1 $ 2 % 3 4 5