Mt. Eden Computer Applications I Class

MS Excel Assignment 5...

Welcome to Palm Springs California!

Complete the following exercise:

1. Download this file: Travel Expense Report.xlsx
   
   There is a copy in google classroom too.
   
   Use the following information to fill out the Expense Report:
   
   
2. You are an employee of the X-Y-Zee Corporation at 2300 Panama Street in Hayward, California 95454, 510-786-2269. You work in the "Period-X" Department (where X is your class period number).
   
   
3. Your manager Mr. Lavendel has sent you to the CUE Conference in Palm Springs to talk to teachers about the X-Y-Zee new line-up of products. He is the one that must approve your expenses.
   
   
4. Counting your travel to get there and back you were gone for 5 days: from March 16 to March 20, 2024. So you will have to add a new row to the expense report.
   
   
5. You stayed four nights at the Bates Hotel, in a single king room for $195.85 a night.
   
   
6. To get there you drove your car 36 mile each way to and from the airport (you get reimbursed $0.65 per mile), you parked it there for $8.99 a day (under Misc) and flew on Southwest Airlines to Palm Springs. The flight cost you $438.63 round trip. For the five days you had a rental car at $45.88 per day.
   
   
7. You were allowed $12 for breakfast, $21 for lunch and $28.50 for diner. The first travel day was lunch and diner only and the return day only breakfast and lunch.
   
   
8. The CUE Conference registration and fees were $1576.27 payed the first day.
   
   
9. Everything you spent was in US currency, so use the abbreviation USD for US Dollars .in the expense currency column and 1-to-1 Exchange rate of 1.00.
   
   
10. To see the finished report,
    click on Figure 2 ==>
    
    
11. Done. SAVE AND TURN IN YOUR DOCUMENT.

 

WHEN YOU ARE DONE...

TURN IN THE COMPLETED FILE THROUGH GOOGLE CLASSROOM.

 

This assignment is worth 35 assignment points.