Excel,Access, PowerPoint

Software Capstone Excel Assignment Page 1 of 3

Excel Assignment Michael Feinbaum is a production manager for Canvas Scribe, a manufacturer of digital games. To produce

and release a quality game requires a team of programmers, animators, writers, and testers. Typically, a game

will take a year to develop from its initial planning stages to final release. Michael wants to create a

production schedule for a new game called Escape from Dunkirk, to be released in time for holiday sales. To

create this production schedule, you will use the WORKDAY and NETWORKDAYS functions

WORKDAY function: Returns the workday after days workdays have passed since the start_date; to

exclude holidays, add the optional holidays argument containing a list of holiday dates to skip

NETWORKDAYS function: Calculate the number of working days between two dates. Start_date

is the starting date, end_date is the ending date, and holidays is an optional list of holiday

dates to skip.

Complete the following:

1. Open the Capstone_Excel_DataFile.xlsx workbook, and then save the workbook as

Capstone_Excel_YourName.xlsx.

2. In the Documentation sheet, enter your name in cell B3. Enter a function to enter the current date in

cell B4.

3. In the Production Schedule worksheet, in cell B4, enter 9/12/2021 as an initial proposed start date for

the project.

4. In cell B10, enter the formula =b4 to reference the start date you entered in cell B4.

5. In cell C10, calculate the date on which the Idea Development phase ends using the WORKDAY

function. Use cell B10 as the starting date, cell D10 as the number of workdays, and the range

$H$10:$H$29 as the reference to the holiday dates.

6. Use AutoFill to extend the formula in cell C10 to the range C10:C28 but do not extend the formatting.

7. In cell B5, enter the formula =b28 to display the date on which the game will be released.

8. In cell B6, use the NETWORKDAYS function to calculate the total number of working days that will be

devoted to creating the Escape from Dunkirk game. Use cell B4 as the start_date, cell B5 as the

end_date, and the range $H$10:$H$29 as the holidays argument.

9. In cell B7, calculate the total number of calendar days devoted to the project by taking the difference

between the release date and the start date.

Software Capstone Excel Assignment Page 2 of 3

10. The game must be released no later than 10/12/2022 to take advantage of holiday sales. Use Goal Seek

to determine the starting date that will meet this goal by entering cell B5 in the Set cell box, the date

10/12/2022 in the To value box, and cell B4 in the By changing cell box.

11. In cell D4, write a summary of your findings in developing this production schedule including the new

start date and how many days the project will take.

12. Save the file and submit to Blackboard.

Intentionally

Hidden

Software Capstone Excel Assignment Page 3 of 3