Applied Lab

As a project manager for a space robotics company, you need to put together a preliminary project plan to design an unmanned flight control system. Perform the following actions:

On the Schedule sheet, in cell F$4,$ use a formula to enter today's date.

On the Schedule sheet, in cell B$16,$ enter a formula to calculate the completion date using TODAY$()$ as the start date, the sum of cell C$8$ and cell C$16$ as the days, and the name Holidays.

On the Schedule sheet, in cell B$8,$ enter a formula to calculate the completion date using cell F$5$ as the start date, minus the sum of cell C$16$ and cell C$23$ as the days, and the name Holidays.

On the Schedule sheet, in cell F$6,$ use the WEEKDAY$()$ function to display the day of the Project Start Date in cell F$4.($Note: $1=$ Sunday, $2=$ Monday, $3=$ Tuesday...$)$

On the Log sheet, in cell B$5,$