Q. Which countries produced the most number of movies?

6. in another worksheet called "Countries". Copy and paste a distinct listing of countries from the raw data. Use a formula learned in class to count the total number of movies made by the particular country, make sure to use the appropriate named range in your equation.in another column called "Ranking by Count" and use a function learned in class to rank the countries by their respective count.Which Countries were in the top 5 based on quantity of movies produced?

10pts

Note: Do not use pivot tables.

Q. Which countries had the largest gross revenue and biggest movie budgets?

7. In the same Countries worksheet, use another formula learned in class to bring in the Total Gross Revenues and Total Budgets of all movies by country. Again make sure to use the appropriate named range in your equation. Create two additional columns called "Ranking by Gross Revenue" and "Ranking by Total Budget" and use a function learned in class to rank the countries by each measure respectively. Doesthe countries inyour top 5 change from the total revenue versus the budget total?

10pts

7a. Describe the issue that is present in number 7 and describe how you would go about solving it.

5pts

Note: Do not use pivot tables.

Q. How many movies was each actor in?

8. In a new worksheet called "Actors", in unduplicated listing of all actors (from columns actor_1_name, actor_2_name, actor_3_name) in 1 column. Sort the column from A-Z. Use a function learned in class to count the total number of movies each actor appears in (regardless of whether they are in column they are in).

10pts

8a. in a new column called "Flag" and insert an equation that "Flags" the actor if they appeared in more than 25 films. Filter the table by this "flag". insert another function learned in class to count the number of actors who appeared in 30 movies or more.

10pts

Note: Do not use pivot tables.

Q. How many movies did each director make by year within the US?

9. Use the pivot table feature in Excel to help you answer this problem.

In a new worksheet called "Directors", insert a pivot and filter it by: Year >= 2010 and Country = USA. Include the director_name as your first column and additional column names for each of the years from 2010 - 2015. Next bring in the Primary Key field (that you created in Step 1) as your value to be counted foreach director in each year respectively. insert a Total column and Total row to sumthe data accordingly.

10pts

Note: Do not use equations.