*************All 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 Jane Feb Days Worked Spring Summer Autumn Mar Apr May Jun Jul Aug Sep Oct Nov 29 20 12 8 13 Deca 24 314 13 184 28 124 194 ] 1544 Seasons Cashiere Linda Bob Gene Tina Louise Teddy 19 15 24 204 19 6 19 11 e 26 21 17 26 31 [ 19 2342 234 124 15 224 e T.T.T.T. 1 TT Winter Dec Donuts Sold Winter Spring Summer Autumn Jan Feb Mare Apr May Jun Jul Aug Sep Oct Nov 3784 e 124 5721 234 e 215 1624 e 294 701 289 388 276 27 38 4474 414 72 139 2644 J 345 ] 396 2964 264 252 Seasons Cashiere Linda Bobe Genee Tina Louise Teddy 1364 5454 2764 4344 4124 a 27844 5724 e 454 e 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)