Use the values in the range C$14$:D$14$ to fill the range E$14$:I$14$ with a series of incremented percentages.$|$

Use the values in the range $B15$:$B16$ to extend the list of years to the range $B17$:$B1$ five years of projections.

Estimate the gross profit for $2024$ as follows:

a$.$ In cell $C15,$createafor$lawithoutusingafunctionthatsubtractsthevendo$ cost $($cell C$7)$ and the shipping cost $($cell C$9)$ from the sales price $($cell C$8),$ ant then multiplies the result by the projected number of units for sale in $2024($ce$)$ C$10).$

b$.$ Use absolute references to each cell in the formula.

c$.$ Copy the formula from cell C$15$ to the range D$15$:I$15$ to complete the estimate $2024.$