Please note that this individual assignment. Part 1: Using the provided excel workbook TicketSales, answer the application exercise 1-34, page 70. For those who didn't get their books yet, the following image is a copy from the book. Application Exercises No. The existing data files reference in the exercises we will the Spreadsheet Application: Ticket Sales at Campus Travel 1-34. 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 mak- ing international travel arrangements, Campus Travel could have a thriving and profitable business if it con- centrated its efforts in this area. You have been asked by the director of sales and marketing to help with an lyring prior sales data in order to design better market- ing 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 business decision making. The spreadsheet Ticket Sales.csv 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.es spreadsheet to provide the following information for your director: The total number of tickets sold a. Select the data from the tickets sold" column b. Then select the autosum" function The largest amount of tickets sold by a certain salesperson to any one location a. Select the appropriate cell b. Use the "MAX" function to calculate each sales person's highest ticket total in one transaction, The least amount of tickets sold by a certain sales person to any one location. a. Select the appropriate cells. b. Use the "MIN" function to calculate the least tickets sold." Part Two: A. Define data-the most basic element of an information system. B. Referring to the TicketSales excel workbook, give an example from one of the columns available