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.$