Practica 4 Excel 2

29
CODIGO PRODUCTO CANTIDAD PRECIO IMPORTE AZOO1 DISCO DURO 250 ### ### AZOO2 LECTORA 450 ### ### AZOO3 PLACA MADRE 120 ### ### AZOO4 MEMORIA 256 ### ### AZOO5 DISCO USB 145 ### ### AZOO6 CD-ROM 245 ### ### AZOO7 DVD-ROM 85 ### ### AZOO8 MONITOR 135 ### ### AZOO9 CPU 148 ### ### AZOO10 TECLADO 256 ### ### AZOO11 MOUSE 485 ### ### AZOO12 PARLANTES 58 ### ### AZOO13 SCANNER 125 ### ### AZOO14 IMPRESORA 356 ### ### AZOO15 SUPRESOR 70 ### ###

Transcript of Practica 4 Excel 2

Page 1: Practica 4 Excel 2

CODIGO PRODUCTO CANTIDAD PRECIO IMPORTE CONDICION

AZOO1 DISCO DURO 250 S/. 360.00 S/. 90,000.00 CAZOO2 LECTORA 450 S/. 185.00 S/. 83,250.00 CRAZOO3 PLACA MADRE 120 S/. 250.00 S/. 30,000.00 CPAZOO4 MEMORIA 256 S/. 160.00 S/. 40,960.00 CAZOO5 DISCO USB 145 S/. 80.00 S/. 11,600.00 CPAZOO6 CD-ROM 245 S/. 50.00 S/. 12,250.00 CRAZOO7 DVD-ROM 85 S/. 55.00 S/. 4,675.00 CAZOO8 MONITOR 135 S/. 380.00 S/. 51,300.00 CRAZOO9 CPU 148 S/. 450.00 S/. 66,600.00 CP

AZOO10 TECLADO 256 S/. 25.00 S/. 6,400.00 CRAZOO11 MOUSE 485 S/. 20.00 S/. 9,700.00 CPAZOO12 PARLANTES 58 S/. 35.00 S/. 2,030.00 CAZOO13 SCANNER 125 S/. 250.00 S/. 31,250.00 CAZOO14 IMPRESORA 356 S/. 380.00 S/. 135,280.00 CPAZOO15 SUPRESOR 70 S/. 15.00 S/. 1,050.00 CR

Page 2: Practica 4 Excel 2

DESCUENTOOBSERVACION IGV SUBTOTAL

DESC1 DESC2 DESC3 S/. - S/. 13,500.00 S/. 2,700.00 CONTADO S/. 13,986.00 S/. 92,214.00 S/. 6,660.00 S/. - S/. 5,827.50 CREDITO S/. 7,708.95 S/. 88,028.55 S/. 3,000.00 S/. 7,500.00 S/. 3,600.00 CUOTA A PLAZOS S/. 11,148.00 S/. 32,952.00 S/. 3,276.80 S/. 6,144.00 S/. 1,228.80 CONTADO S/. 9,641.98 S/. 41,967.62 S/. 928.00 S/. 1,740.00 S/. 1,392.00 CUOTA A PLAZOS S/. 2,918.56 S/. 12,741.44 S/. 612.50 S/. 1,837.50 S/. 857.50 CREDITO S/. 2,604.35 S/. 12,953.15 S/. 233.75 S/. 1,168.75 S/. 140.25 CONTADO S/. 1,427.75 S/. 4,790.01 S/. - S/. 7,695.00 S/. 3,591.00 CREDITO S/. 8,341.38 S/. 54,244.62 S/. - S/. 9,990.00 S/. 7,992.00 CUOTA A PLAZOS S/. 11,428.56 S/. 73,153.44 S/. 320.00 S/. 960.00 S/. 448.00 CREDITO S/. 1,360.64 S/. 6,767.36 S/. 485.00 S/. - S/. 1,164.00 CUOTA A PLAZOS S/. 694.52 S/. 10,654.48 S/. 101.50 S/. 507.50 S/. 60.90 CONTADO S/. 619.96 S/. 2,079.94 S/. 3,125.00 S/. 4,687.50 S/. 937.50 CONTADO S/. 7,981.25 S/. 32,018.75 S/. - S/. - S/. 16,233.60 CUOTA A PLAZOS S/. 2,922.05 S/. 148,591.55 S/. 52.50 S/. 262.50 S/. 73.50 CREDITO S/. 328.23 S/. 1,110.27

