If you could take a look at this please? I have up to number 5 done but am stuck on the rest.
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 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.
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
Attachment:- Copy of week 5 movie project.xlsx