
Determine fuel consumption
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:
4
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>.
Formulas in Excel 7
1
Figure 1-6