a$.$ In cell C$7,$ create a formula without using a function that multiplies the sales projection for the first year $($cell $C6)$ by the first growth rate $($cell C$5),$ and adds the sales projection for the first year $($cell C$6)$ to the result to determine the first estimate for $2022.$

b$.$ Use an absolute reference to row $5$ in the referengs to cell $C5.$

c$.$ Copy the formula from cell $C7$ to the range $C8$:$C10,$ and then copy the formulas from the range C$7$:C$10$ to the ranae D$7$:$110$ to complete the table of proiections.

Create a formula without using a function.

In the Unit Sales Projections worksheet, the formula in cell C$7$ should multiply the value in cell C$6$ by the value in cell $C5,$ and then add the value in cell $C6$ to the result.

Use a mixed reference in a formula.

In the Unit Sales Projections worksheet, the formula in cell C$7$ should contain an absolute row reference to cell C$5.$

Copy a formula into a range.

Copy a formula into a range.