# Beginning Excel Exercise 2 solution by cuiliqing

VIEWS: 6 PAGES: 2

• pg 1
```									             Adam's Travel - 2008
Minneapolis
1/18/08 -        Seattle            January
1/20/08          1/22/08 - 1/26/08 Total
Mileage        \$       71.25    \$           95.00
Parking        \$       37.00    \$          200.00
Hotel          \$     300.00     \$          400.00
Meals          \$     150.00     \$          200.00
Airfare        \$     300.00     \$          500.00
Rental Car     \$         -      \$          250.00
Misc.          \$       50.00    \$          150.00
TOTALS         \$     908.25     \$        1,795.00 \$ 2,703.25

Average cost
per trip     \$     1,351.63
Mileage      \$        0.475

C:\Docstoc\Working\pdf\3e18400c-436f-4f5a-97f2-f80d55a7af04.xlsx   8/20/2012 2:47 PM2:47 PM
Martha's Travel - 2008
Phoenix     Total for
1/1/08 - 1/4/08 January
Mileage        \$         71.25
Parking        \$         50.00
Hotel          \$        600.00
Meals          \$        150.00
Airfare        \$        400.00
Misc.          \$        250.00
TOTAL          \$      1,521.25 \$ 1,516.75

Mileage rate   \$        0.475

```
To top