Using the function below and the spreadsheet below match the correct function that
belongs in the blank area for each question.
1 Employee Full Name Employee Name2 Last Name
2 Gary, Alkman
Alman
3 Bryan Fishe
4 Cynthia, Felser
6Jean, Leslie
7 Cynthia, imber
& Kevin, Granger
1
2
5
Gary Akman
Bryan-Fishe
Cynthia-Felser
Jean-Leslie
Cynthia-imber
Kevin-Granger
Fishe
Felser
Leslie
Imber
Granger
(B4,LEN(B4)-
FIND("-",B4))
(D2, " ",C2)
("Account",E3)
(B4,FIND("-",84)-1)
(A3,5,2,-)
Gary
Bryan
Cynthia
Jean
Cynthia
Kevin
D
Title
Location
DETROIT
Account Rep
Senior Account Rep LANTS
Account Rep
Boston
devand
Account Rep
Senior Account Rep Cleveland
Trainee Account Rep Detroit
CONCATENATE
1
2. REPLACE
3. LEFT
4. RIGHT
5. PROPER
6. FIND
Moc LOCATION-2
1 Detroit
6 Atlanta
1 Boston
1 Cleveland
8 Cleveland
Detroit
9
Acti
Go to