Project: Advanced Spreadsheet ProcessingDescription
1.You can find movie information at https://www.imdb.com/chart/top
2.Create a new MS Excel spreadsheet and enter the following information about ten movies of the last
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
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.
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
decade (2003-2012) with the highest IMDB rating:its Gross to Budget ratio is greater than 2.