INSTRUCTIONS - EXCEL QUALITY TEST

Point No. 1 Cell format.

Apply formats for the data in Sheet1, as follows:

1. Center the title LIST OF SALARIES, between columns A and D.

2. Adjust the text of DATE OF BIRTH.
3. Apply currency format, without decimals for salaries.
$600,000
4. Apply the format 12-Dec-70 for the dates.
5. Select the range A4:D11 and apply borders to the Outline and Interior of the selection.

Point No. 2 If Function.

Use the If function in column F of Sheet 2 to define the student's CONCEPT as follows: a student
APPROVED if you have a FINAL score greater than or equal to 30, otherwise it is FAILED

Point No. 3 Organize.

Take the information found in Sheet3 and sort it in descending order by ID.
Point No. 4 Self Filter.
Use Autofilter on Sheet4 to show the people whose Start Date is between January 1st
2007 and March 31, 2007 (inclusive)
Point No. 5 Pivot tables.
Usando la tabla de la Hoja5, cree una tabla dinámica que muestre cuantos colaboradores tenemos por
cadaEmpleador

Point No. 6 SearchV.

Use VLookup to bring the POSITION of each employee from the Job Matrix (Sheet 6), according to their
CODE POSITION.
Use VLOOKUP to bring the SALARY of each employee from the Job Matrix according to their CODE.
CARGO.
Point No. 7 Uppercase
In column C of Sheet7, insert using formulas the name in uppercase.
Point No. 8 List.
In cell A1 of Sheet8, insert a validation list using the available data in this sheet.

Point No. 9 Graphics.

Using the data from Sheet9, create a graph with the following characteristics:

1. Chart Type: Columns, Subtype: Grouped column with 3D effect.

2. Título del Gráfico: VENTAS.
3. Title of the Category Axis: MONTHS.
4. Título del Eje de Valores: CANTIDAD.

Point No. 10 Pareto.

Create a Pareto chart with the data recorded in Sheet10.
SCORE COMPLETED

OK

OK

OK

OK

OK

OK

OK

OK

OK

OK
 SALARY LIST

NAME APELLIDO SUELDO DATE OF BIRTH

Carlos Suarez $ 600,000 December 12, 1970
Andrea Gomez $ 800,000 December 11, 1980
Carolina Parra $ 700,000 December 11, 1980
Andres Diaz $ 500,000 2-Apr-81
Edgar Gomez $ 700,000 3-may-80
Lorena Diaz $ 500,000 April 4, 1979
Adriana Perez $ 700,000 5-Apr-76
 1st. 2nd. EXAM
STUDENT FINAL CONCEPT
PARTIAL PARTIAL FINAL
JUAN DIAZ 35 48 39 40.5 APPROVED
CLAUDIA OS 25 31 40 32.8 APPROVED
CARLOS CR 20 30 26 25.4 FAILED
DIANA GOM 40 35 50 42.5 APPROVED
PATRICIA RU 45 30 48 41.7 APPROVED
RICARDO GA 48 48 45 46.8 APPROVED
DAVID ARVE 30 32 36 33 APPROVED
JAIME QUIN 41 28 30 32.7 APPROVED
ANDRES JIM 21 30 32 28.1 FAILED
PEDRO JIME 36 50 41 42.2 APPROVED
ANDREA GU 25 35 44 35.6 APPROVED
LILIANA SA 36 45 25 34.3 APPROVED
CARLOS FI 44 47 45 45.3 APPROVED
CAMILO DU 25 42 45 38.1 APPROVED
SANDRA CA 23 32 31 28.9 FAILED
MANUEL CA 36 44 25 34 APPROVED
ID card Name Fecha Inicio
52342968 Adriana Maria, Vargas 02/Jan/2007
52476235 Adriana Patricia, Agudelo Zarate 10/Jan/2007
52973610 Adriana Maria, Mora Murcia 13/Mar/2007
79711907 Alcibiades, Toscano Orjuela 13/Mar/2007
79747740 Alejandro, Laiton Chia 02/Jan/2007
79902569 Alberto, Rodriguez Rodriguez 02/Jan/2007
80208882 Aldo Fernando, Rodriguez Rodriguez 07/Mar/2007
80774460 Alvaro, Martinez Velasquez 01/Mar/2007
92522914 Abel Francisco, Rojas Hernandez 02/Jan/2007
1022947451 Alba Rocio, Avendaño Barrera 21/Mar/2007
1030523486 Alejandra Milena, Sossa Doza 01/Mar/2007
1032425576 Adriana Marcela, Rojas Peña 19/Feb/2007
 Descripción C. Costo
