Create a formula using a function.

In the Proposed Projects worksheet, the formula in cell J$2$ should use the COUNTIF function to calculate the number of proposed Commercial projects.

Copy a formula into a range.

In the Proposed Projects worksheet, one or more cells in the range J$3$:$5$ contains an incorrect formula.

X Create a formula using a function.

In the Proposed Projects worksheet, the formula in cell K$2$ should use the SUMIF function to calculate the total funding for proposed Commercial projects.

Copy a formula into a range.

In the Proposed Projects worksheet, one or more cells in the range K$3$:$5$ contains an incorrect formula.

X Create a formula using a function.

In the Proposed Projects worksheet, the formula in cell $12$ should use the AVERAGEIF function to calculate the average funding for proposed Commercial projects.

$*$ Copy a formula into a range.

In the Proposed Projects worksheet, one or more cells in the range L$3$:$15$ contains an incorrect formula.