$1.$ Use the slicers to select only the movies from the Animation, Adventure, or Action genres that were released in $2011,2012,$ or $2014.$ Copy the filtered data, including the column headers, and paste the results on the SelectedMovies worksheet, starting in cell A$1.$

$2.$ On the Movies worksheet, in cell B$1,$ enter a function that will calculate the total gross sales for records visible in the table. Format as Accounting. In cell B$2,$ enter a function that will calculate the average gross sales for records visible in the table. Format as Accounting. In cell B$3,$ enter a function that will calculate the number of movies visible in the table, using the MovieID field.

$3.$On the Directors worksheet, in cell D$2,$ enter an IFS function that will determine the status of each director, based on the following conditions. A director is considered Elite if they have directed at least $15$ movies with an average score that is greater than $6\mathrm{.}5$ or has an average score of greater than $6\mathrm{.}8$ regardless of the number of movies. A director is considered Premiere if they have directed at least $5$ movies with an average rating of at least $6.$ All other directors should have a status of Standard Copy the formula down through cell D$28.$