$2021\mathrm{.}11$

$14.$ Complete$-$the$-$growth$-$estimates$-$for$-$the$-$years$-2022-$to$-2025-$as$-$follows: q

a$.$ In$-$cell$-$C$16,$ create$-$a formula that adds$-1-$to the growth$-$rate$-($cell$-$c$14)-$andmultiplies$-$the$-$result$-$by$-$the$-$estimated$-$profit$-$from$-2021.($cell$-$c$15).$ I

b$.$ Use$-$an$-$absolute$-$row$-$reference$-$to$-$cell$-$C$14.-$I

c$.$ Copy$-$the$-$formula$-$from$-$cell$-$C$16-$to$-$the$-$range$-$C$17$:C$19-$to$-$enter$-$the$-$first$-$estimatesfor$-2023-2025\mathrm{.}1]$

d$.$ Copy$-$the$-$formulas$-$from$-$the$-$range$-$C$16$:C$19-$to$-$the$-$range$-$D$16$:I$19-$to$-$enter$-$theremaining$-$sales$-$projections.I$]$