66.6k views
5 votes
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

User Endoro
by
8.3k points

2 Answers

3 votes
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
User Michael Vaquier
by
7.9k points
3 votes
girl what the bell do this urself
User Jari Jokinen
by
8.2k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.