"Hwan wants to summarize project information in column I. Calculate the number of projects, the total estimates, and the average estimate in each category.

a$.$ Next to the cell labeled $""$Bridge$"",$ use a function to count the number of Bridge projects in the Projects table. Use a cell reference to the cell labeled Bridge.

b$.$ In the appropriate cell, use a function to total the estimates for Bridge projects in the Projects table. Use a cell reference to the cell labeled Bridge.

c$.$ In the appropriate cell, use a function to average the estimates for Bridge projects in the Projects table. Use a cell reference to the cell labeled Bridge.

d$.$ Use these formulas to fill the data for the remaining categories, filling without formatting."

Create a formula using a function.

Copy a formula into a range.

Create a formula using a function.

In the Projects worksheet, the formula in cell K$4$ should contain the SUMIF function.

Copy a formula into a range.

In the Projects worksheet, the formula in cell K$4$ has not been entered correctly.

Create a formula using a function.

In the Projects worksheet, the formula in cell L$4$ should contain the AVERAGEIF function.

Copy a formula into a range.

In the Projects worksheet, the formula in cell L$4$ has not been entered correctly.