PROJECT STEPS $1$

$.1.-$ Brittany Lambert is a a volunteer for the Brevard County Swim Clubs in Melbourne,

Florida, and has offered to compile data on the swim club$-$employees and teams, She$-$

needs$*$your help$*$completing the workbook and analyzing the$*$data$.$

Switch to the All$-$Employees$-$worksheet.$\text{'}$In$-$cell$-$E$3,$ enter$-$a formula$-$using$-$the$-$XLOOKUP.

their years of experience: I

of experience, find the next.smallest $*$ match. I

b$.$ Fill$-$the$-$formula$-$into$-$the$-$range$-$E$4$:E$32,$ if$-$necessary. $1$

at$-$one$-$of$-$the$-$summer$-$camps, an$-$employee$-$must$-$be$-$at$-$least$-21-$years$-$old. Brittany$-$wants.

to$-$determine$-$how$-$many$-$employees$-$are$-$eligible$-$to$-$be$-$camp$-$counselors. In$-$cell$-$J$3,-$enter$-$a$-$

formula$-$using$-$the$-$IF$-$function and$-$structured$-$references$-$as$-$follows$-$to$-$determine$-$if$-$

Tiffany$*$Adams$*$can$*$work$*$as$*$a$*$camp$*$counselor: I

employee's$-$age$-$is$-$greater$-$than$-$or$-$equal$-$to$-21,$ and$-$should$-$return$-$the$-$text$-$Yes$-$if$.$

b$.$ Fill$-$the$-$formula$-$into$-$the$-$range$-$J$4$:J$32,$ if$-$necessary. $$

$$ To be eligible$-$to work with the$-$swim team, an$-$employee must$-$have$-$at$-$least$-$two$-$years$-$of$-$

OR$-$functions$-$and$-$structured$-$references$-$as$-$follows to determine $-$ if$-$Tiffany$-$Adams$-$can$-$

work$-$with.the$-$swim$-$team:$$

a$.$ The$-$IF$-$function$-$should determine if $-$the$-$employee's.Years $-$of$-$Experience is greater$-$

than$-$or$-$equal$-$to$-2.$OR$.$if$-$the$-$employee's$-$CPR$-$trained$-$status$-$is$.$"Yes", returning.