DETERMINE FUEL CONSUMPTION USING MICROSOFT EXCEL

In a worksheet, fuel consumption data is recorded. Each time you refill your gas tank, record the following data: date, miles traveled, and gallons purchased. Then reset the mileage counter. To calculate the fuel consumption of your vehicle, perform the following steps:

To determine fuel consumption:

1. In a worksheet, enter your own data or the data shown in Figure 1-6.
2. Select cells D5:D10.
3. Enter the following formula: =B5/C5.
4. Press <-Ctrl+Enter->.

DETERMINE FUEL CONSUMPTION USING MICROSOFT EXCEL

Watch the Video Tutorial


Microsoft Excel Tutorials, Determine Fuel Consumption Using Microsoft Excel, Microsoft Excel Video Tutorials, Macros, VB Scripts