Switch$-$to$-$the $$Sales$-$Projections$-$worksheet.Use$-$the$-$values$-$in$-$the$-$range$-$B$6$:C$6-$to$-$extend$-$the$-$incremented$-$percentages$-$to$-$the range$-$D$6$:H$6\mathrm{.}1$

$2.-$ Use$-$the$-$values$-$in$-$the$-$range$$A$7$:A$8-$to$$extend$-$the$-$list$-$of$-$years$-$to$-$the$-$range$-$A$9$:A$11\mathrm{.}1$

$3.->$ Use$-$AutoFill$-$to$-$fill$-$the$-$range$-$A$9$:$11-$with$-$the$-$formatting$-$from$-$the$-$range$-$A$7$:H$8\mathrm{.}1$

$4.->$ In$-$cell$-$B$8,$create$-$a$-$formula$-$without using$-$a$-$function$-$that$-$multiplies$-$the$-$value$-$in$-$cell$-$B$7-$by$-$the$-$value$-$in$-$cell$-$B$6-$and$-$then$-$adds$-$the$-$value$-$in$-$B$7.-$In$-$this$-$formula, $-$use$-$a$-$mixed$-$reference$-$for$-$cell$-$B$6-$by$-$including$-$an$-$absolute$-$reference$-$to$-$row$-6.-$Copy$-$the$-$formula$-$from$-$cell$-$B$8-$to$-$the$-$range B$9$:B$11-$and$-$then$-$copy$-$the$-$formulas$-$from$-$the$-$range B$8$:B$11-$to$-$the$-$range$-$C$8$:H$11\mathrm{.}1$

$5.-$ Switch$-$to$-$the Cost$-$Estimates$-$worksheet.$-$In$-$cell$-$A$9,$create$-$a$-$formula$-$using $-$the$-$

AVERAGE function$-$that$-$calculates$-$the$-$average of$-$the$-$values$-$in$-$the$-$range A$5$:A$7,$ then$-$copy$-$your$-$formula$-$to$-$cell$-$D$9\mathrm{.}1$

$6.->$ In$-$cell$-$A$10,$ create$-$a$-$formula$-$using$-$the$-$MAX$-$function$-$that$-$identifies$-$the$-$maximum$-$value$-$in$-$the$-$range$-$A$5$:A$7-$and$-$then$-$copy$-$your$-$formula to$-$cell$-$D$10\mathrm{.}1$

$7.->$ In$-$cell$-$A$11,$ create$-$a$-$formula using$-$the$-$MIN$-$function$-$that$-$identifies$-$the$-$minimum$-$value:

in$-$the$-$range$-$A$5$:A$7-$and$-$then$-$copy$-$your$-$formula$-$to$-$cell$-$D$11\mathrm{.}1$

$8.->$ In$-$cell$-$B$13,$ create$-$a$-$formula$-$using$-$the$-$VLOOKUP.function$-$that$-$looks$-$up$-$the$-$value$-$from$-$cell$-$A$11-$in$-$the$-$range A$5$:B$7,-$returns$-$the$-$value$-$in$-$column$-2,-$and$-$specifies$-$an$-$exact$-$match.$-$Copy$-$the formula$-$to$-$cell$-$E$13\mathrm{.}9$

$9.->$ Switch$-$to$-$the$-$Profit Projections$-$worksheet.$-$In$-$cell$-$H$5,-$use$-$the$-$TODAY function$-$to$-$insert$-$the current date