$4.$ Enter formulas as follows to complete the table of projections in the range C$6$:I$10$:

a$.$ In cell C$7,$ create a formula without using a function that multiplies the sales projection for the first year $($cell C$6)$ 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 $2025.$

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