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, $k_s$ s lured many students away. However, given the complexity of making nternational travel arrangements, 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 one location

i$.$ Use the "MAX" function to calculate each salesperson's highest ticket total in one transaction