Page 3: Practica 4 Excel 2

TOTAL

S/. 106,200.00 S/. 95,737.50 S/. 44,100.00 S/. 51,609.60 S/. 15,660.00 S/. 15,557.50 S/. 6,217.75 S/. 62,586.00 S/. 84,582.00 S/. 8,128.00 S/. 11,349.00 S/. 2,699.90 S/. 40,000.00 S/. 151,513.60 S/. 1,438.50

Page 4: Practica 4 Excel 2

N° FECHA PRODUCTO CLIENTE

1 2/1/2011 50 AGUA VIDA 500 ml. CURACAO2 2/1/2011 52 ARROZ PAISANA 750 gr. COMPESA3 2/2/2011 63 GASEOSA INKA COLA 500 ml. TAY LOY4 2/2/2011 74 AGUA VIDA 500 ml. CHIFA UNION5 2/2/2011 75 AZUCAR CARTAVIO 1 kg. CHIFA UNION6 2/3/2011 77 ACEITE DELEITE 1 lt. CHIFA UNION7 2/4/2011 80 VINO QUEIROLO- MAGDALENA MANOS MORENAS8 2/4/2011 81 ACEITE DELEITE 1 lt. ASTICA9 2/4/2011 83 CERVEZA CRISTAL- SIXPAC COMPESA

10 2/5/2011 90 CERVEZA CRISTAL- SIXPAC CURACAO

INFORME DE VENTASCURACAO S/. 8,294.90 COMPESA S/. 7,106.80 TAY LOY S/. 915.60 CHIFA UNION S/. 2,169.10 MANOS MORENAS S/. 3,695.10 ASTICA S/. 782.08

N° DE FACTURA

Page 5: Practica 4 Excel 2

10% 19%

CANTIDAD DESCUENTO I.G.V.TOTAL VENTA

500 S/. 0.80 CONTADO S/. 40.00 S/. 76.00 S/. 436.00 2/15/2011750 S/. 3.20 CREDITO S/. 240.00 S/. 456.00 S/. 2,616.00 2/15/2011700 S/. 1.20 CREDITO S/. 84.00 S/. 159.60 S/. 915.60 2/16/2011200 S/. 0.80 CREDITO S/. 16.00 S/. 30.40 S/. 174.40 2/16/2011500 S/. 2.54 CONTADO S/. 127.00 S/. 241.30 S/. 1,384.30 2/16/2011160 S/. 3.50 CONTADO S/. 56.00 S/. 106.40 S/. 610.40 2/17/2011300 S/. 11.30 CREDITO S/. 339.00 S/. 644.10 S/. 3,695.10 2/17/2011205 S/. 3.50 CONTADO S/. 71.75 S/. 136.33 S/. 782.08 2/17/2011400 S/. 10.30 CONTADO S/. 412.00 S/. 782.80 S/. 4,490.80 2/18/2011700 S/. 10.30 CREDITO S/. 721.00 S/. 1,369.90 S/. 7,858.90 2/19/2011

PRECIO ALMACEN

TIPO DE VENTA

FECHA DE VENCIMIENTO

Page 6: Practica 4 Excel 2

CODIGO APELLIDOS Y NOMBRES DISTRITOS SEXO EDAD ESTADO CIVIL

A-0001 AREVALO EDINSON Lince M 25 CA-0002 PACHECO CARLOS SURCO M 17 SA-0003 DAVILA GASDALI LA MOLINA F 15 SA-0004 SERET MARIE SURCO F 20 SA-0005 CACERES JOSE SURCO M 23 CA-0006 PALACIOS JUAN Lince M 40 VA-0007 FONSECA SSANDRA Lince F 21 SA-0008 CHUQUILLAIQUI ROBERTO LA MOLINA M 18 SA-0009 ANDRADE MILAGROS SURCO F 20 SA-0010 AGUAYO CELINDA LA MOLINA F 30 CA-0011 BALABARCA ALEXANDRA LINCE F 42 VA-0012 GANOZA MARIA LA VICTORIA F 15 SA-0013 VELASQUEZ JACQUELINE COMAS F 19 CA-0014 FUERTES GISELLA SURCO F 20 CA-0015 ACUÑA ISRAEL COMAS M 47 CA-0016 YAURI ROGER LA MOLINA M 40 CA-0017 BERGAMINO DANIEL LA VICTORIA M 17 SA-0018 AGUAYO JOSHUA LA MOLINA M 20 SA-0019 PALACIOS DAYRA SURCO F 25 VA-0020 PALACIOS KAIRA SURCO F 16 S

