In the range I3:L7, 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 J4, 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 I4.

b. Fill the range J5:J7 with the formula in cell J4, filling without formatting.

c. In cell K4, 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 I4, and that the formula totals the values in the Estimate column (Projects[Estimate]).

d. Fill the range K5:K7 with the formula in cell K4, filling without formatting.

e. In cell L4, 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 I4, and that the formula averages the values in the Estimate column (Projects[Estimate]).

f. Fill the range L5:L7 with the formula in cell L4, filling without formatting.