Examen Parcial De Excel

Codigo

A001 A002 A003 A004 A005 A006 A007 A008 A009 A010 A011 A012 B001 B002 B003 B004 B005 B006 B007 B008 B009 B010 A010 A011 A012 A013 A014 A015 A016 A017 A018 A019 A020 A021 A022 A023 A024 A025 A026 A027 A028 A029

ID Empl

Apellido

Nombre

Departamento Sección

Salario Fch comienzo

1976

Franklin

Larry

Contabilidad

Copiadoras

$21,888

5/7/91

1976

Petry

Robin

Ingeniería

Impresoras

$23,036

4/29/91

1168

Asonte

Toni

Ingeniería

Fax

$23,036

4/10/91

1169

Dorfberg

Jeremy

Ingeniería

Copiadoras

$34,002

10/13/92

1167

Berwick

Sam

Mercado

Copiadoras

$31,914

4/18/91

1931

Mueller

Ursula

Contabilidad

Copiadoras

$26,101

6/20/89

1967

Aruda

Felice

Administración

Copiadoras

$23,212

11/9/91

1676

Wells

Jason

Administración

Copiadoras

$23,212

10/18/81

1075

Kane

Sheryl

Diseño

Impresoras

$23,239

8/7/92

1966

Corwick

Rob

Diseño

Fax

$23,239

11/17/91

1816

Lin

Michael

Ingeniería

Fax

$35,480

7/8/90

1814

Al-Sabah

Daoud

Ingeniería

Fax

$21,304

3/4/89

1968

Martinez

Sara

Mercado

Copiadoras

$35,989

1/1/93

1675

Miller

Janet

Mercado

Copiadoras

$33,301

10/26/81

1677

Levine

Eric

I+D

Fax

$37,896

11/6/87

1793

Able

Aaron

Administración

Fax

$24,180

12/16/90

1792

Barton

Eileen

Diseño

Copiadoras

$28,859

12/24/90

1794

Goldberg

Malcolm

Mercado

Fax

$37,489

12/18/84

1426

Lampstone

Pete

Mercado

Fax

$34,689

9/8/77

1530

Stewart

Iain

Administración

Impresoras

$25,147

1/20/91

1054

Smith

Howard

Diseño

Copiadoras

$25,176

4/16/91

1977

Maguire

Mollie

Diseño

Copiadoras

$30,014

6/13/80

1529

Kellerman

Tommie

Ingeniería

Impresoras

$25,147

1/28/87

1978

Silverberg

Jay

Ingeniería

Fax

$51,879

6/5/80

1055

Albert

Maxine

Mercado

Copiadoras

$26,041

4/8/91

1531

Lempert

Alexandra

I+D

Copiadoras

$41,053

5/11/86

1290

Cooper

Linda

Administración

Fax

$26,114

1/3/85

1300

Richards

Phillip

Contabilidad

Impresoras

$30,452

12/13/89

1152

Henders

Mark

Contabilidad

Impresoras

$26,646

1/21/90

1960

Fontaine

Jean

Contabilidad

Copiadoras

$28,044

11/13/86

1153

Plant

Allen

Contabilidad

Impresoras

$28,044

1/13/90

1961

Mueller

Kris

Administración

Fax

$27,081

11/5/86

1557

Bates

Lisa

Administración

Copiadoras

$27,081

11/18/81

1723

Alstain

Isolde

Ingeniería

Fax

$29,362

8/6/90

1556

Davison

Karen

Ingeniería

Impresoras

$29,362

11/26/81

1333

Szcznyck

Tadeuz

Ingeniería

Copiadoras

$29,362

4/16/90

1299

Simpson

Sandrae

Ingeniería

Copiadoras

$24,854

12/21/89

1301

Sindole

Randy

Mercado

Fax

$27,081

8/6/84

1724

Chu

Steven

Mercado

Impresoras

$28,044

7/29/90

1558

Sargent

Evelyn

Mercado

Copiadoras

$41,987

10/16/82

1041

Tercan

Robert

I+D

Impresoras

$28,044

4/16/92

1334

Kaneko

Midori

I+D

Fax

$28,044

4/8/90

A030 A031 A032 A033 A034 A035 A036 A037 A038 A039 A040 A041 A042 A043 A044 A045 A046 A047 A048 A049 A050 A051 A052 A053 A054 A055 A056 A057 A058 A059 A060 A061 A062 A063 A064 A065 A066 A067 A068 A069 A070 A071 A072 A073 A074 A075 A076 A077 A078 A079

1330

Selznick

Anna

Contabilidad

Copiadoras

$31,539

2/14/89

1674

Boughton

Frank

Contabilidad

Fax

$27,598

3/25/92

1011

Gorton

Hazel

Contabilidad

Copiadoras

$27,598

2/3/86

1675

Melendez

Jaime

Contabilidad

Fax

$29,045

3/17/92

1012

Preston

Liza

Ingeniería

Impresoras

$43,394

1/26/86

1331

Cash

Mary

Ingeniería

Impresoras

$42,872

5/11/89

1310

Smith

Ellen

Ingeniería

Fax

$30,411

10/4/86

1329

Vuanuo

Tuome

Ingeniería

Impresoras

$30,411

2/22/89

1311

Cane

Nate

Mercado

Impresoras

$43,487

9/26/86

1657

Wells

Rose

Contabilidad

Impresoras

$32,627

12/6/87

1516

Bell

Tom

Contabilidad

Impresoras

$28,550

3/6/85

1517

Quan

Karen

Ingeniería

Impresoras

$62,590

2/26/85

1658

Coyne

Dennis

Ingeniería

Copiadoras

$44,351

6/6/88

1518

Smythe

Leslie

Ingeniería

Impresoras

$44,351

6/18/90

1656

Kourios

Theo

Mercado

Copiadoras

$29,015

12/14/87

1079

Price

Ellen

Administración

Impresoras

$29,983

3/24/86

1758

Brwyne

Melia

Diseño

Impresoras

$35,785

3/18/82

1673

Dixon-Waite

Sherrie

Ingeniería

Copiadoras

$29,983

4/16/90

1509

Kegler

Pam

Ingeniería

Fax

$29,983

6/19/85

1759

Alexi

Stephanie

Ingeniería

Impresoras

$61,856

3/10/82

1510

White

Jessica

Ingeniería

Copiadoras

$46,387

6/11/85

1078

Hapsbuch

Kendrick

Mercado

Impresoras

$29,983

4/1/86

1285

Taylor

Ralph

Mercado

Impresoras

$77,179

12/27/84

1284

Bellwood

Frank

Mercado

Fax

$46,486

1/4/85

1674

Cummins

Dave

I+D

Copiadoras

$31,048

4/8/90

1067

Scote

Gail

Diseño

Fax

$36,940

9/20/87

1068

Mann

Alyssa

Ingeniería

Impresoras

$47,883

9/12/87

1922

Smith

Barbara

Ingeniería

Impresoras

$28,405

12/5/86

1923

Barber

Lisa

Mercado

Fax

$47,986

11/27/86

1573

Robbins

Bob

Contabilidad

Fax

$35,889

7/7/88

1695

Nelson

Ed

Diseño

Fax

$38,094

10/20/84

1360

Raye

Alice

Ingeniería

Copiadoras

$33,051

8/1/88

1574

Weston

Sam

Ingeniería

Fax

$50,651

2/9/86

1977

Gladstone

Wes

Ingeniería

Fax

$48,786

9/9/91

1572

Tuppman

Lise-Anne

Ingeniería

Impresoras

$34,605

7/15/88

1906

Bankler

Rowena

Mercado

Impresoras

$31,917

9/28/89

1907

Homes

Megan

Mercado

Impresoras

$33,051

9/20/89

1359

Morton

Sara

Mercado

Impresoras

$49,485

8/9/90

1361

Stone

Cindy

I+D

Impresoras

$34,605

7/22/88

1368

Wu

Tammy

Administración

Fax

$32,884

3/11/83

1815

Fein

Caroline

Ingeniería

Copiadoras

$70,935

2/25/80

1369

Barth

Sandra

I+D

Fax

$57,756

3/3/83

1370

Townes

Everett

I+D

Impresoras

$53,685

11/27/87

1908

Zostoc

Melissa

Administración

Fax

$72,820

5/15/84

1428

Ferngood

Jules

Ingeniería

Impresoras

$53,721

11/12/86

1352

Ygarre

Lisa

Ingeniería

Impresoras

$31,068

9/18/82

1353

Hardy

Bill

I+D

Impresoras

$59,455

9/10/82

1427

Price

David

I+D

Copiadoras

$59,455

8/31/77

1291

Constance

Burt

Administración

Impresoras

$35,786

12/26/84

1292

Seidel

Matt

Mercado

Impresoras

$51,340

11/20/87

A080 A081 A082 A083 A084 A085 A086 A087 A088 A089 A090 A091 A092 A093 A094 A095 A096 A097 A098 A099 A100 A101

1725

Hodge

Alex

Administración

Impresoras

$79,061

2/12/78

1302

Berg

Bobby

Ingeniería

Fax

$79,280

7/29/84

1301

Sofer

Ariel

Ingeniería

Impresoras

$58,326

1/9/86

1154

Solomon

Ari

Ingeniería

Copiadoras

$56,177

7/7/87

1303

Lark

Donald

Ingeniería

Impresoras

$56,177

3/3/88

1294

North

Robert

Ingeniería

Fax

$58,358

9/6/84

1293

Cronwith

Brent

Ingeniería

Impresoras

$40,897

9/14/84

1725

Farley

Sam

Mercado

Copiadoras

$97,096

2/2/78

1724

Sammler

Mark

Mercado

Impresoras

$58,482

2/10/78

1080

Foss

Felix

I+D

Impresoras

$64,738

10/29/88

1968

Larssen

Erika

Administración

Impresoras

1950

Smith

Rich

Mercado

Fax

1949

Sampson

Carla

Mercado

1967

Cortlandt

Charles

Mercado

1969

West

Cara

1932

McGuire

1933 1354

$65,822

4/5/82

$104,565

10/4/81

Copiadoras

$62,981

10/12/81

Copiadoras

$58,278

4/13/82

Mercado

Impresoras

$58,278

4/14/89

Ellen

Contabilidad

Fax

$47,853

6/12/89

Johnson

Miguel

Ingeniería

Fax

$67,535

1/8/84

Beech

Susan

Ingeniería

Copiadoras

$69,070

5/6/86

1962

Wolf

Hilda

Mercado

Impresoras

$66,603

10/22/87

1076

McKormick

Brad

Ingeniería

Copiadoras

$105,753

7/30/79

1696

Abdul

Cathy

Ingeniería

Copiadoras

$79,307

10/12/84

1056

Gonzales

Joe

Administración

Copiadoras

$116,511

10/25/79

2 Fch nacimiento

Nombre Completo

9/28/70 Franklin Larry 10/9/70 Petry Robin 7/8/70 Asonte Toni 7/12/70 Dorfberg Jeremy 6/27/70 Berwick Sam 5/28/69 Mueller Ursula 5/15/69 Aruda Felice 9/12/69 Wells Jason 8/28/69 Kane Sheryl 5/4/69 Corwick Rob 9/1/69 Lin Michael 8/17/69 Al-Sabah Daoud 5/19/69 Martinez Sara 9/1/69 Miller Janet 9/16/69 Levine Eric 10/14/68 Able Aaron 10/3/68 Barton Eileen 10/18/68 Goldberg Malcolm 3/9/68 Lampstone Pete 1/15/67 Stewart Iain 8/9/67 Smith Howard 9/15/67 Maguire Mollie 1/4/67 Kellerman Tommie 9/26/67 Silverberg Jay 8/20/67 Albert Maxine 1/19/67 Lempert Alexandra 4/3/66 Cooper Linda 9/24/65 Richards Phillip 10/23/65 Henders Mark 3/22/65 Fontaine Jean 11/3/65 Plant Allen 4/2/65 Mueller Kris 9/22/65 Bates Lisa 5/10/65 Alstain Isolde 9/11/65 Davison Karen 10/7/65 Szcznyck Tadeuz 9/13/65 Simpson Sandrae 6/25/65 Sindole Randy 5/21/65 Chu Steven 9/26/65 Sargent Evelyn 1/25/65 Tercan Robert 10/18/65 Kaneko Midori

2 Edad

39 39 39 39 39 40 40 40 40 40 40 40 40 40 40 41 41 41 41 42 42 42 42 42 42 42 43 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44

2 Sección

A A A A A A A A A A A A B B B B B B B B B B A A A A A A A A A A A A A A A A A A A A

2 Ubicación

principal principal principal principal principal principal principal principal principal principal principal principal sucursal sucursal sucursal sucursal sucursal sucursal sucursal sucursal sucursal sucursal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal

2

2

Años Bonificación laborados anual

18 18 18 17 18 20 18 28 17 17 19 20 16 28 22 18 18 24 32 18 18 29 22 29 18 23 24 19 19 22 19 23 27 19 27 19 19 25 19 27 17 19

S/.1,094.40 S/.1,151.79 S/.1,151.79 S/.1,700.10 S/.1,595.69 S/.1,305.07 S/.1,160.62 S/.1,160.62 S/.1,161.97 S/.1,161.97 S/.1,774.02 S/.1,065.18 S/.1,799.46 S/.1,665.07 S/.1,894.78 S/.1,208.98 S/.1,442.96 S/.1,874.44 S/.1,734.45 S/.1,257.33 S/.1,258.80 S/.1,500.68 S/.1,257.33 S/.2,593.94 S/.1,302.03 S/.2,052.67 S/.1,305.69 S/.1,522.58 S/.1,332.31 S/.1,402.18 S/.1,402.18 S/.1,354.05 S/.1,354.05 S/.1,468.11 S/.1,468.11 S/.1,468.11 S/.1,242.71 S/.1,354.05 S/.1,402.18 S/.2,099.37 S/.1,402.18 S/.1,402.18

5/17/64 Selznick

Anna Frank 11/21/64 Gorton Hazel 1/28/64 Melendez Jaime 12/2/64 Preston Liza 5/21/64 Cash Mary 11/2/64 Smith Ellen 5/6/64 Vuanuo Tuome 11/13/64 Cane Nate 10/10/63 Wells Rose 6/26/63 Bell Tom 7/7/63 Quan Karen 10/14/63 Coyne Dennis 7/11/63 Smythe Leslie 9/29/63 Kourios Theo 12/2/62 Price Ellen 10/23/62 Brwyne Melia 9/1/62 Dixon-Waite Sherrie 10/24/62 Kegler Pam 11/3/62 Alexi Stephanie 11/4/62 White Jessica 11/21/62 Hapsbuch Kendrick 12/22/62 Taylor Ralph 12/11/62 Bellwood Frank 9/12/62 Cummins Dave 9/30/61 Scote Gail 10/11/61 Mann Alyssa 2/24/61 Smith Barbara 3/7/61 Barber Lisa 5/31/60 Robbins Bob 1/5/60 Nelson Ed 6/18/60 Raye Alice 6/4/60 Weston Sam 10/13/60 Gladstone Wes 5/20/60 Tuppman Lise-Anne 9/2/60 Bankler Rowena 9/13/60 Homes Megan 6/7/60 Morton Sara 6/22/60 Stone Cindy 5/8/59 Wu Tammy 8/28/59 Fein Caroline 5/19/59 Barth Sandra 5/23/59 Townes Everett 9/21/58 Zostoc Melissa 3/23/58 Ferngood Jules 7/22/58 Ygarre Lisa 8/2/58 Hardy Bill 3/19/58 Price David 4/14/56 Constance Burt 4/18/56 Seidel Matt 1/17/64 Boughton