ESTADISTICAS GENERALES ESTADISTICAS GENERALESNUMERO DE EMPLEADOS SEXO "F" 11 NUMERO DE EMPLEADOS MAYORES DE EDADNUMERO DE EMPLEADOS SEXO "M" 9 NUMERO DE EMPLEADOS MENORES DE EDADNUMERO DE EMPLEADOS SURCO 7 EMPLEADO CON MAYORES INGRESOS DE 1800NUMERO DE EMPLADOS LINCE 3 EMPLEADO CON MENORES INGRESOS DE 1800NUMERO DE EMPLEADOS SIN DISTRITO 0 NUMERO DE EMPLEADOS SOLTEROSNUMERO DE SUELDOS >A 2500 3 NUMERO DE EMPLEADOS CATEGORIA ANUMERO DE TOTAL DE EMPLEADOS 20 SUELDO PROMEDIO DEL TRABAJADOR

Page 7: Practica 4 Excel 2

CATEGORIA DSCTO. BONIF.

S/. 4,500.00 B BUENO S/. 675.00 S/. 810.00 S/. 4,635.00 S/. 1,500.00 A REGULAR S/. 225.00 S/. 270.00 S/. 1,545.00 S/. 2,000.00 B REGULAR S/. 300.00 S/. 360.00 S/. 2,060.00 S/. 800.00 A REGULAR S/. 120.00 S/. 144.00 S/. 824.00 S/. 1,500.00 A REGULAR S/. 225.00 S/. 270.00 S/. 1,545.00 S/. 3,500.00 B BUENO S/. 525.00 S/. 630.00 S/. 3,605.00 S/. 2,000.00 B REGULAR S/. 300.00 S/. 360.00 S/. 2,060.00 S/. 1,800.00 B REGULAR S/. 270.00 S/. 324.00 S/. 1,854.00 S/. 900.00 A REGULAR S/. 135.00 S/. 162.00 S/. 927.00 S/. 1,450.00 B REGULAR S/. 217.50 S/. 261.00 S/. 1,493.50 S/. 1,000.00 B REGULAR S/. 150.00 S/. 180.00 S/. 1,030.00 S/. 850.00 B REGULAR S/. 127.50 S/. 153.00 S/. 875.50 S/. 950.00 B REGULAR S/. 142.50 S/. 171.00 S/. 978.50 S/. 1,000.00 A REGULAR S/. 150.00 S/. 180.00 S/. 1,030.00 S/. 1,700.00 B REGULAR S/. 255.00 S/. 306.00 S/. 1,751.00 S/. 900.00 B REGULAR S/. 135.00 S/. 162.00 S/. 927.00 S/. 1,000.00 B REGULAR S/. 150.00 S/. 180.00 S/. 1,030.00 S/. 1,800.00 B REGULAR S/. 270.00 S/. 324.00 S/. 1,854.00 S/. 950.00 A REGULAR S/. 142.50 S/. 171.00 S/. 978.50 S/. 4,500.00 A BUENO S/. 675.00 S/. 810.00 S/. 4,635.00

ESTADISTICAS GENERALESNUMERO DE EMPLEADOS MAYORES DE EDAD 15 MAYOR SUELDONUMERO DE EMPLEADOS MENORES DE EDAD 5 MENOR SUELDOEMPLEADO CON MAYORES INGRESOS DE 1800 7 TOTAL EMPLEADOSEMPLEADO CON MENORES INGRESOS DE 1800 13 MAYOR EDADNUMERO DE EMPLEADOS SOLTEROS 10 MENOR EDADNUMERO DE EMPLEADOS CATEGORIA A 7 EDAD REPETIDASUELDO PROMEDIO DEL TRABAJADOR S/. 1,730.00

SUELDO BASICO

PODER ADQUISITIVO

NETO A PAGAR

Page 8: Practica 4 Excel 2

LinceLincesurco

Page 9: Practica 4 Excel 2

