The below table shows the data from a specific Travel Agent:

Create the table above and Answer the following Questions using an excel sheet:

1. Show the total number of holidays covered by each Travel method and rename the worksheet as 'Sheet 1'.
2. Show the distribution of Prices for each country according to the travel method and rename the worksheet as 'Sheet 2'.
3. Show the distribution of the total number of holidays for each country according to the resort and rename the worksheet as 'Sheet 3'.
4. Plot a suitable chart including the Total Price from specific countries according to the travel method. Explain the type of chart you picked and why? Compare if necessary with the recommended chart of Excel.

Complete the table using the appropriate Conditional Functions as follows:

5. (Discount amount / Day) Column: is 10% if the number of days is more or equal to 10 and the price is over 200, otherwise return “No Discount”.
6. (Early Check-in) Column: Show “Required” if traveling by plane or the number of days is more than 20, Otherwise return “Not Required”.

 

  

Country Australia Australia Chile England England France France France France France France Germany Germany Peru Saudi Arabia Spain Wise Owl Travel Agents Resort Name Great Barier Reef Perth Santiago London Bognor Ly on Paris Euro Disney Paris - Euro Disney Nice Toulouse Nimes Black Forest Berlin Lima Riyadh Barcelona No of Days Travel Method Price/Day Discount / day 32 750 28 985 21 3 1 14 5 3 7 7 7 4 7 21 14 4 Plane Plane Plane Train Coach Plane Train Train Plane Train Plane Coach Coach Plane Plane Train 1,259 69 12 399 269 125 289 256 287 69 289 975 995 219 Early Check in