I need step by step solutions for these questions please.

$13.$ Bao decides that he might want to sort and filter the revenue data. Format the range A$5$:F$12$ as a table with headers.

$14.$ Go to the Original Content worksheet, which lists movies and TV shows that VSS is developing itself and indicates whether each project is approved for production. Bao wants to list the approved projects in a separate part of the worksheet.

Use an advanced filter as follows to list these projects in a new range:

a$.$ In cell F$26,$ type Yes as the value to filter on in the criteria range.

b$.$ Create an advanced filter using the Projects table $($range A$1$:F$23)$ as the List range.

c$.$ Use the range A$25$:F$26$ as the Criteria range.

d$.$ Copy the results to another location, starting in the range A$28$:F$28.$

e$.$ Insert a table using the range A$28$:F$36$ as the data and specifying that the table has a header row.

f$.$ Filter the new table to display only data for TV shows.

$15.$ VSS wants to delay the development of dramas that have not been approved because dramas have not been selling well. Bao asks you to identify these projects on the Original Content worksheet.

Add a column to the Projects table and determine which projects meet the criteria as follows:

a$.$ Add a column to the right of the Approved? column.

b$.$ Type Delay? as the column heading.

c$.$ In cell G$2,$ enter a formula using the AND function that includes structured references to display TRUE if a project has a $[$Project Type$]$ of "Drama" and an $[$Approved$?]$ value of $"$No$".$ Fill the range G$3$:G$23$ with the formula in cell G$2$ if Excel does not do so automatically.

$16.$ Bao asks you to identify the projects with budgets of $$25,000$ or more, those with budgets of $$15,000$ or more, and those with budgets less than $$15,000.$

a$.$ In the Budget column $($range E$2$:E$23),$ create a new Icon Set Conditional Formatting rule using the $3$ Symbols $($Circled$)$ indicators.

b$.$ Display the green circled symbol in cells with a Number type value greater than or equal to $25000.$

c$.$ Display the yellow circled symbol in cells with a Number type value greater than or equal to $15000.$

d$.$ Display the red circled symbol in cells with a Number type value less than $15000.$

$17.$ The range I$1$:J$13$ lists project details, including the ID code that VSS producers use to refer to the projects. Bao wants to find a simple way to look up a project name based on its ID$.$

Create a formula that provides this information as follows:

a$.$ In cell J$3,$ begin to enter a formula using the VLOOKUP function.

b$.$ Use the Project ID $($cell J$2)$ as the lookup value.

c$.$ Use the Projects table $($range A$2$:G$23)$ as the table$\_$array.

d$.$ Use the Project Name column $($column $2)$ as the col$\_$index$\_$num.

e$.$ Specify an exact match $($FALSE$)$ for the range$\_$lookup.

$18.$ Bao also wants to list the start date of the project identified in cell J$2.$

In cell J$4,$ enter a formula using the VLOOKUP function that looks up the value in cell J$2$ in the Projects table, and then returns the corresponding start date as an exact match.

$19.$ Bao also wants to calculate the number of projects that have a budget of more than $$15,000$ and determine the average budget amount for comedy projects.

Create formulas that provide this information as follows:

a$.$ In cell J$8,$ create a formula using the DCOUNT function to count the number of projects with budget amounts more than $$15,000,$ using the Projects table $($Projects$[$#All$])$ as the database, "Budget" as the field, and the range I$6$:I$7$ as the criteria.

b$.$ In cell J$13,$ create a formula using the DAVERAGE function to average the budget amounts for Comedy projects in the Projects table, using the range I$11$:I$12$ as the criteria.

$20.$ Finally, Bao wants to summarize the number of projects proposed by the project type and calculate their total and average budget amounts.

Calculate this information for Bao as follows:

a$.$ In cell J$16,$ enter a formula using the COUNTIF function that counts the number of Action movie projects, using Projects$[$Project Type$]$ as the range and cell I$16$ as the criteria.

b$.$ Fill the range J$17$:J$19$ with the formula in cell J$16.$

c$.$ In cell K$16,$ enter a formula using the SUMIF function that totals the budget for Action movie projects, using Projects$[$Project Type$]$ as the range, cell I$16$ as the criteria, and Projects$[$Budget$]$ as the sum$\_$range.

d$.$ Fill the range K$17$:K$19$ with the formula in cell K$16.$

e$.$ In cell L$16,$ enter a formula using the AVERAGEIF function that averages the budget amounts for Action movie projects.

f$.$ Fill the range L$17$:L$19$ with the formula in cell L$16.$