ren't being checked in this document.

MedSight Instruments I

PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONSII

$$ GEITING STARTEDT

$$ Open$-$the$-$file$-$NP$\_$EX$19\_3$b$\_$FirstLastName$\_1.$xlsx$,$ available$-$for$-$download from theSAM$-$website. I

$0$ If you$-$do$-$not$-$see$-$the$-$xlsx$-$file$-$extension$-$in$-$the$-$Save$-$As$-$dialog$-$box, do$-$not$-$type$-$it$.$ The$-$program$-$will$-$add$-$the$-$file$-$extension$-$for$-$you$-$automatically$-$I

$$ With$-$the$-$file$-$NP$\_$EX$19\_3$b$\_$FirstLastName$\_2$xisx$-$still$-$open,$-$ensure$-$that$-$your$-$firstand$-$last$-$name$-$is$-$displayed$-$in $*$cell$-$B$6-$of$-$the$-$Documentation$-$sheet. I

$$ If$-$cell$-$B$6-$does$-$not$-$display$-$your$-$name,delete$-$the$-$file$-$and$-$download$-$a$-$new$-$copyfrom$*$the$-$SAM$*$website$.$q

$$ PROJECT STEPS$$

$$ Amy$-$Zhao$-$is$-$a$-$financial$-$analyst$-$with$-$MedSight$-$Instruments, $*$ a global$-$manufacturer$-$ofmedical$-$instruments$-$and$-$devices. $T$ The$-$MedSight$-$Auditory$-$Instruments$-$Division$-$is$*$ planning$-$to$-$manufacture$-$and$-$market$-$an$-$innovative$-$hearing$-$aid$-$suitable$-$for$-$all$-$ages. Amy is$-$using$-$an$-$Excel$-$workbook$-$to$-$estimate$-$the$-$sales, expenses, and$-$profits$-$of$-$the$-$newdevice. diamond

Switch$-$to$-$the$-$Unit$-$Sales$-$Projections$-$worksheet. Use$-$the$-$values$-$in$-$the$-$range$-$C$5$:D$5-$to$-$fillthe$-$range$-$E$5$:I$5-$with$-$a$-$series$-$of$-$incremented$-$percentages.I

$$ Use$-$the$-$values$-$and$-$formatting in $-$the$-$range$-$B$6$:B$7-$to extend $-$the$-$list$-$of years to therange$-$B$8$:B$10-$and$-$project$-$five$-$years$-$of$-$growth.I consistent$-$format$-$in$-$the$-$projections. I