Codigo Apellidos Nombres Edad Sexo DNI

SECRLUJNA86F Lujan Hanna 20 F 40157862EMPLMARMS22M Marquez williams 23 M 42452222CONTSUALA85F Suarez Gabriela 25 F 15437856SEGUVELAN83M Velasquez Ivan 28 M 45326836MAMTPALON89M Palomino Edson 30 M 40157896ADMIVILAN33M Vilca Julian 22 M 48525333GERECURCE87F Curi Berenice 36 F 56234875SECRPAJIA53F Pajuelo Claudia 45 F 58204536CONTOLIEL36M Olivos Angel 40 M 44525363SUPEPARÙS52M Paredes jesùs 42 M 49758525

Resumen Estadistica ContableTotal Empleados 10 Mayor Sueldo S/. 5,000.00 Total Varones 5 Menor Sueldo S/. 850.00 Total Mujeres 3 Mayor AFP S/. 550.00 Mayores de 30 4 Menor AFP S/. 93.50 Menores de 30 5 Sueldo T. Contadores S/. 3,000.00 Total Contadores 2 Sueldo T. Secretarias S/. 2,400.00 Total Secretarias 2 Sueldo T. Seguridad S/. 900.00

Page 10: Practica 4 Excel 2

CargoSueldo Basico

Escolaridad AFPSueldo Neto

Secretaria S/. 1,200.00 S/. 300.00 S/. 132.00 S/. 1,368.00 Empleado S/. 850.00 S/. 212.50 S/. 93.50 S/. 969.00 Contador S/. 1,500.00 S/. 375.00 S/. 165.00 S/. 1,710.00 Seguridad S/. 900.00 S/. 225.00 S/. 99.00 S/. 1,026.00 Mamtenimiento S/. 850.00 S/. 212.50 S/. 93.50 S/. 969.00 Administrador S/. 3,000.00 S/. 750.00 S/. 330.00 S/. 3,420.00 Gerente S/. 5,000.00 S/. 1,250.00 S/. 550.00 S/. 5,700.00 Secretaria S/. 1,200.00 S/. 300.00 S/. 132.00 S/. 1,368.00 Contador S/. 1,500.00 S/. 375.00 S/. 165.00 S/. 1,710.00 Supervisor S/. 2,000.00 S/. 500.00 S/. 220.00 S/. 2,280.00

Page 11: Practica 4 Excel 2

Codigo Apellidos Edad

A001 Vasquez 2/14/1975 1975 2 14 48A002 Aguilar 5/23/1985 1985 5 23 38A003 Fuentes 9/30/1982 1982 9 30 41A004 Quezada 3/21/1970 1970 3 21 53A005 Toribio 12/13/1950 1950 12 13 73

Fecha de Nacimiento

Año de Nacimiento

Mes de Nacimiento

Día de Nacimiento

Page 12: Practica 4 Excel 2

Cod- Alumno Nombres Edad Especialidad Categoria

AL-0101 Davila Barrientos Gasdali 18 Contabilidad BAL-0102 Arevalo Vallejos Edinson 36 Administraciòn AAL-0103 Palacios Ganoza Juan 32 Contabilidad AAL-0104 Velasquez Palomino Jacky 35 Administraciòn BAL-0105 Yauri Yupanqui Roger 33 Contabilidad BAL-0106 Acuña Lopez Erique 31 Administraciòn AAL-0107 Aguayo zenozain Celinda 28 Contabilidad AAL-0108 Aguayo zenozain Joshua 23 Contabilidad B

Apellido Paterno

Apellido Materno

Page 13: Practica 4 Excel 2

Mensualidad

S/. 600.00 S/. 96.00 S/. 504.00 S/. 700.00 S/. 84.00 S/. 616.00 S/. 600.00 S/. 60.00 S/. 540.00 S/. 700.00 S/. 126.00 S/. 574.00 S/. 600.00 S/. 96.00 S/. 504.00 S/. 700.00 S/. 84.00 S/. 616.00 S/. 600.00 S/. 60.00 S/. 540.00 S/. 600.00 S/. 96.00 S/. 504.00

Descuento Categoria

Monto a Pagar

Page 14: Practica 4 Excel 2

Apellidos Nombres Categoria Sexo Nº de Hijos Estado Civil

