Question: Q 2 ( 3 point ) : Create a copy of the Movie _ Data worksheet and put it directly after this worksheet, rename your

Q2(3 point): Create a copy of the "Movie_Data" worksheet and put it directly after this worksheet,
rename your copy as "Q2-worksheet", work on "Q2-worksheet" according to the following requirements.
Q2a (2 point): Create an Excel Table for the whole data set. Then,
Create Slicers for "original_language" and "major_production_countries"
In the Slicers, choose "en" in "original_language", and choose "FR" and "MX" in "major_production_countries".
Sort with descending order of "popularity"
Q2b (1 point): Click the "Total Row" feature. Then,
show the maximum popularity, revenue and vote_average of these movies. Change the name of this row to "Max Row".
Q3(2 point): Create a copy of the "Movie_Data" worksheet and put it directly after this worksheet,
rename your copy as "Q3-worksheet", use "Q3-worksheet" to answer the following question.
In cells A8:A12, list 5 Drama movies with highest vote_average among all the movies that are
released in the summer season (in July, August, or September), and have revenue more than $10,000,000.
Hint: In order to get movies that are released in summer, it might be easier to create a new column to the dataset,
and use some date functions you learn in previous lectures to capture the month of release date.
 Q2(3 point): Create a copy of the "Movie_Data" worksheet and put

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!