TECHNICAL SUPPORT INTERNET AND DATA
SAN MARTIN QUALITY
TECHNICAL SUPPORT FOR INTERNET AND DATA
CUSTOMIZED SMEs SAN MARTIN
CUSTOMIZED HOMES SAN MARTIN
CISA
TECHNICAL SUPPORT INTERNET AND DATA
ORANGE
ETB HOME SALES
SENA
ORANGE
SENA
New Cargo Temporal
AGENT CCA
Saint Martin Quality Monitor. Contact Center. CCA
AGENT CCA
AGENT CCA
Personalized ETB Support [Link] CCA
AGENT CCA
AGENT CCA
AGENT CCA
AGENT CCA
SENA CCA
AGENT CCA
SENA CCA
 Identity card Name Start Date
2756322 Abel De Cristo, Anaya Carabayo 01/May/2005
92522914 Abel Francisco, Rojas Hernandez 02/Jan/2007
7308915 Adel Hernando, Ramirez Castellanos 01/May/2005
39542097 Adela, Castro Pachon 20/Oct/2006
79797799 Adolfo, Triviño Martinez 21/Jun/2007
52855796 Adriana Carolina, Calvo Ovalle 06/Jun/2006
52123970 Adriana Marcela, Patiño Navas 01/Aug/2005
52809487 Adriana Marcela, Riaño Torres 03/May/2007
1032425576 Adriana Marcela, Rojas Peña 19/Feb/2007
52973610 Adriana Maria, Mora Murcia 13/Mar/2007
52342968 Adriana Maria, Vargas 02/Jan/2007
52390325 Adriana Maritza, Mejia Romero 08/Nov/2005
52980230 Adriana Milena, Perez Moreno 05/Aug/2005
52476235 Adriana Patricia, Agudelo Zarate 10/Jan/2007
52347026 Adriana Patricia, Lopez Arias 14/Sep/2006
51958709 Adriana, Espinosa Martinez 02/Feb/2004
52076772 Adriana, Plazas Rios 15/Dec/2006
52865473 Adriana, Vargas Pinto 20/Jun/2007
85477944 Aimer Manuel, Ardila Godoy 16/Apr/2007
40034155 Alba Cristina, Rojas Huertas 01/May/2005
51825661 Alba Delia, Paz Garzon 09/Apr/2007
52280439 Alba Luz, Rojas Lopez 07/May/2007
52444019 Alba Milena, Skinner 01/Jun/2007
1022947451 Alba Rocio, Avendaño Barrera 21/Mar/2007
19395306 Albeiro, Osorio Sepulveda 12/Jun/2000
16379459 Alberto, Carvajal Guerrero 02/Apr/2007
19295576 Alberto, Castañeda Gomez 13/Sep/2006
79902569 Alberto, Rodriguez Rodriguez 02/Jan/2007
79711907 Alcibiades, Toscano Orjuela March 13, 2007
80208882 Aldo Fernando, Rodriguez Rodriguez 07/Mar/2007
52355688 Alejandra Carolina, Castillo Fernandez 10/Mar/2006
1030523486 Alejandra Milena, Sossa Doza 01/Mar/2007
31711362 Alejandra, Cabal Sanchez 17/Apr/2007
79786583 Alejandro, Cortes Piraquive 06/Oct/1997
79747740 Alejandro, Laiton Chia 02/Jan/2007
80178604 Alejandro, Piramanrrique Guerrero 02/Oct/2006
79884073 Alejandro, Rodriguez Benavides 01/Dec/2003
80201456 Alexander, Avila Angel 14/Dec/2006
75092557 Alexander, Castro Botero 21/Nov/2006
79694723 Alexander, Castro Morales 20/Oct/2006
80238946 Alexander, Motato Florez 03/Aug/2005
80238866 Alexander, Prada Perez 02/Oct/2006
52793577 Alexandra Vanesa, Galvis Guerrero 08/Aug/2006
52234798 Alexandra, Hurtado Acosta 16/Jun/2006
66948402 Alexandra, Narvaez Giraldo 04/Jul/2006
1130624928 Alexandra, Pineda Clavijo 11/Jul/2006
79999283 Alfonso, Murcia Arcila 01/May/2005
51937066 Alia Alexandra, Jimenez Quintana 16/Jan/2004
52844820 Aliz Johanna, Mancipe Castiblanco 15/Nov/2006
6282874 Alvaro Julian, Barco Ocampo 01/Jan/2006
80774460 Alvaro, Martinez Velasquez 01/Mar/2007
79732147 Alvaro, Nuñez Duque 10/Oct/2006
 Descripción C. Costo
