Question

Question Set 1. A manager has tracked days worked and Pizzas sold as given below. 1. For each cashier, compute his or her overall productivity (in Pizzas sold per day)

for Spring and Summer. You should have one number per cashier, (3pts) 2. For each cashier, compute his or her productivity (in Pizzas sold per day) for Autumn. Using the MAX function, find the highest productive cashier for the Autumn among the cashiers.(3pts) 3. Compute the overall productivity for each cashier (in Pizzas sold per day) for the entire year. 4. Which month has the lowest overall productivity? (2 pts)

Question image 1Question image 2Question image 3Question image 4Question image 5Question image 6