$1.$ In the range I$3$:L$7,$ Hwan wants to summarize project information. Calculate the number of projects, the total estimates, and the average estimate in each category as follows:

a$.$ In cell J$4,$ enter a formula using the COUNTIF function that counts the number of projects in the Bridge category, checking that the column of categories in the Projects table $($Projects$[$Category$])$ is equal to the value in cell I$4.$

b$.$ Fill the range J$5$:J$7$ with the formula in cell J$4,$ filling without formatting.

c$.$ In cell K$4,$ enter a formula using the SUMIF function that totals the estimates for projects in the Bridge category, checking that the column of categories in the Projects table $($Projects$[$Category$])$ is equal to the value in cell I$4,$ and that the formula totals the values in the Estimate column $($Projects$[$Estimate$]).$

d$.$ Fill the range K$5$:K$7$ with the formula in cell K$4,$ filling without formatting.

e$.$ In cell L$4,$ enter a formula using the AVERAGEIF function that averages the estimates of projects in the Bridge category, checking that the column of categories in the Projects table $($Projects$[$Category$])$ is equal to the value in cell I$4,$ and that the formula averages the values in the Estimate column $($Projects$[$Estimate$]).$

f$.$ Fill the range L$5$:L$7$ with the formula in cell L$4,$ filling without formatting.