45 45 44 45 44 45 45 45 44 46 46 46 46 46 46 46 47 47 47 47 47 46 46 46 47 48 48 48 48 49 49 49 49 49 49 49 49 49 49 50 50 50 50 51 51 51 51 51 53 53

A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A

principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal

20 17 23 17 23 20 23 20 23 21 24 24 21 19 21 23 27 19 24 27 24 23 24 24 19 22 22 22 22 21 25 21 23 18 21 20 20 19 21 26 29 26 21 25 22 27 27 32 24 21

S/.1,576.96 S/.1,379.89 S/.1,379.89 S/.1,452.26 S/.2,169.71 S/.2,143.61 S/.1,520.54 S/.1,520.54 S/.2,174.35 S/.1,631.34 S/.1,427.48 S/.3,129.48 S/.2,217.53 S/.2,217.53 S/.1,450.77 S/.1,499.13 S/.1,789.27 S/.1,499.13 S/.1,499.13 S/.3,092.78 S/.2,319.34 S/.1,499.13 S/.3,858.96 S/.2,324.30 S/.1,552.42 S/.1,846.99 S/.2,394.16 S/.1,420.24 S/.2,399.28 S/.1,794.47 S/.1,904.71 S/.1,652.57 S/.2,532.57 S/.2,439.28 S/.1,730.27 S/.1,595.85 S/.1,652.57 S/.2,474.26 S/.1,730.27 S/.1,644.21 S/.3,546.74 S/.2,887.82 S/.2,684.27 S/.3,640.98 S/.2,686.06 S/.1,553.39 S/.2,972.76 S/.2,972.76 S/.1,789.28 S/.2,566.99

5/26/55 Hodge

Alex Bobby 9/28/55 Sofer Ariel 11/7/55 Solomon Ari 7/10/55 Lark Donald 9/5/54 North Robert 8/25/54 Cronwith Brent 6/2/54 Farley Sam 5/22/54 Sammler Mark 12/6/52 Foss Felix 9/28/51 Larssen Erika 3/9/51 Smith Rich 2/26/51 Sampson Carla 9/17/51 Cortlandt Charles 10/2/51 West Cara 6/8/49 McGuire Ellen 6/12/49 Johnson Miguel 8/6/48 Beech Susan 4/6/45 Wolf Hilda 9/8/40 McKormick Brad 1/16/40 Abdul Cathy 8/24/37 Gonzales Joe 7/6/55 Berg

54 54 54 54 54 55 55 55 55 56 58 58 58 58 58 60 60 61 64 69 69 72

A A A A A A A A A A A A A A A A A A A A A A

principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal principal

31 25 23 22 21 25 25 31 31 21 27 28 28 27 20 20 25 23 22 30 25 30

S/.3,953.06 S/.3,964.01 S/.2,916.29 S/.2,808.87 S/.2,808.87 S/.2,917.88 S/.2,044.87 S/.4,854.82 S/.2,924.12 S/.3,236.91 S/.3,291.08 S/.5,228.27 S/.3,149.06 S/.2,913.88 S/.2,913.88 S/.2,392.63 S/.3,376.76 S/.3,453.50 S/.3,330.14 S/.5,287.65 S/.3,965.33 S/.5,825.57

4 Traslados

0 0 X 0 0 0 0 0 0 X X X 0 0 X X 0 X X 0 0 0 0 X 0 0 X 0 0 0 0 X 0 X 0 0 0 X 0 0 0 X

0 X 0 X 0 0 X 0 0 0 0 0 0 0 0 0 0 0 X 0 0 0 0 X 0 X 0 0 X X X 0 X X 0 0 0 0 0 X 0 X 0 X 0 0 0 0 0 0

0 X 0 0 0 X 0 0 0 0 0 X 0 0 0 X X 0 0 0 0 0