**********************problems must be solved using Excel formulas*****************************

Questions Question Set 1. A manager has tracked days worked and Donuts sold as given below. Winter Winter Jan Feb Days Worked Spring Summer Autumn Mar Apr May Jun Jul Aug Sep Oct Nov 29 20 2 12 8 13 Dec 31 284 124 19 184 15 Seasons Cashier Linda Bobe Genee Tina Louise Teddy 19 15 6 19 24 20 194 e 26 210 174 e 114 26 19 234 314 234 e 12 154 22 1. T. Winter Jan Feb 3784 7 Winter Dece e 234 2894 Donuts Solde Spring Summer Autumn Mar Apr May Jun Jul Aug Sep Oct Nov 124 5724 215 162 388 545 276 27 38 4474 414 72 412 139 264 345 396 ] 296 e 264 45 e 252 e Seasons Cashiere Linda- Bob Genee Tinae Louise Teddy 1364 7014 2944 2764 4344 [ [ 2784 5724 T. 1. For each cashier, compute his or her overall productivity (in Donuts 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 Donuts 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 Donuts sold per day) for the entire year. Use the MIN function to find the lowest productive cashier for the year among the cashiers. (3 pts) 4. Which month has the lowest overall productivity? (2 pts)