what formulas should be used?

ce Paste BIU lil Merge & Center $ % ) Conditional Format Cell Formatting as Table Styles 211 xfx O F G M Fair Trade Restoration - Employee Schedule Schedule for the week of November 12.1.2018 Mon Sat Total Shifts Total Hours Notes Canon Tuesday through Saturday Can't work Wednesday O Employee Han, Marcus Lofer Slot Ne Victor Peterson, Glor Torre, Clinton Urdo Mar VochtShe Walton, Pearl Aron Gal Gen, nor Status Full time Futime Futime Fatime Rutine time Sun 0 0 0 o O 0 0 0 0 0 Cant work Mond Can't work Monday Tuesday Tue 0 0 0 0 0 0 o 0 0 o Thu D 0 0 0 0 Wed 0 0 0 0 0 O D O 0 O Fri 0 0 0 O 0 0 0 0 0 0 Cant work Sunday 0 O 0 0 O 0 0 Pultime Part.me Parte D 0 0 0 O 0 0 0 0 0 Cant wor The 0 Employees Teguired Employees Scheduled Difference Tot Short She Solver HR head Ryan Hernandez needs to create a weekly shift schedule for FTR retail employees. The FTR stores employ 10 people. Eight are full-time, two are part-time. The stores need five people working each weekday, eight people on Saturday, and six people on Sunday. Ryan needs to complete the shift schedule, taking into account employee needs. I 1. Navigate to the Schedule worksheet in the Fair Trade Restoration HW10 Submission file. 2. You will use the numbers 0 and 1 to indicate whether or not an employee is scheduled to work. O = employee not scheduled to work that day 1 = employee scheduled to work that day To prepare the schedule for completion, navigate to the Schedule worksheet, and enter O in each cell from D6:J15. 3. In K6, enter a formula that adds up the total number of shifts Marcus Han is assigned. Drag that formula down through K15. At this point, the schedule should reflect that every employee is assigned to O shifts. 4. In L6, enter a formula that displays the total number of hours Marcus is working that week. Each shift is 8 hours long. Drag that formula down through L15. 1 5. In the range D17:J17, enter the number of employees required per day. FTR needs five people working each weekday, eight people on Saturday, and six people on Sunday. 6. In D18, enter a formula that displays the total number of employees scheduled for Monday. Drag this formula across to J18, so that the row displays the total number of employees scheduled every day that week. At this point, the schedule should reflect that every day has 0 employees scheduled