Project Description: The purpose of this assignment is to work on the MS Excel features and functionality.

Create a Vacation Travel Expenses Report for a 7-day vacation of your choice. Your flyer MUST have the project constraints described below. 

Project Constraints:

1.  
   • Save your Excel workbook with your last name and the word TravelExp added, for example, Smith_TravelExp

•  
  • YourLastName_TravelExp 

1.  
   • The title and description of your destination are merged and centered over your expenses with a picture to the left or right of the centered title.  (see sample below “Worksheet Sample 1” ) 
2.  
   • Expense Sheet MUST include the following:

Transportation 

• to and from the destination of your choice (plane, bus, train, or car) 
• If driving you must include the amount (cost) of gas, miles of trip and the miles/gal car uses 
• Car Rental or Taxi/Uber service used during vacation (Total amounts using formulas)

 

Lodging

• Name of hotel
• Cost per night
• Total Amount using formulas 

 

Food 

• Insert two or more pictures (stock images) of meals or food that are related to the types of restaurants that you chose 
• List Restaurants you will eat at – a minimum of 3 nice restaurants at your destination with a total cost of meals using formulas 
• Amount of All other food broken down by each day for breakfast, lunch, and dinner.  You may include breakfast with as shown below in Worksheet Sample 1 if your hotel includes breakfast, you may only do this with breakfast.Lunch and Dinner MUST be listed for each day, except for day one and day seven depending on your arrival, hence you may only include lunch or dinner on those days – see sample spreadsheet below “Worksheet Sample 1”. 

 

Activities 

(both Free and Others with costs listed)

• You must list your activities for each day (totaled for each day with formulas)  

 

Souvenirs

• All calculations must be done using formulas and cell references (see the second picture “Worksheet Sample 2” below showing formulas used to calculate amounts using formulas). 

For your assignment, create an MS Excel spreadsheet that meets the following Content Requirements: 

• Include your Vacation Expenses.  
• Make sure to use the formulas, such as addition, subtraction, multiplication, average, and so on. Please provide the syntax in the field, such as “A2 + B2.”
• Create borders for vacation.
• Ensure that some of the content is centered, right-aligned, and left-aligned.
• Use different fonts and font sizes.
• Use shading to highlight any part of your vacation.

Last name is Pardo