Complete the tables on the Next50WorkDays worksheet by completing the tasks. Refer to the "Federal Holidays" table when needed to determine when there will be work holidays. Calculate the weekday number for the date in cell a. Place your calculation in cell b. Reuse your formula to calculate the remaining weekday numbers in the column. (5.2) Calculate the name of the day of the week for the date in cell (B3). a. Place your calculation in cell (D3). b. Use the CHOOSE function. c. Label the days of the week as "Sun", "Mon", "Tues", "Wed", "Thurs", "Fri", or "Sat". d. Reuse your formula to calculate the remaining weekday names in the column. (5.3) Suppose that a payday can only be on a weekday (Monday-Friday). For any payday on a weekend return the next workday as the new payday. a. Place your calculation for the first "Payday" in cell b. Reference the Payday. c. Since the Payday was carefully selected to avoid federal holidays, you do not need to reference the table of federal holidays. d. Reuse your formula to calculate the remaining paydays in the column. (5.4) Calculate the first workday based on the project start date in cell (H3). a. Place your calculation in cell b. The first workday will be the start date unless the start date is a weekend day, in which case it will be the next workday. c. Be sure to consider any federal holidays when calculating the next workday. 5.5) Calculate the remaining workdays. a. Place your calculation for the next workday in cell b. Be sure to take into account the Federal Holidays. c. Reuse your formula complete the remaining calculations in the column. (5.6) Calculate the name of the day of the week for the workdays. a. Place your calculation for the first workday in cell (16). b. Use a single calculation. (Hint: Use a combination of the CHOOSE and WEEKDAY functions in your calculation). c. Label the days of the week as "Sun", "Mon", "Tues"., "Wed"., "Thurs", "Fri", or "Sat". d. Reuse your formula to complete the calculations in the column. (5.7) Calculate the delivery dates for the orders placed. a. Place your calculation for the first delivery in cell (L4). b. The delivery date will be 5 workdays from when the order is placed. c. Account for any holidays that might fall during a delivery period. d. Reused the formula to complete the calculations in the column