Please provide step by step!

1. Open the workbook named Quotes.xlsx located in the Chapter 8 folder, and save the file as Transport Quotes.xlsx. 2. Examine the Analysis worksheet, and apply appropriate names to cells D17:D20. 3. Set up the structure of a one-variable data table on the Analysis worksheet that shows the car charge, mileage charge, gas expense, and total transportation expense given changes in the average price of gas from $2.20 to $3.80 by increments of $0.20. 4. Instruct Excel to complete the one-variable data table. TROUBLESHOOTING: In order to complete the one-variable data table successfully, be sure to select the correct data table range. If you instruct Excel to complete an incorrect range, you cannot just delete any extra results that might have appeared at the bottom or right of the intended data table area. When you try to do so, you will receive the Cannot change part of a data table error message. You cannot delete only some results from a filled-in data table; you must delete all results values from a onevariable data table if you want to delete any results. 5. Add headings and basic formatting to the data table so it has a more professional appearance. 6. A few rows below the one-variable data table, create the structure for a two-variable data table that shows the total projected transportation expense given the interaction between average gas prices from $2.20 to $3.80 by increments of $0.20 and miles per gallon from 18 to 28 by increments of 2 miles per gallon. 7. Instruct Excel to complete the two-variable data table. 8. Add headings and some basic formatting to the data table so it has a more professional appearance.

Executive Transport, Ine Rental Car Cost Analysis As of June 30, 2016 Customer related Mere $135.00 1015 Transportation Expenses varying Gas Prices Gas Price Car Charge Menge Charge Gaps To Trans 2205 SPOO ES Car Rental Contract Terms Carte When the 20 Gastered troca Porage cost per 200 200 300 130 140 100 1 20 Quote Customer Projected Costs of Carcharge Transportation openen Geset Mies er aller T25 22 Gars 2. 24 pes Treppen Miles Per Galon 18 103 11 100 120 100 101 COLINOS ERNER 20 20 A B Executive Transport, Inc. Rental Car Cost Analysis As of June 30, 2016 Mid-size $185.00 $0.15 Customer-related data Number of weeks renting car Estimated number of miles to drive 2 475 20 $2.85 Car Rental Contract Terms Car type Weekly rental car charge! 3 Charge per mile: 2 0 Gas-related data 11 Average miles per gallon for car 12 Average cost per gallon of gas 13 14 15 16 Quote Customer Projected Costs of: 17 Car charge 18 Mileage charge 19 Gas expenses 20 Total projected transportation exp 21 $ 370.00 71.25 67.69 508.94 Transportation Expenses at Varying Gas Prices Gas Price Car Charge Mileage Charge Gas Expenses Total Trans Exp 2.20 5 370.00 $ 71.255 52 25$ 493.50 2.40 260 2 80 3.00 3.20 3.40 3.60 3.80 Transportation Expenses at Varying Gas Prices and Miles Per Gallon 2.40 $ 504 5833333 2.60 5 509.8611111 Gas Prices 2.80 $ 3.00 $ 3.20 $ 3.40 $ 3.60 $ 3.80 515.1388889 520.4166667 525.6944 530.9722 536 25 541.5278 Miles Per Gallon $ 2.20 $ 18 499.3055556 20 22 24 26 28 Executive Transport, Ine Rental Car Cost Analysis As of June 30, 2016 Customer related Mere $135.00 1015 Transportation Expenses varying Gas Prices Gas Price Car Charge Menge Charge Gaps To Trans 2205 SPOO ES Car Rental Contract Terms Carte When the 20 Gastered troca Porage cost per 200 200 300 130 140 100 1 20 Quote Customer Projected Costs of Carcharge Transportation openen Geset Mies er aller T25 22 Gars 2. 24 pes Treppen Miles Per Galon 18 103 11 100 120 100 101 COLINOS ERNER 20 20 A B Executive Transport, Inc. Rental Car Cost Analysis As of June 30, 2016 Mid-size $185.00 $0.15 Customer-related data Number of weeks renting car Estimated number of miles to drive 2 475 20 $2.85 Car Rental Contract Terms Car type Weekly rental car charge! 3 Charge per mile: 2 0 Gas-related data 11 Average miles per gallon for car 12 Average cost per gallon of gas 13 14 15 16 Quote Customer Projected Costs of: 17 Car charge 18 Mileage charge 19 Gas expenses 20 Total projected transportation exp 21 $ 370.00 71.25 67.69 508.94 Transportation Expenses at Varying Gas Prices Gas Price Car Charge Mileage Charge Gas Expenses Total Trans Exp 2.20 5 370.00 $ 71.255 52 25$ 493.50 2.40 260 2 80 3.00 3.20 3.40 3.60 3.80 Transportation Expenses at Varying Gas Prices and Miles Per Gallon 2.40 $ 504 5833333 2.60 5 509.8611111 Gas Prices 2.80 $ 3.00 $ 3.20 $ 3.40 $ 3.60 $ 3.80 515.1388889 520.4166667 525.6944 530.9722 536 25 541.5278 Miles Per Gallon $ 2.20 $ 18 499.3055556 20 22 24 26 28