The below table shows the data from a specific Travel Agent: Create the table above and Answer
Fantastic news! We've Found the answer you've been seeking!
Question:
The below table shows the data from a specific Travel Agent:
Create the table above and Answer the following Questions using an excel sheet:
- Show the total number of holidays covered by each Travel method and rename the worksheet as 'Sheet 1'.
- Show the distribution of Prices for each country according to the travel method and rename the worksheet as 'Sheet 2'.
- Show the distribution of the total number of holidays for each country according to the resort and rename the worksheet as 'Sheet 3'.
- 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:
- (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”.
- (Early Check-in) Column: Show “Required” if traveling by plane or the number of days is more than 20, Otherwise return “Not Required”.
Expert Answer:
Question 1 Show the total number of holidays covered by each Travel method and rename the worksheet as Sheet 1 To do this we can use the COUNTIF function The COUNTIF function counts the number of cell... View the full answer
Related Book For 
Posted Date:
