lab01_01

6
Nro Código Apellidos Nombres 1 1001 Salas Chávez Ana 2 1002 Paz Flores Juan 3 1003 Alvarez Diaz Carlos 4 1004 Cáceres Hernandez Maria 5 1005 Miranda Gallegos Karen 6 1006 Zapata Casas Jorge 7 1007 Zeballos Tapia Pablo 8 1008 Perez Jaramillo Melchor 9 1009 Quintana Palacios Pedro 10 1010 Manrique Avalos Fiorella Salas Chávez Paz Flores Alvare z Diaz Cácere s Hernan dez Mirand a Galleg os Zapata Casas Zeball os Tapia S/. 0.00 S/. 500.00 S/. 1,000.00 S/. 1,500.00 S/. 2,000.00 S/. 2,500.00 S/. 3,000.00 S/. 3,500.00 S/. 4,000.00 S/. 4,500.00 S/. 4,000.00 S/. 4,000.00 S/. 4,000.00 S/. 4,000.00 S/. 4,000.00 S/. 4,000.00 S/. 4,000.00 31 32 30 30 34 33 36

Upload: max-quispe-chambi

Post on 07-Dec-2015

212 views

Category:

Documents


0 download

DESCRIPTION

Excel

TRANSCRIPT

Page 1: Lab01_01

Nro Código Apellidos NombresFecha Nacimiento

1 1001 Salas Chávez Ana 1990-12-102 1002 Paz Flores Juan 1989-07-233 1003 Alvarez Diaz Carlos 1991-10-034 1004 Cáceres Hernandez Maria 1992-01-265 1005 Miranda Gallegos Karen 1988-04-206 1006 Zapata Casas Jorge 1988-08-167 1007 Zeballos Tapia Pablo 1986-05-288 1008 Perez Jaramillo Melchor 1987-09-129 1009 Quintana Palacios Pedro 1982-02-28

10 1010 Manrique Avalos Fiorella 1984-04-12

Salas Chávez

Paz Flores

Alvarez Diaz

Cáceres Her-

nandez

Miranda Gallegos

Zapata Casas

Zeballos Tapia

Perez Jaramill

o

Quin-tana

Palacios

Man-rique

Avalos

S/. 0.00

S/. 500.00

S/. 1,000.00

S/. 1,500.00

S/. 2,000.00

S/. 2,500.00

S/. 3,000.00

S/. 3,500.00

S/. 4,000.00

S/. 4,500.00

0

5

10

15

20

25

30

35

40

45

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

32 3331 31

34 3436 35

4139

EdadesSueldo

Page 2: Lab01_01

Edad Salario

32 S/. 4,000.0033 S/. 4,000.0031 S/. 4,000.0031 S/. 4,000.0034 S/. 4,000.0034 S/. 4,000.0036 S/. 4,000.0035 S/. 4,000.0041 S/. 4,000.0039 S/. 4,000.00

Salas Chávez

Paz Flores

Alvarez Diaz

Cáceres Her-

nandez

Miranda Gallegos

Zapata Casas

Zeballos Tapia

Perez Jaramill

o

Quin-tana

Palacios

Man-rique

Avalos

S/. 0.00

S/. 500.00

S/. 1,000.00

S/. 1,500.00

S/. 2,000.00

S/. 2,500.00

S/. 3,000.00

S/. 3,500.00

S/. 4,000.00

S/. 4,500.00

0

5

10

15

20

25

30

35

40

45

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

S/. 4

,000

.00

32 3331 31

34 3436 35

4139

EdadesSueldo

Page 3: Lab01_01

Mes Semana Ingresos EgresosEnero 1 6035 397Enero 2 9946 936Enero 3 5280 1592Enero 4 9848 874

Febrero 1 2020 778Febrero 2 1287 1216Febrero 3 9117 1111Febrero 4 9289 912Marzo 1 3923 1464Marzo 2 763 371Marzo 3 9144 1452Marzo 4 3911 234

Page 4: Lab01_01

Semana Data1 2 3

Mes Suma de Ingresos Suma dSuma de ISuma dSuma de Ingr Suma de EgrEnero 6035 397 9946 936 5280 1592Febrero 2020 778 1287 1216 9117 1111Marzo 3923 1464 763 371 9144 1452Total Result 11978 2639 11996 2523 23541 4155

Mes SemanaEnero Enero Result Febrero

Data 1 2 3 4 1Suma de Ingresos 6035 9946 5280 9848 31109 2020Suma de Egresos 397 936 1592 874 3799 778

Suma de Ingresos Suma de Egresos0

2000

4000

6000

8000

10000

12000

Mes Enero 1Semana 2 3 4 Febrero 1 2 3 4 Marzo 1 2 3 4

Page 5: Lab01_01

4 Total Suma dTotal Suma de EgresosSuma de InSuma de Egresos

9848 874 31109 37999289 912 21713 40173911 234 17741 3521

23048 2020 70563 11337

Febrero Result Marzo Marzo Result Total Result2 3 4 1 2 3 4

1287 9117 9289 21713 3923 763 9144 3911 17741 705631216 1111 912 4017 1464 371 1452 234 3521 11337

Suma de Ingresos Suma de Egresos0

2000

4000

6000

8000

10000

12000

Mes Enero 1Semana 2 3 4 Febrero 1 2 3 4 Marzo 1 2 3 4