1 Start Excel. Start a new blank workbook and save the file with the name ATP2P3 Movie History…

1

Start Excel. Start a new blank workbook and save the file with the name ATP2P3 Movie History Weeks LastFirst.xls, replacing LastFirst with your last and first name.

1

2

Enter an appropriate title for the worksheet. Change the worksheet tab name to MasterList.

1

3

Create the follow fields:

• Title (of film)
• Genre (the type of film, use at least 3 genre categories like Drama, Comedy, etc.; and only enter one genre pre movie-the most appropriate)
• Year (the year the file was released)
• First Name (of film’s major star)
• Second Name (of film’s major star)
• Availability (where blog member can find the film like Netflix, Prime, etc.)
• Fee (the cost of the streaming service per month, for films with free access put 0)
• Oscar (yes/no, whether or not an Oscar was won by the film or its stars)
• Additional fields (add any other field you fell would be valuable to the blog members)

8

4

Enter data for a minimum of 12 movies.

5

5

Format the list as an Excel table and make formatting changes as needed.

2

6

Sort the list alphabetically by Title, copy the sorted list to a new worksheet. Name the worksheet ByTitle.

3

7

Return to the MasterList worksheet and remove the first sort. Now, sort the list by Genre and then by First Name. Copy the sorted list to a new worksheet. Name the worksheet ByGenre.

2

8

Return to the MasterList worksheet and remove the first sort. Filter the list to display only records for films whose Genre is Drama or Comedy and Year is 2000 or later. Copy the sorted list to a new worksheet. Name the worksheet DramaComedy2000.

2

9

Return to the MasterList worksheet and remove the filter. Sort the list by Genre only and then use the Subtotals to show total fees paid streaming services. Copy the sorted list to a new worksheet. Name the worksheet ByGenreFee.

3

10

Return to the MasterList worksheet and remove the sort. There should be a total of 5 worksheets in the workbook.

3

11

Save the file. Close the workbook and then close Excel. Submit this workbook as well as your Challenge solutions, APT2P1 and ATP2P2 into the Blackboard assignment link.

0