PERSONALIZED WRITING HOMES SAN MARTIN
ETB HOME SALES
CUSTOM WRITTEN HOMES SAN MARTIN
MULTICHANNEL SAN MARTIN
AEROREPUBLICA BOGOTA
HUMAN MANAGEMENT MANAGEMENT
Personalized Homes San Martin
ASSISTED SAN MARTIN
SENA
TECHNICAL SUPPORT INTERNET AND DATA
TECHNICAL SUPPORT INTERNET AND DATA
ORGANIZATION AND METHODS
GOLDEN QUALITY
QUALITY SAN MARTIN
CUSTOM WRITING HOMES SAN MARTIN
Commercial Management
MAYOR'S OFFICE SAN MARTIN
SERVED BY SAN MARTIN
113 ETB DORADO
CUSTOMIZED SMEs SAN MARTIN
ASSISTED SAN MARTIN
CODENSA NEW GOLDEN
TRAINING SAN MARTIN
SENA
113 ETB DORADO
COMFANDI
ORANGE
CISA
PERSONALIZED SMEs SAN MARTIN
TECHNICAL SUPPORT INTERNET AND DATA
CODENSA NEW GOLD
ORANGE
GOLDEN CARVAJAL
TECHNOLOGY
PERSONALIZED HOMES SAN MARTIN
CUSTOMIZED LARGE
TECHNOLOGY
HELP DESK SAN MARTIN
HELP DESK SAN MARTIN
TECHNOLOGY
CUSTOMIZED WRITTEN SAN MARTIN HOMES
PROCESSES
GOLDEN STATISTICS
113 ETB DORADO
DORADO CARVAJAL
AEROREPUBLICA CALI
PERSONALIZED WRITING HOMES SAN MARTIN
ASSISTED SAN MARTIN
HELP DESK SAN MARTIN
TECHNOLOGY
ORANGE
QUALITY SAN MARTIN
New Cargo Temporal
AGENT CCA
AGENT CCA
AGENT CCA
AGENT CCA
AGENT CCA
Human Management Assistant. Contact Center. SA CCA
AGENT CCA
AGENT CCA
SENA CCA
AGENT CCA
AGENT CCA
Junior Operations Manager Colombia Movil Bac CCA
Quality Monitor [Link] [Link] CCA
Quality Monitor San Martín. Contact Center. CCA
AGENT CCA
Commercial Manager. Contact Center. SANTAFE CCA
AGENT CCA
AGENT CCA
AGENT CCA
AGENT CCA
AGENT CCA
AGENT CCA
Trainer Training San Martí[Link] CCA
SENA CCA
AGENT CCA
AGENT CCA
Coordinator Orange [Link] [Link] CCA
AGENT CCA
AGENT CCA
AGENT CCA
Codensa Fonoservicio [Link] CCA
AGENT CCA
AGENT CCA
Technical Computer Production. Contact Cen CCA
Customized ETB Support [Link] CCA
AGENT CCA
Information Technology Production [Link] Cen CCA
CCA AGENT
Junior Operations Chief Premium Help Desk CCA
IT Production Technician. Contact Cen CCA
AGENT CCA
Analyst I Software Development. Contact Center CCA
Golden Statistics Controller. Contact Center CCA
Coordinator 113 ETB Dorado. Contact Center CCA
AGENT CCA
AGENT CCA
AGENT CCA
Junior Operations Manager Assisted San Martín CCA
CCA AGENT
Coordinator Technology [Link] Center.C CCA
AGENT CCA
San Martín Quality Monitor. Contact Center. CCA
ID card Name Start Date

2756322 Abel De Cristo, Anaya Carabayo 01/May/2005

92522914 Abel Francisco, Rojas Hernandez 02/Jan/2007
7308915 Adel Hernando, Ramirez Castellanos 01/May/2005
39542097 Adela, Castro Pachon 20/Oct/2006
79797799 Adolfo, Triviño Martinez 21/Jun/2007
52855796 Adriana Carolina, Calvo Ovalle 06/Jun/2006
52123970 Adriana Marcela, Patiño Navas 01/Aug/2005
52809487 Adriana Marcela, Riaño Torres 03/May/2007
1032425576 Adriana Marcela, Rojas Peña 19/Feb/2007
52973610 Adriana Maria, Mora Murcia 13/Mar/2007
52342968 Adriana Maria, Vargas 02/Jan/2007
52390325 Adriana Maritza, Mejia Romero 08/Nov/2005
52980230 Adriana Milena, Perez Moreno 05/Aug/2005
52476235 Adriana Patricia, Agudelo Zarate 10/Jan/2007
52347026 Adriana Patricia, Lopez Arias 14/Sep/2006
51958709 Adriana, Espinosa Martinez 02/Feb/2004
52076772 Adriana, Rios Squares 15/Dec/2006
52865473 Adriana, Vargas Pinto 20/Jun/2007
85477944 Aimer Manuel, Ardila Godoy 16/Apr/2007
40034155 Alba Cristina, Rojas Huertas 01/May/2005
51825661 Alba Delia, Paz Garzon 09/Apr/2007
52280439 Alba Luz, Rojas Lopez 07/May/2007
52444019 Alba Milena, Skinner 01/Jun/2007
1022947451 Alba Rocio, Avendaño Barrera 21/Mar/2007
19395306 Albeiro, Osorio Sepulveda 12/Jun/2000
16379459 Alberto, Carvajal Guerrero 02/Apr/2007
19295576 Alberto, Castañeda Gomez 13/Sep/2006
79902569 Alberto, Rodriguez Rodriguez 02/Jan/2007
79711907 Alcibiades, Toscano Orjuela 13/Mar/2007
80208882 Aldo Fernando, Rodriguez Rodriguez 07/Mar/2007
52355688 Alejandra Carolina, Castillo Fernandez 10/Mar/2006
1030523486 Alejandra Milena, Sossa Doza 01/Mar/2007
31711362 Alejandra, Cabal Sanchez 17/Apr/2007
79786583 Alejandro, Cortes Piraquive 06/Oct/1997
79747740 Alejandro, Laiton Chia 02/Jan/2007
80178604 Alejandro, Piramanrrique Guerrero 02/Oct/2006
79884073 Alejandro, Rodriguez Benavides 01/Dec/2003
80201456 Alexander, Avila Angel 14/Dec/2006
75092557 Alexander, Castro Botero 21/Nov/2006
79694723 Alexander, Castro Morales 20/Oct/2006
80238946 Alexander, Motato Florez 03/Aug/2005
80238866 Alexander, Prada Perez 02/Oct/2006
52793577 Alexandra Vanesa, Galvis Guerrero 08/Aug/2006
52234798 Alexandra, Hurtado Acosta 16/Jun/2006
66948402 Alexandra, Narvaez Giraldo 04/Jul/2006
1130624928 Alexandra, Pineda Clavijo 11/Jul/2006
79999283 Alfonso, Murcia Arcila 01/May/2005
51937066 Alia Alexandra, Jimenez Quintana 16/Jan/2004
52844820 Aliz Johanna, Mancipe Castiblanco 15/Nov/2006
6282874 Alvaro Julian, Barco Ocampo 01/Jan/2006
80774460 Alvaro, Martinez Velasquez 01/Mar/2007
79732147 Alvaro, Nuñez Duque 10/Oct/2006
 Cargo
Description C. o
Employer
Cost New
vo
PERSONALIZED AGENDA Name Account
ETB SALES HOME AGENCCA Employer Total
PERSONALIZED AGENDA CCA 30
MULTICHANNEL SAN AGENCOLTEMPORA COLTEMPORA 12
AEROREPUBLICA AGENCCA ACTION 10
MANAGEMENT GESTI Auxiliary CCA Total general 52
PERSONALIZED AGENCOLTEMPORA
ASSISTED SAN MARAGENCCA
SENA SENACOLTEMPORA
TECHNICAL SUPPORT AGENCCA
TECHNICAL SUPPORT AGENGCCA
CCA Chief
ORGANIZATION AND
GOLDEN QUALITY Monit CCA
SAN MARQuality Monitor CCA
PERSONALIZED AGENDA
COMMERCE MANAGEMENT
MAYOR'S OFFICE SAN MA AGENCCA
ASSISTED SAN MARAGENCOLTEMPORA
113 ETB DORADO AGENCCA
PERSONALIZEYOURPAGE
ASSISTED SAN MARAGENCCA
CODENSA NEW AGENCCA
TRAINING SAFormaCCA
SENA SENACCA
113 ETB DORADO AGENCOLTEMPORA
COMFANDI AGENCCA
ORANGE CoordCCA
CISA AGENCCA
PERSONALIZED PAGE NCCA
TECHNICAL SUPPORT AGENCCA
CODENSA NEW CoordCCA
ORANGE AGENCCA
GOLDEN CARVAJAL
TECHNOLOGY Tecni COLTEMPORA
CUSTOMIZED Auxil COLTEMPORA
PERSONALIZED AGENCOLTEMPORA
TECHNOLOGY Direct TEMPORARY
SANMAGENCOLTEMPORARY HELP DESK
HELP DESK SANMManager COLTEMPORARY
TECHNOLOGY Technical COLTEMPORA
PERSONALIZEDAGENDA
PROCESSES Anali CCA
STATISTICS OF THE ACTION
113 ETB DORADO COORDINATION
CARVAJAL GOLDEN ACTION
AEROREPUBLICACTION
PERSONALIZED ACTION PLAN
ASSISTED SAN MARJefe ACTION
SANMAGENACCION HELP DESK
TECHNOLOGY Coordination
ORANGE AGENDA
SAN MARMonit QUALITY ACTION
CODE CARGO SALARY
1 ADMINISTRADOR $800,000
2 SUPERVISOR $600,000
Job Matrix
3 Seller $500,000
4 CASHIER $400,000
5 PACKER $300,000

CODE
LAST NAMES NAMES CARGO SALARY
CARGO
GARCIA CARMEN ELISA 1 ADMINISTRATOR $ 800,000
ANGEL FERNANDO 2 SUPERVISOR $ 600,000
GLORIA BEJARANO 1 ADMINISTRATOR $ 800,000
COLLAZOS ALEX 3 SELLER $ 500,000
GARCIA ANTONIO 4 CASHIER $ 400,000
VALENCIA BEATRIZ 4 CASHIER $ 400,000
MARINE CARLOS 5 PACKER $ 300,000
VELEZ CARLOS 5 PACKER $ 300,000
NUÑEZ EVELYN 3 SELLER $ 500,000
RAMIREZ DERLY 3 SELLER $ 500,000
 ID card Name
