Excel - task num.1:
The average fuel consumption and cost of 1 km traveled

In this lesson:

The main This lesson aims is to introduce students with basic statistical functions and calculation of fuel consumption and cost of gasoline per 1 km. Every entrepreneur or employee who uses a company car, must keep a logbook. In this book, it is necessary to keep the information where and when they went with that car, when and how much gasoline or diesel fuel purchased and how much it cost to buy these fuels (fuel) and what the cost of 1 kilometer.

File: zadani-prikladu-1-en.xls

Tasks

1. Calculate the average fuel consumption and cost of 1 km traveled.
2. The head table accompaniment, text and align it wrap to  centered horizontally and vertically.
3. Enclose table.
4. Calculate the number of kilometers for each day.
5. cumulative km traveled - in the first row is the same as the number of km on a given day (in cell H20 will be "G20 = ') and the second line, the value increases the number of miles traveled in the next day (in cell H21 will be" = H20 + G21 ").
6. Average consumption rounded to 2 decimal places.
7. When driving more than 100 km per day, this value accompaniment for red.
8. If driving less than 50 km per day, this value accompaniment yellow.
9. The head table accompaniment, text and align it wrap to  centered horizontally and vertically.

Explanation of Terms and Abbreviations:

1. PS tachi. (initial odometer reading) = odometer reading at the beginning of the ride
2. KS tachi. (the final odometer reading) = odometer reading at the end of his journey
3. cumulatively - ie. increasing manner
4. purchase of fuel in the lt. - Purchase of fuel in liters.