$\backslash$table$[[$Date Sold,Salesperson,Destination,Tickets Sold,,$],[\frac{2}{15}\frac{?}{22},$Lisa,France $($Paris and Nice$),3,,],[\frac{3}{4}\frac{?}{22},$Bob,Hungary and Poland,$2,,],[\frac{1}{28}\frac{?}{22},$Lisa,Thaland or Indonesia,$4,,],[\frac{1}{15}\frac{?}{22},$Bob,Japan,$2,15,],[3\frac{}{22},$Vwien,India,$3,,1],[2/1/22,$John,Middle East $($UAE$,$ Qatar and Oman$),1,,],[\frac{3}{6}\frac{?}{22},$Andrew,Egypt and South Africa,$1,,-3],[2/11/22,$Bob,India,$2,,],[\frac{2}{9}\frac{?}{22},$John,Egypt and South Africa,$2,,],[1/19/22,$John,Thaliand or Indonesia,$3,,],[\frac{1}{30}\frac{?}{22},$Heather,Hungary and Poland,$3,,],[\frac{2}{27122},$Vivien,Middle East $($UAE$,$ Qatar and Oman$),4,,],[3/14/22,$John,Japan,$3,,],[\frac{2}{13}\frac{?}{22},$Lisa,Japan,$2,,],[\frac{3}{2}\frac{?}{22},$John,France $($Paris and Nice$),1,,],[\frac{3}{29}\frac{?}{22},$Lisa,Egypt and South Africa,$2,,],[3/17/22,$John,India,$4,,],[\frac{1}{22}\frac{?}{22},$Vien,Thailand or Indonesia,$6,,],[\frac{215}{22},$John,Hungary and Poland,$2,,],[\frac{3}{10}\frac{?}{22},$Vivien,France $($Paris and Nice$),1,,],[\frac{3}{7}\frac{?}{22},$Vivien,Egypt and South Africa,$2,,],[\frac{22}{22},$Lisa,India,$3,,],[\frac{1}{23}\frac{?}{22},$Vivien,Hungary and Poland,$1,,],[\frac{3}{4}\frac{?}{22},$Andrew,Middie East $($UAE$,$ Qatar and Oman$),3,,],[\frac{1}{2}\frac{?}{22},$Andrew,Japan,$2,,],[\frac{1}{19}\frac{?}{22},$Andrew,France $($Paris and Nice$),2,,],[\frac{1}{2}\frac{?}{22},$Bob,France $($Paris and Nice$),1,,],[\frac{3}{13}\frac{?}{22},$Lisa,Hungary and Poland,$3,,],[\frac{2}{1}\frac{?}{22},$Lisa,Middle East $($UAE$,$ Qatar and Oman$),3,,],[3/17/22,$Vivien,Japan,$3,,],[3/12/22,$Bab &$,$Egypt and South Africa,$2,,],[\frac{2}{11}\frac{?}{22},$Andrew,India,$1,,],[\frac{2}{19}\frac{?}{22},$Bob,Middis East $($UAE$,$ Qatar and Oman$),2,,],[2/19/22,$Heather,Egypt and South Africa,$1,,],[3/16/22,$Heather,Thaliand or Indonesia,$1,,]]$

Module $1$: Spreadsheet Application: Ticket Sales at Campus Travel

The local travel center, Campus Travel, has been losing sales. The presence of online ticketing websites, such as Travelocity com and Expedia com, has lured many students away. However, given the complexity of making intemational travel amrangements, Campus Travel could have a thriving and profitable business if it concentrated its efforts in this area. You have been asked by the director of sales and marketing to help with analyzing prior sales data to design better marketing strategies. Looking at these data, you realize that it is nearly impossible to perform a detailed analysis of ticket sales given that the data are not summarized or organized in a useful way to inform decision making

This spreadsheet contains the ticket sales data for a $3-$month period, Your director has asked you for the following information regarding ticket sales.

Modify the TicketSales csv spreadsheet to provide the following information:

In cell $H2,$ calculate the total number of ticket sales sold

i$.$ Use the "SUM" function to calculate the total number of tickets sold $$

In cell H$3,$ calculate the largest amount of tickets sold by a certain salesperson to any orie location i$.$ Use the "MAX" function to calculate each salesperson's highest ticket total in one transaction

In cell H$4,$ calculate the least amount of tickets old by a certain salesperson to any one location L$.$ Use the "MIN" function to calculate each salesperson's least tickets sold

In cell H$5,$ calculate the average number of tickets sold i$.$ Use the "AVERAGE" function to calculate the average number of all of the tickets sold