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:
|
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 |