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.

Fill in the following program so that it will correctly calculate the price of the orange juice the user is buying based on the buy one get one sale.#include //main functionint main() { int cartons; float price, total; //prompt user for input information printf("what is the cost of one container of oj in dollars? \n"); scanf(" [ select ] ["%d", "%c", "%f", "%lf"] ", & price); printf("how many containers are you buying? \n"); scanf(" [ select ] ["%d", "%c", "%f", "%lf"] ", & cartons); if ( [ select ] ["cartons / 2", "cartons % 1", "cartons % 2", "cartons % price", "cartons / price", "cartons / total"] [ select ] ["=", "==", "! =", "< =", "> =", "< "] 0) total = [ select ] ["price * cartons", "cartons * price / 2 + price", "(cartons / 2) * price", "cartons / (2.0 * price)", "(cartons / 2.0) * price + price", "((cartons / 2) * price) + price"] ; else total = ((cartons / 2) * price) + price; printf("the total cost is $%.2f.\n", total); return 0; }