Compute the monthly cost of gas.


a. in cell c21, enter a formula to calculate the number of miles you expect to drive each month. divide the value of number of miles (cell a5 from the data sheet) by the average mpg for the vehicle multiplied by the price of a gallon of gas (cell a6 from the data sheet).

Respuesta :

Answer:

Attached excel file containing formula for monthly cost of gas.

Explanation:

To find mileage note down readings at the star of month and at end of month.

Subtract end of month reading from start this will give you number of miles in month. Now as per mentioned in question, divide number of miles by average mpg and multiply by the price of a gallon of gas.

Here is your monthly cost of gas.

Ver imagen usamasama