Spreadsheet Applications: Ticket Sales and 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 complex city of making international travel arrangements, campus travel could have the eight driving in profitable business if they concentrate their efforts in this area. You have been passed by the director of sales and marketing to help with analyzing prior sales data in order to design better marketing strategies. Looking at these data you realize it is nearly impossible to perform a detailed analysis of ticket sales given that it is not summarized nor organized in a useful way to inform business decision-making. The spreadsheet TicketSales.xls contains the sales that ticket sales data for spring 2006. Your directory has asked you the following information regarding ticket sales. Modify the TicketSales.xls spreadsheet to provide the following information to your director:
1. The total number of tickets sold for teach month.
a. Select the data from the ticket sold column.
b. Then select the alter some function
2. The largest amount of tickets sold by a certain salesperson in any one location.
a. Select the appropriate sale.
b. Use the “M. A. acts” function to calculate each salesperson’s highest ticket total in one transaction.
3. The least amount of tickets sold by a certain salesperson to any one location.
a. Select the appropriate cells.
b. Use the man function to calculate the “least tickets sold.”
4. The average number of tickets sold
a. Select the cells
b. Use the “average” function to calculate the “average number of tickets sold” using the same day that you had selected in the previous steps.
Back to top