attached 4 projects

1. You can find movie information at http://www.imdb.com/chart/top

2. Create a new MS Excel spreadsheet and enter the following information about ten movies of the last decade (2003-2012) with the highest IMDB rating:

3. Title, Rating, Budget (if available), Gross (if available)

4. Turn the range of cells into a table

5. Add a new column “Success”. Use logical “IF” formula to fill cells in that column. A movie is successful if its Gross to Budget ratio is greater than 2.

6. Build a column chart with movie titles as horizontal axis labels and budget/gross as data series

7. Add (or convert) rating as a secondary axis.

8. Build a bar chart based on movie gross value

9. Change bar chart style to the one with colored background.

10. Add your name somewhere in the spreadsheet and save your file.

11. Submit CS102_Project6_YourUserName.XLSX.

Requirements

. Table with the highest rated movies of the last decade

. Four specified columns in the table

. Column chart with budget and gross as primary axis

. Movie rating as a secondary axis on the same chart

. Movie rating is a line chart

. Bar chart for movie gross value only

. Bar chart style with background

. Your name added to the spreadsheet