1you can find movie information


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. 1.You can find movie information at https://www.imdb.com/chart/top
  2. 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. 3.Title, Rating, Budget (if available), Gross (if available)
  4. 4.Turn the range of cells into a table
  5. 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. 6.Build a column chart with movie titles as horizontal axis labels and budget/gross as data series
  7. 7.Add (or convert) rating as a secondary axis.
  8. 8.Build a bar chart based on movie gross value
  9. 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

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: 1you can find movie information
Reference No:- TGS01163984

Expected delivery within 24 Hours