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 salesperson’s highest ticket total in one transaction. ■ The least amount of tickets sold by a certain salesperson to any one location. a. Select the appropriate cells. b. Use the "MIN" function to calculate the "least tickets sold." ■ 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 data you had selected in the previous steps.