Start Excel. Open the downloaded file named Excel$\_$CH$10\_$PS$1\_$FrontDesk xlsx$.$ Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.

$2$ The FrontDeskShifts worksheet contains a template for the next two day schedule. The employee preferences are listed in the table in cells C$8$:G$12.$ Cells C$15$:G$19$ contains a template for two days' worth of shifts at the front desk. These cells should contain a $1$ if a given employee from column $C$ works a shift and a $0$ if they do not. This range will need to be changed to fulfill the scheduling needs.

Each employee must be scheduled to work two shifts over the course of the schedule. In cell H$16,$ enter a formula that will calculate the total number of shifts from cells D$16$:G$16.$ Copy the formula down to cell $H19.$