Exotic Vacation Project Research and plan a vacation trip for two people. You will have up to $5000 to spend during your vacation. This includes everything: food, beverages, gas, souvenirs, etc. You can go anywhere, to do anything (keep it clean :) ), for any length of time within your price range. Try to find the best deal to have the best vacation for the price. You will put 3 different vacation packages together and then choose the one that you would like to use and why. You will schedule this vacation within the months of May, June, July or August. You must decide the needed information that is important to your trip. Every place will be a little different. You will need to make sure that you have enough information available to implement your functions into the project. This may also mean that you will have to continue to add pieces of information throughout the project in order to implement new concepts from the upcoming chapters. Please provide sources from where you have found your information that is time sensitive. For example, you will need to have documentation about flights and / or hotels because prices change on a regular basis. Post this in your spreadsheet or use comments. You will have $5000 dollars to spend on this vacation; however, you will be taking a loan from the bank for $3000. You will have an annual compound interest rate of 5.5%. You will make one payment per month. You will have to determine how long it will take you to pay the loan off and what your total interest will be for the loan. You will need to use the features listed below from each chapter. Use your textbook and any other resources that you may have to assist you with this project. (This is not a group project. Please do not copy off of other students.) This will be your final project due at the end of the semester on Finals Day, by the end of the class period. Submit to the drop box called "Vacation Project - Final". Chapter 1 - 3 Chapter 5 - 6 Formatting Grouping Worksheets Themes Referencing Cells Sum & Average Functions Linking Worksheets Relative and Absolute Cell References Hyperlink Maximum / Minimum Function AND Function / OR Function If Statement Nested If Statement Lookup Table (Horizontal / Vertical) Chapter 4 - 5 IFERROR Function Payment Function Chart Chapter 7 Table Defining Names Pivot Table Data Validation Filtering / Sorting (determine & demonstrate best vacation) Comments (Add to cells containing Data Validation) Macros Set Print Area