2756322 Abel De Cristo, Anaya Carabayo
92522914 Abel Francisco, Rojas Hernandez
7308915 Adel Hernando, Ramirez Castellanos
39542097 Adela, Castro Pachon
79797799 Adolfo, Triviño Martinez
52855796 Adriana Carolina, Calvo Ovalle
52123970 Adriana Marcela, Patiño Navas
52809487 Adriana Marcela, Riaño Torres
1032425576 Adriana Marcela, Rojas Peña
52973610 Adriana Maria, Mora Murcia
52342968 Adriana Maria, Vargas
52390325 Adriana Maritza, Mejia Romero
52980230 Adriana Milena, Perez Moreno
52476235 Adriana Patricia, Agudelo Zarate
52347026 Adriana Patricia, Lopez Arias
51958709 Adriana, Espinosa Martinez
52076772 Adriana, Plazas Rios
52865473 Adriana, Vargas Pinto
85477944 Aimer Manuel, Ardila Godoy
40034155 Alba Cristina, Rojas Huertas
51825661 Alba Delia, Paz Garzon
52280439 Alba Luz, Rojas Lopez
52444019 Alba Milena, Skinner
1022947451 Alba Rocio, Avendaño Barrera
19395306 Albeiro, Osorio Sepulveda
16379459 Alberto, Carvajal Guerrero
19295576 Alberto, Castañeda Gomez
79902569 Alberto, Rodriguez Rodriguez
79711907 Alcibiades, Toscano Orjuela
80208882 Aldo Fernando, Rodriguez Rodriguez
52355688 Alejandra Carolina, Castillo Fernandez
1030523486 Alejandra Milena, Sossa Doza
31711362 Alejandra, Cabal Sanchez
79786583 Alejandro, Cortes Piraquive
79747740 Alejandro, Laiton Chia
80178604 Alejandro, Piramanrrique Guerrero
79884073 Alejandro, Rodriguez Benavides
80201456 Alexander, Avila Angel
75092557 Alexander, Castro Botero
79694723 Alexander, Castro Morales
80238946 Alexander, Motato Florez
80238866 Alexander, Prada Perez
52793577 Alexandra Vanesa, Galvis Guerrero
52234798 Alexandra, Hurtado Acosta
66948402 Alexandra, Narvaez Giraldo
1130624928 Alexandra, Pineda Clavijo
79999283 Alfonso, Murcia Arcila
51937066 Alia Alexandra, Jimenez Quintana
52844820 Aliz Johanna, Mancipe Castiblanco
6282874 Alvaro Julian, Barco Ocampo
80774460 Alvaro, Martinez Velasquez
79732147 Alvaro, Nuñez Duque
MAYUS
ABEL DE CRISTO, ANAYA CARABAYO
ABEL FRANCISCO, ROJAS HERNANDEZ
ADEL HERNANDO, RAMIREZ CASTELLANOS
ADELA, CASTRO PACHON
ADOLFO, TRIVIÑO MARTINEZ
ADRIANA CAROLINA, CALVO OVALLE
ADRIANA MARCELA, PATIÑO NAVAS
ADRIANA MARCELA, RIAÑO TORRES
ADRIANA MARCELA, ROJAS PEÑA
ADRIANA MARIA, MORA MURCIA
ADRIANA MARIA, VARGAS
ADRIANA MARITZA, MEJIA ROMERO
ADRIANA MILENA, PEREZ MORENO
ADRIANA PATRICIA, AGUDELO ZARATE
ADRIANA PATRICIA, LOPEZ ARIAS
ADRIANA, ESPINOSA MARTINEZ
ADRIANA, PLAZAS RIOS
ADRIANA, VARGAS PINTO
MANUAL LOVE, ARDILA GODOY
ALBA CRISTINA, ROJAS HUERTAS
ALBA DELIA, PEACE GARZON
ALBA LUZ, ROJAS LOPEZ
ALBA MILENA, SKINNER
ALBA ROCIO, AVENDAÑO BARRERA
ALBEIRO, OSORIO SEPULVEDA
ALBERTO, CARVAJAL GUERRERO
ALBERTO, CASTAÑEDA GOMEZ
Alberto, Rodriguez Rodriguez
ALCIBIADES, TOSCANO ORJUELA
ALDO FERNANDO, RODRIGUEZ RODRIGUEZ
ALEJANDRA CAROLINA, CASTILLO FERNANDEZ
ALEJANDRA MILENA, SOSSA DOZA
ALEJANDRA, CABAL SANCHEZ
ALEJANDRO, CORTES PIRAQUIVE
ALEJANDRO, LAITON CHIA
ALEJANDRO, PIRAMANRRIQUE GUERRERO
ALEJANDRO, RODRIGUEZ BENAVIDES
ALEXANDER, AVILA ANGEL
ALEXANDER, CASTRO BOTERO
ALEXANDER, CASTRO MORALES
ALEXANDER, MOTATO FLOREZ
ALEXANDER, PRADA PEREZ
ALEXANDRA VANESA, GALVIS GUERRERO
ALEXANDRA, HURTADO ACOSTA
ALEXANDRA, NARVAEZ GIRALDO
ALEXANDRA, PINEDA CLAVIJO
ALFONSO, MURCIA ARCILA
ALIA ALEXANDRA, JIMENEZ QUINTANA
ALIZ JOHANNA, MANCIPE CASTIBLANCO
ALVARO JULIAN, BARCO OCAMPO
ALVARO, MARTINEZ VELASQUEZ
ALVARO, NUÑEZ DUQUE
Voluntary Resignation

DEVELOPMENT CASE X/0 List

Certification 0 Contract Cancellation
Certification X Reduction of workforce
Certification 0 Voluntary Resignation
Certification 0 Transfer to another Campaign
Certification 0 Cancellation due to Fatal Errors
Certification 0 Abandonment of post

Cause
 JANUARY FEBRUARY MARCH
PRODUCT1 300 280 520
PRODUCT2 350 320 270
PRODUCT3 420 270 310
600

500

400

300

200

100

0
JANUARY
PRODUCT
 SALES

FEBRUARY MARCH
TO1 PRODUCTO2 PRODUCT3
 Reasons for withdrawal

Reason Accumulated Amount

Voluntary Resignation 151 44% 151
Reduction of workforce 106 74% 257 300
Transfer to another Campaign 40 86% 297 250
Contract Cancellation 29 94% 326 200
Abandonment of position 12 97% 338
150
Cancellation due to Fatal Errors 9 100% 347
100
50
0
PARETO CHART

100%
90%
80%
70%
60%
50%
40%
30%
20%
10%
0%

Quantity Accumulated