Module 05 Written Assignment – Tables in Spreadsheets

You have been hired by a movie studio to determine the success of last year’s movie projects. The success will be determined by how much money the studio’s movies made at the box office as compared to the budget that was spent to make the movies.

For this module’s assignment:

• Conduct some independent online research on a major movie studio of your choice and on some of the movies it made in the last year.
• Be sure to locate the budget (cost) of at least five key movies as well as the amount of money these movies earned. Hint: This information can be found by firing up your favorite Internet search engine.
• In an Excel spreadsheet, create a table that shows:
• The title of each movie
• The director of each movie
• The date each movie premiered
• The genre of each movie (use your best guess if you’re not sure)
• The budget cost of each movie
• The amount of money each movie earned
• Add a filter that allows each of the table’s data columns to be sorted.