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". Wise Owl Travel Agents \begin{tabular}{|c|c|c|c|c|c|c|} \hline Country & Resort Name & No of Days & Travel Method & Price/Day & Discount / day & Early Check in \\ \hline Australia & Great Bamier Reef & 32 & Plane & 750 & & \\ \hline Australia & Perth & 28 & Plane & 985 & & \\ \hline Chile & Santiago & 21 & Plane & 1,259 & & \\ \hline Engand & London & 3 & Train & 69 & & \\ \hline England & Bognor & 1 & Coach & 12 & & \\ \hline France & Lyon & 14 & Plane & 399 & & \\ \hline France & Paris - Euro Disney & 5 & Train & 269 & & \\ \hline France & Paris - Euro Disney & 3 & Train & 125 & & \\ \hline France & Nce & 7 & Plane & 289 & & \\ \hline France & Toulouse & 7 & Train & 256 & & \\ \hline France & Nmes & 7 & Plane & 287 & & \\ \hline Germany & Black Forest & 4 & Coach & 69 & & \\ \hline Germany & Bedin & 7 & Coach & 289 & & \\ \hline Peru & Lima & 21 & Plane & 975 & & \\ \hline Saud Arabia & Riyadh & 14 & Plane & 995 & & \\ \hline Span & Barcelona & 4 & Train & 219 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|l|l|} \hline Spain & Nerja & 6 & Plane & 198 & & \\ \hline Spain & Malaga & 16 & Plane & 234 & & \\ \hline Spain & Sevile & 14 & Plane & 288 & & \\ \hline Spain & Sevile & 10 & Plane & 199 & & \\ \hline Spain & Barcelona & 8 & Plane & 177 & & \\ \hline Spain & Barcelona & 7 & Coach & 199 & & \\ \hline Spain & Malaga & 14 & Plane & 301 & & \\ \hline Spain & Barcelona & 4 & Train & 219 & & \\ \hline Spain & Sevile & 14 & Train & 299 & & \\ \hline Spain & Madrid & 8 & Plane & 277 & & \\ \hline Spain & Granada & 10 & Plane & 345 & & \\ \hline Trinidad & Part of Spain & 14 & Plane & 885 & & \\ \hline \end{tabular} 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". Wise Owl Travel Agents \begin{tabular}{|c|c|c|c|c|c|c|} \hline Country & Resort Name & No of Days & Travel Method & Price/Day & Discount / day & Early Check in \\ \hline Australia & Great Bamier Reef & 32 & Plane & 750 & & \\ \hline Australia & Perth & 28 & Plane & 985 & & \\ \hline Chile & Santiago & 21 & Plane & 1,259 & & \\ \hline Engand & London & 3 & Train & 69 & & \\ \hline England & Bognor & 1 & Coach & 12 & & \\ \hline France & Lyon & 14 & Plane & 399 & & \\ \hline France & Paris - Euro Disney & 5 & Train & 269 & & \\ \hline France & Paris - Euro Disney & 3 & Train & 125 & & \\ \hline France & Nce & 7 & Plane & 289 & & \\ \hline France & Toulouse & 7 & Train & 256 & & \\ \hline France & Nmes & 7 & Plane & 287 & & \\ \hline Germany & Black Forest & 4 & Coach & 69 & & \\ \hline Germany & Bedin & 7 & Coach & 289 & & \\ \hline Peru & Lima & 21 & Plane & 975 & & \\ \hline Saud Arabia & Riyadh & 14 & Plane & 995 & & \\ \hline Span & Barcelona & 4 & Train & 219 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|l|l|} \hline Spain & Nerja & 6 & Plane & 198 & & \\ \hline Spain & Malaga & 16 & Plane & 234 & & \\ \hline Spain & Sevile & 14 & Plane & 288 & & \\ \hline Spain & Sevile & 10 & Plane & 199 & & \\ \hline Spain & Barcelona & 8 & Plane & 177 & & \\ \hline Spain & Barcelona & 7 & Coach & 199 & & \\ \hline Spain & Malaga & 14 & Plane & 301 & & \\ \hline Spain & Barcelona & 4 & Train & 219 & & \\ \hline Spain & Sevile & 14 & Train & 299 & & \\ \hline Spain & Madrid & 8 & Plane & 277 & & \\ \hline Spain & Granada & 10 & Plane & 345 & & \\ \hline Trinidad & Part of Spain & 14 & Plane & 885 & & \\ \hline \end{tabular}