Practica reforzamiento 4
Download as XLS, PDF0 likes914 views
This document contains a list of 9 vendors with their codes, names, districts, sexes and ages. It also includes summaries by sex and district, with the total salaries and average salaries by district. It also contains sales data for the first quarter of 2010 for each of the 9 vendors, grouped by zone, with totals and averages by zone. Finally, it includes a student grade register with 10 students and their grades for Internet, Word and Excel courses.
More Related Content
More from Pahola Salas la Torre (20)
Practica reforzamiento 4
- 1. LISTADO DE VENDEDORES FECHA 1/23/2011 HORA: CODIGO APELLIDOS Y NOMBRES DISTRITO SEXO EDAD VEN001 DAVILA ANDREA TRUJILLO F 25 VEN002 MORALES ELVIS LAREDO M 22 VEN003 HONORIO JORGE MOCHE M 27 VEN004 ATOCHE CECILIA HUANCHACO F 30 VEN005 VASQUEZ HUGO TRUJILLO M 25 VEN006 TUESTA SELENE TRUJILLO F 22 VEN007 RODRIGUEZ SOLEDAD LAREDO F 30 VEN008 CARRANZA PERCY LAREDO M 25 VEN009 ROJAS DIANA HUANCHACO F 27 TOTAL CANTIDAD DE VENDEDORES 9 PROMEDIO MAXIMA MINIMA RESUMEN POR SEXO SEXO N尊 VENDEDORES PROMEDIO EDAD M 4 #MACRO? F 5 #MACRO? RESUMEN POR DISTRITO TOTAL SUELDO PROMEDIO SUELDO DISTRITO N尊 VENDEDORES BASICO BASICO TRUJILLO 3 1395 #MACRO? LAREDO 3 1427 #MACRO? MOCHE 1 500 #MACRO? HUANCHACO 2 1050 #MACRO?
- 2. 12:58:37 AM SUELDO BASICO 450 485 500 450 525 420 437 505 600 4372 485.78 600 420
- 3. VENTAS PRIMER TRIMESTRE-2010 CODIGO ZONA ENERO FEBRERO MARZO TOTAL PROMEDIO VEN001 NORTE 480 520 498 1498 499.33 VEN002 SUR 385 425 389 1199 399.67 VEN003 CENTRO 450 425 467 1342 447.33 VEN004 NORTE 526 540 489 1555 518.33 VEN005 NORTE 625 557 598 1780 593.33 VEN006 CENTRO 458 467 489 1414 471.33 VEN007 CENTRO 650 569 580 1799 599.67 VEN008 SUR 452 468 529 1449 483.00 VEN009 CENTRO 652 685 750 2087 695.67 TOTAL 4678 4656 4789 PROMEDIO 519.78 517.33 532.11 ZONA MAXIMA 652 685 750 MINIMA 385 425 389 SUR CENTRO NORTE TOTALES PROMEDIOS ZONA ZONA ENERO FEBRERO MARZO ENERO SUR 837 893 918 SUR #MACRO? CENTRO Err:504 2146 2286 CENTRO #MACRO? NORTE Err:504 1617 1585 NORTE #MACRO?
- 4. MAXIMA MINIMA 520 480 425 385 467 425 540 489 625 557 489 458 650 569 529 452 750 652 CANTIDAD VENDEDORE S 2 4 3 PROMEDIOS FEBRERO MARZO #MACRO? #MACRO? #MACRO? #MACRO? #MACRO? #MACRO?
- 5. REGISTRO DE NOTAS N尊 APELLIDOS Y NOMBRES INTERNET WORD EXCEL 01 GUIMARAY GUTIERREZ, Bherta 14 16 14 02 HUAMANI LAPA, Klisman 05 09 08 03 LINO CRISPN, Mart鱈n 05 18 17 04 LOAYZA BELTRAN, Hector 10 05 08 05 LOPEZ RUCANA, Miriam Iris 16 16 19 06 LUCUMBER BEDOYA, Estefania 19 16 15 07 MELGAREJO MIANO, Alexander 20 18 14 08 MERCEDES CALDERON, Virginia 14 17 16 09 MONTOYA ORTIZ, Patricia 18 16 19 10 MORON RIVEROS, Henrry 05 15 08 REGISTRO DE COMPRAS DE PRODUCTOS AO MES PRODUCTO TOTAL SOLES UNIDADES 1998 16-Mar COMPUTADORA S/. 1,188 4 1999 12-Apr LAPTOP S/. 4,021 6 2000 15-Feb FOTOCOPIADORA S/. 189,844 7 2001 15-May IMPRESORA S/. 1,188 8 2002 16-Jun LASER S/. 4,021 5 2003 22-Jul NEXTEL S/. 189,844 6 PROMEDIO S/. 65,017.47 CONTARA 6 MAX S/. 189,844 MIN S/. 189,844
- 6. PROMEDIO 15 07 13 08 17 17 17 16 18 09