Question
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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started