Martel Carlos A M 3 S 5Ortiz Emilio B M 3 C 8Lopez Karla A F 2 D 2Marquez Celia C F 2 D 9Caycho Andrea B F 1 C 10Carbajal Olga A F 3 C 12Gonzales Hector B M 4 D 15

1.- Sueldo Básico 2.-Bonificacióbn por Tiempo de Serv. 3.- Bonificación 1Categoria Sueldo Básico Tiempo de Serv. Bonificación por Categoria Nº de hijosA 3000 De 0 a 5 1.5% de Basico De 0 a 2B 2500 De 6 a 10 2.5% de Basico De 0 a 2C 2000 De 11 a más 3.5% de Basico De 3 a más

De 3 a más

5.- Bonificación po HijosCivil Hijo Bonificación

C <3 1% del Basico x C/HijoD <3 1% del Basico x C/HijoC >2 2% del Basico x C/HijoD >2 2% del Basico x C/Hijo

Caso contrario 2.5% del Basico x C/Hijo

Tiempo de Servicio

Page 15: Practica 4 Excel 2

Bonificación 1 Total Essalud

3000 S/. 45.00 S/. 270.00 S/. 180.00 S/. 225.00 S/. 3,720.00 S/. 90.00 2500 S/. 62.50 S/. 225.00 S/. 225.00 S/. 150.00 S/. 3,162.50 S/. 75.00 3000 S/. 45.00 S/. 120.00 S/. 150.00 S/. 60.00 S/. 3,375.00 S/. 90.00 2000 S/. 50.00 S/. 80.00 S/. 160.00 S/. 40.00 S/. 2,330.00 S/. 60.00 2500 S/. 62.50 S/. 50.00 S/. 87.50 S/. 25.00 S/. 2,725.00 S/. 75.00 3000 S/. 105.00 S/. 360.00 S/. 225.00 S/. 180.00 S/. 3,870.00 S/. 90.00 2500 S/. 87.50 S/. 300.00 S/. 300.00 S/. 200.00 S/. 3,387.50 S/. 75.00

3.- Bonificación 1 4.- Bonificación por CategoríaSexo Bonificación 1 Categoria Sexo BonificaciónM 1% del Basico * C/Hijo A M 2% del Basico * C/HijoF 2%del Sueldo *C/Hijo A F 2.5% de Basico * C/HijoM 3%del Sueldo *C/Hijo B M 3%del Basico * C/HijoF 4%del Sueldo *C/Hijo B F 3.5% del Basico *C/Hijo

Caso contrario 4 del Basico *C/Hijo

6.- Total = Suma del Sueldo Basico y las bonificaciones7.-Essalud = 3% del Basico8.- Netp = Total - Essalud

Sueldo Basico

Bonificación por Tiempo

de Servicio

Bonificación por Categoria Bonificación

por Hijos

Page 16: Practica 4 Excel 2

Neto

S/. 3,630.00S/. 3,087.50S/. 3,285.00S/. 2,270.00S/. 2,650.00S/. 3,780.00S/. 3,312.50

Page 17: Practica 4 Excel 2

Comercial Pacheco S.R.L.

Cliente ProductoCódigo Apellidos Nombres Código Descripción

840101 Martinez Vargas Hilario 7107 DVD Phillips931210 Cardenas Velarde Bernardo 2120 TV LCD Sony901010 Ortega Diaz Carla 4506 Minicomponente LG910102 Montes Velasquez Violeta 1170 Radio Miray840102 Alvarado Lopez Gonzalo 4501 Lavadora 11 KG Samsung880809 Gonzales Perez Hector 6709 Licuadora Imaco 2 v.960254 Vega Vega Victor 6060 Calculadora Casio963322 Islas Martinez Luisa 4612 Relog citizen

Page 18: Practica 4 Excel 2

Comercial Pacheco S.R.L.

Producto Descuentos I.G.V.Precio de venta S/. Descuento 1 Descuento 2 Descuento 3

S/. 150.00 S/. 7.50 S/. 15.00 S/. 15.10 S/. 37.60 S/. 21.36 S/. 980.00 S/. 147.00 S/. - S/. 196.20 S/. 343.20 S/. 120.99 S/. 500.00 S/. 75.00 S/. 50.00 S/. 50.10 S/. 175.10 S/. 61.73 S/. 124.00 S/. 18.60 S/. 12.40 S/. 12.50 S/. 43.50 S/. 15.30 S/. 630.00 S/. 31.50 S/. 126.00 S/. 63.10 S/. 220.60 S/. 77.79 S/. 256.00 S/. 12.80 S/. 25.60 S/. 25.70 S/. 64.10 S/. 36.46 S/. 120.00 S/. 18.00 S/. 12.00 S/. 12.10 S/. 42.10 S/. 14.80 S/. 160.00 S/. 24.00 S/. 16.00 S/. 16.10 S/. 56.10 S/. 19.74

Total Descuentos

Page 19: Practica 4 Excel 2

Comercial Pacheco S.R.L.

Total a Pagar S/. 133.76 S/. 757.79 S/. 386.63 S/. 95.80 S/. 487.19 S/. 228.36 S/. 92.70 S/. 123.64

Page 20: Practica 4 Excel 2

Lista de Empleados

Apellidos y Nombres Estado Civil Observación

Martinez Ariza, Alberto C CASADO Tabla de ValoresCardenas Villaran, Rosa S CASADO C casadoOrtega Calixto, Alfonso C SOLTERO S solteroHuaytalla Lapa, Carlos V CASADO V viudoMorilla Acosta, Maria S VIUDO

Page 21: Practica 4 Excel 2

Tabla de ValoresCASADOSOLTEROVIUDO

Page 22: Practica 4 Excel 2

Codigo Descripción Precio ProductosAD011 Equipo S/. 520.00 TV EquipoAD012 DVD #N/A S/. 680.00 S/. 520.00 A205 PC S/. 999.00 A305 DVD #N/AA560 PC S/. 999.00 AB52 Equipo S/. 520.00

Page 23: Practica 4 Excel 2

ProductosDVD PC S/. 120.00 S/. 999.00

Page 24: Practica 4 Excel 2

Codigo A003Cargo Contador

Codigo CargoA001 Gerente A002 AdministradorA003 ContadorA004 SupervisorA005 SecretariaA006 Asistente

Page 25: Practica 4 Excel 2

VENTAS DEL MES

COD. VEND. COD. PROD. PRODUCTO PRECIO CANTIDAD TOTALV-01 P-01 IMPRESORA S/. 250.00 10 S/. 2,500.00 V-05 P-04 PLOTTER S/. 350.00 15 S/. 5,250.00 V-02 P-01 IMPRESORA S/. 250.00 18 S/. 4,500.00 V-04 P-03 MOUSE S/. 9.00 25 S/. 225.00 V-03 P-04 PLOTTER S/. 350.00 10 S/. 3,500.00 V-02 P-02 MON ITORES S/. 270.00 8 S/. 2,160.00 V-05 P-01 IMPRESORA S/. 250.00 12 S/. 3,000.00 V-01 P-03 MOUSE S/. 9.00 18 S/. 162.00 V-03 P-01 IMPRESORA S/. 250.00 13 S/. 3,250.00 V-04 P-04 PLOTTER S/. 350.00 11 S/. 3,850.00

COD. PROD. PRODUCTO PRECIOP-01 IMPRESORA S/. 250.00 P-02 MON ITORES S/. 270.00 P-03 MOUSE S/. 9.00 P-04 PLOTTER S/. 350.00

V-01 V-02 V-03 V-04VENDEDOR WALTER JUANITA MASIEL ERIKACOMISION 9% 12% 8% 14%

PRODUCTO Y PRECIO: OBTENERLA DE LA 1° TABLATOTAL: PRECIO X CALIDADVENDEDOR: OBTENERLA DE LA 2° TABLACOMISION: OBTENERLO DE LA 2° TABLA YMULTIPLICARLO POR ELTOTA

Page 26: Practica 4 Excel 2

VENTAS DEL MES

VENDEDOR COMISIONWALTER 225CASQUERO 315JUANITA 540ERIKA 31.5MASIEL 280JUANITA 259.2CASQUERO 180WALTER 14.58MASIEL 260ERIKA 539

V-05CASQUERO

6%

OBTENERLA DE LA 1° TABLAPRECIO X CALIDADOBTENERLA DE LA 2° TABLAOBTENERLO DE LA 2° TABLA YMULTIPLICARLO POR ELTOTA

Page 27: Practica 4 Excel 2
Page 28: Practica 4 Excel 2