Daverage functionShelly Cashman Excel $2019|$ Modules $4-7$: SAM Capstone Project la

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

In cell $J4,$ enter a formula using the VLOOKUP function that looks up the value in cell $32$ 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$[$#AII$])$ 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.

$5$tates$)$ Text Predictions: On

Accessibility: Investigate