Taller Excel 5

download Taller Excel 5

of 19

description

practicas

Transcript of Taller Excel 5

suma si caso 1EmisorDestinoValorPedroInternacional800MariaNacional100MariaNacional200PedroInternacional1890PedroNacional250JorgeNacional320MariaInternacional1800JorgeInternacional2580PedroInternacional3580JorgeNacional200MariaNacional300JorgeNacional300PedroNacional250MariaInternacional1500JorgeNacional100PedroInternacional1890MariaNacional250PedroInternacional2550Calcule el valor total de las llamadas que hizo JorgeCalcule el Valor de las llamadas Internacionales mayores a 300:Calcule el Valor de las llamadas Nacionales menores a 500

suma si caso 2ReginVentasMedioMontoNorteDetalleEfectivo10CentroDetalleCheque20SurDetalleA Plazo10NorteMayorEfectivo15CentroMayorCheque10SurMayorA Plazo10CentroMayorCheque5NorteMayorEfectivo15CentroDetalleEfectivo5SurDetalleA Plazo30CentroDetalleCheque20Totalizar montos de ventas de regiones del norteTotalizar montos de ventas en efectivoTotalizar montos de ventas al detalle

referencia caso 1EjercicioLlene la tabla siguiente, tomando en cuenta los datos sgtes:

Euro$ 750I.V.A.19%UF$ 24,000

ArticuloValor en $Valor en EuroValor en UFIVATotal en $Computador 1$ 500,00066721$ 95,000Computador 2$ 540,00072023$ 102,600Computador 3$ 650,00086727$ 123,500Computador 4$ 700,00093329$ 133,000Computador 5$ 450,00060019$ 85,500Computador 6$ 730,00097330$ 138,700Computador 7$ 800,0001,06733$ 152,000Computador 8$ 864,5001,15336$ 164,255Computador 9$ 280,00037312$ 53,200Computador 10$ 780,0001,04033$ 148,200Total8,3932621,195,9550

Clasificacion de la ProduccinConfecciones DinoFecha de ElaboracinSemanaDiaMesAo

EmpleadoLunesMartesMircolesJuevesViernesSbadoTotalCategoraPedro101548453047195medioJuan536142307045301buenoNicforo3538806914243407extraordinarioBelarmino452937151272210medioNemopuceno484618425557266medioCrisstomo54495984244256medioTotal2452382842093513081635Observaciones

Mximo5461806914272407Mnimo10151881243195Promedio414047355951273

Produccin0190bajo191300medio301350bueno351400excelente401y mas extraordinario

buscarv caso 1MUEBLERIA TRONCOSOVENTAS ENERODLAR650IVA19%FechaCodigoProductoCantidadPrecio U$SSubtotal U$SIVA U$STOTAL U$STOTAL $Comentario1/3/12103101/4/12102151/5/12101301/6/12103501/7/12104251/8/12102121/9/12102101/10/12103201/11/12104101/12/12101501/13/12102401/14/12102201/15/1210415

CodigaProductoPrecio Unit. U$STotal Gral $101Silla25Promedio de ventas $scComoda200Venta mas Grande $103Ropero400Venta mas Chica $104Meso150

buscarv caso 2Excursiones - Registro de PasajerosCodigo ExcursionCIApellidoDestinoFecha SalidaHotelPrecioEdadDescuentoTotalA00122345698Perez1/10/0723A00222345699Suarez1/10/0750A00322345700Aguirre1/2/0760A00422345701Benitez1/2/0745A00222345702Rodriguez1/2/0721A00522345703Alvarez1/10/0740A00122345704Sorrento1/2/0751A00222345705Romero1/15/0722A00322345706Ferrero1/10/0720A00422345707Porzio1/2/0764A00122345708Martinez1/15/0723A00222345709Valdez1/10/0774A00322345710Miranda1/2/0735A00422345711Juarez1/15/0730A00522345712Jimenez1/15/0732Tabla de ReferenciasCodigo ExcursionesDestinoHotelPrecio U$SA001BarilocheArmon Suites900A002CordobaSheraton700A003ChileHilton800A004MendozaBalmoral750A005Rio de JaneiroHoliday Inn1200descuentomayor 50 aos 25%menor de 25 aos 20%

ficha personalBuscar registro

Escriba el N del registro100

NOMBRE APELLIDOSCEDULACUMPLEAOSDIRECCONTELEFONOEMAIL

Datos Personales sociosREGISTRONOMBRE APELLIDOSCEDULACUMPLEAOSDIRECCONTELEFONOEMAIL100Hector William ROJAS ISAZA5,590,75014-May-46Cra 46 80-14 Campo Valdes2122552 2332116.101Francisco ARIAS ARIAS13,878,42910-Oct-50Cra 90 43-38, Edif Porton de Venecia, apt 401 la [email protected] NEIRA CHACON13,885,2008-Jan-56Cra 29B 39sur -144 El embrujo Envigado2709313.103Alcibiades CAVIEDES17,111,70630-Jul-44Cra 76 30A-36 apt 301 Parque [email protected] BUITRAGO BUITRAGO13,818,5014-Sep-51Cra 93B 38-66 La Alborada2532841.105Manuel Jos AGUDELO SUAREZ3,452,0032-May-55Calle 106 66-06 Urb Cratamira, Florencia4716577.106Jos De Jess Rodriguez Chaverra3,605,04211-Feb-44Calle 48cc 102B-49 San Javier El Socorro252 79 70.107Hector Pertuz Alean2,057,730SE RETIRO108Mara de los Angeles GAVIRIA VDA C.27,994,88517-Oct-28Carrera 77E 48B-184 apt 301, Edificio Dayandres264 41 12.109Alba Luca VELZ51,656,59019-Jun-59Cra 82B 48BB 10Calasanz piso 2 [email protected] Leon MONTOYA QUINTERO533,8906-Nov-34Calle 52 77c - 11 Estadio 2234 46 [email protected] Alberto CASTAO CAMPILLO8,247,62225-May-43Cra88A 34A-36, apt 101 edf Victoria, Barrio Almeria, Laureles 4966789.112Enrique Omar GAVIRIA GOMEZ8,274,79124-Nov-46Calle 29 41- 98, apt 301 Poblado San Diego3814582.113Heriberto RODRIGUEZ ROA13,879,76112-Feb-52Cra 43C 2sur -33 Torre B apt 402 Rondas de Oviedo [email protected] AFANADOR SARMIENTO13,879,44426-Aug-49Calle 45sur 41B - 04, La Paz, Envigado3328138115Flix Adolfo Rubio 5,590,2199-Jun-46Calle 19 81 - 27, Belen la [email protected] MUOZ QUIONES13,884,59824-Jul-56Calle 44Sur 47 - 18 Condominio 9 apt 419, Urb Milan Envigado 3311757117Edinson PAVA RUIZ13,881,50522-Nov-52Cra 43A 49D sur - 82 apt 1105 Tierra Blanca3780402 [email protected] de Jesus QUNTERO 3,747,518SE RETIRO119David JIMENEZ GARCIA 13,805,1216-Feb-49Calle 29 41-98 apt 1803 Poblado San [email protected] MACHADO SANCHEZ7,481,45723-Jan-54Cra 86A 34-86 Simon Bolivar2532556.121Gustavo de Jess DELGADO15,362,52418-Apr-51Cra 82A 21-159 Belen Palma3429359.122Alberto Antonio CORTINEZ CORREA15,363,63414-enr-57Calle 93 49B - 26 Aranjuez5220351 5270403.123Alonso BADILLO SUAREZ5,590,99012-May-47Cra 83 54-19 Bloque 1 apt 501, Calasanz, Estadio [email protected] Calasanz ARIAS PUERTA12,575,76026-Aug-43Calle 31 81A - 51 patios de la Castellana 3416307.125Miguel Angel HENAO GRANDA79,140,73520-Jun-54Calle 19A 80-174 apt 201 Belen La Gloria2383492 2852782.126FranciscoAdolfo RENDON RIVERA3,621,65622-Apr-57Calle 30A 75 - 34 Belen2384363.127Heli PORRAS DUARTE13,880,8096-Jul-52Cra 78 33-17 apt 401 Edificio porton de Laureles4115022.128Luis Eduardo HERNANDEZ FERREIRA13,889,5565-Mar-59Barrio la magnolia, Trvs 32B 33A sur - 46, apt 2012707270.129Margarita GONZALEZ GONZALEZ37,930,4567-Apr-48Calle 48cc 102b -69 San [email protected] BALDOVINO HOLGUIN17,146,38528-May-46Cra 65F 32A - 39 Belen [email protected] CORDON HERNANDEZ13,438,68328-Dec-55Cra 34 75sur-35, [email protected] Turiano NOVOA ESPEJO7,425,74817-May-45Cra 81 54A - 55 apt 106 [email protected] RAMOS SUBERO5,588,1988-Oct-43Calle 46 44 - 29, barrio asturias, Itagui2776122.134Jos Francisco FERNANDEZ JOHNS4,976,8508-Jun-42Calle 44 86 - 32 apt 1010, La [email protected] Cesar BEDOYA SALDARRIAGA13,879,19714-Aug-51Calle 35 82A - 38 Simon [email protected] Elena RODRIGUEZ SOLANO27,607,39324-Oct-42Calle 31 76-52 apt 207, Edf Portal de Belen Parque [email protected] Mara MARIN SARMIENTO28,007,86015-Jul-47Cra 63A 94A-377 Bl31 apt 404 [email protected] Jos AGUILAR SANABRIA13,875,77124-Sep-48Cra 75 42 - 63 apt 201, Laureles416 72 34.139Ricardo Antonio FUENTES CABADIA6,863,0807-Dec-49Circular 4 69 - 52 San [email protected] Ines GARCIA RESTREPO28,006,89316-Sep-45Cra 76 74 - 07 apt 801, Laureles 416 16 [email protected] Eliecer HENAO ECHAVARRIA70,103,7153-Dec-54Cra 91B 34E - 107 Santa [email protected] Orlando LOPEZ DURANGO3,621,1036-Aug-52Calle 66 40 - 59 Villa Hermosa2542907/9032 8541276.143Elodia Esperanza NAVARRO ESTEBAN27,954,1038-Feb-45Cra 17 33 - 71 Buenos Aires 2213114SE RETIRO144Gloria Isabel LEON PINZON37,917,4774-Feb-56Calle 5sur 22-290 apt 327 Torre1, Aguas del Bosque3536923.145Jorge Eliecer SARMIENTO VARGAS13,876,09620-Apr-49Calle 32EE 80C - 53 apt 401 La [email protected] ARDILA SALAZAR13,877,92413-Aug-50Carrera 70 26A - 33 apt 702 torre2, Belen Rosales3438897.147Evelio de Jess CUERVO ZULETA70,850,1181-May-55Transversal 74 circular 4 - 32 apt 201, [email protected] TUIRAN IBARRA8,280,05919-Oct-47Cra 90AA 65EE - 65 Robledo la [email protected] RINCON BALLESTEROS13,881,72930-Jul-53Cra 65 16 - 86 San Pablo2654871.150Pedro Antonio CUERO MOLANO16,465,49816-Nov-51Calle 7 70 - 500 Ubr El Enclave blq 23 apt 114. [email protected] JAIMES REY13,878,7049-Jan-51Cra 42D 45BSur-80 Trr 2 apt 607 Cid Por de la Paz Envigado ciudadela porton [email protected] Victoria LEON ROYERO37,920,42627-Jun-56Cra 28 3 -2 28 casa 158 Loma el tesoro Poblado [email protected] Alberto TOBON ARANGO8,395,49711-Nov-56Cra 51 58 - 48 Andalucia, Bello2756061 453 70 [email protected] Eladio JARAMILLO ESCUDERO8,398,1941-Oct-54Calle 29 41 - 98 apt 1104 Poblado de San [email protected] Arturo CEPEDA DURAN13,840,7404-Jun-56Cra 82C 30A - 100 apt 1103, Torre de Vicua2380648.156Jose Reinaldo BUSTAMANTE CASTRO70,320,36824-Jul-52Cra 86 49E - 55 Calasanz Campestre4460475 289 48 [email protected] de Jess CARMONA GIL8,398,97121-May-56Calle 9Sur 32-310 apt103, Poblado Edf Prados del Castillo3526533ncarmona@epm,net.co158Freddy ARAUJO MOJICA19,268,6029-Jul-55Calle 37A 88 - 26, Santa Monica4933902 4137057.159Ligia SERRANO VDA DE BERGSNEIDER28,002,26016-Jan-23Calle 23sur 44 - 66 Bosques de Zuiga, Envigado2707432.160Hugo Alberto SALAZAR BOTERO10,213,6372-Aug-48Calle 15 79 - 120 apt 213 Belen (Loma de los Bernal)[email protected] GARRIDO DE ACOSTA28,017,4978-Mar-40Cra 83A 48BB - 81 Calazans Urb Torre Montana4212415.162Robinson CAMACHO VILLARREAL- BGTA13,808,360Cra 38A 125A - 75 atabanza 2 I8 apt 101Bt 6435758.163Hermes MORENO RUIZ13,878,9609-Feb-51Cra 41B 30B - 110 Nucleo 3 apt 212C, ciudadela [email protected] Antonio CALA GMEZ13,886,03529-Jan-56Carrera 77 38-27 apt 101, Edf El Muelle ,Laureles4141764.165Jos Manuel VILLAFAE FOSTER2,057,66720-Sep-27Calle 36 64A - 34 apt 601, Conquistadores2358339.166Mercedes Rubilda Mosquera Mosquera26,327,27620-Sep-50Diagonal 43 38A - 53 int 7 apt 402 1 etapaBt 222 7298.167Mesias GARZON VALLEJO2,053,2576-Jul-29Cra 64 96A - 110 Tricentenario, bloque 73 apt 4042670411.168Jose Alirio LOPEZ5,561,68930-Sep-45Calle 37 64A - 14, [email protected] Joaquin GOMEZ VIDAL4,511,82913-Aug-44Calle 11sur 29 - 30, El [email protected] Eduardo PRADA PRADA5,556,59721-Dec-43Calle 60 77A - 100 casa 27, Urb Almendros de la [email protected] VASQUEZ DE CAMPOS28,006,81931-Mar-45Transversal 37 71 - 126 apt 202, [email protected] Antonio GIRALDO LOTERO8,248,60521-Feb-42Calle 4 18 - 230 casa 164, Jardines de la calera, [email protected] POSSO GARRIDO10,056,88917-Jul-44Calle 23sur 44 - 66 Bosques de Zuiga2707432.174Ismael ACOSTA ARRIETA13,800,8159-May-47Cra 80 33AA - 36 apt 502, [email protected] Aurelio GOMEZ OSORIO3,331,3871-Apr-31Circular 74 39B - 31, Laureles [email protected] Nancy MELLAN CORREA37,919,67925-Nov-582705508SE RETIRO177Martha Ines RESTREPO BURITICA41,430,53411-Aug-48Circular 73B 76E - 18 apt 601 Ed San Esteban, [email protected] Arturo DIAZ GONZALEZ5,550,47624-Sep-41Cra 64A 48 - 25 apt 903 Suramericana 7, [email protected] HENAO OSPINA2,050,87411-Mar-27Transversal 74 C2 - 215, Laureles apt 204 4125143.180Aida LAMBRAO DE RODRIGUEZ28,007,76712-Dec-46Calle 10 30 - 210 apt 703, Poblado, Bosques de la concha2662655.181Gustavo BARAJAS BARAJAS5,557,9141-Jul-44Diagonal 75B 32BB - 32 Alameda4126696 4128438.182Ovidio Santana Calderon17,001,536SE RETIRO183Diego BURITICA VALENCIA6,137,1478-Sep-50calle 37A [email protected] DAVILA SANTANA13,875,70223-Sep-48Cra 76 32F - 23, Laureles [email protected] de Jess GALLON RESTREPO6,208,72214-Dec-50Cra 78 34A - 56 apt 501, Laureles [email protected] Dario ARIAS PUERTA8,313,02021-Nov-50Cra 26 16Bsur - 57, [email protected] Alonso MOLINA LPEZ8,299,87014-Sep-48Calle 38A 80- 72 apt 701, Laureles250 45 [email protected] Angel ZULUAGA MARIN10,063,5296-Dec-47Cra 45 48 - 51 apt 7A, [email protected] GOMEZ RUEDA13,883,31726-Aug-54calle 29 41 - 98, apt 1704, Edf Poblado de San [email protected] Antonio MERIZALDE EUSSE8,245,75021-Sep-42Calle 45D 79 - 41, Los [email protected] VARGAS PUELLO5,589,1726-Nov-44Calle 40 82A - 71 apt 101,Edf Villa Maria 2, Simon Bolivar2505141 [email protected] OROZCO LEON7,461,08418-Mar-52Calle 3 25 - 151 apt 203 Ed Barcelona, El Poblado3172647 [email protected] CARDONA CANO70,051,9344-Jul-53Cra 35 16Asur - 194 Casa 11 La Primavera, El [email protected] Ral GOMEZ CALDERON17,193,42728-Oct-47Calle 1 45 - 120,apt 707 BL 3 Condominio la Vega, El [email protected] Hosman VIANA OVIEDO13,883,17821-Jul-54Cra 66 36 - 06 apt 502, [email protected] Roberto BASTILLA ESPINOSA13,876,62411-Oct-48Calle 5 76A - 97Altirio de los Bernal, Torre 2 apt 6083543270.197Rodrigo MARTINEZ CARAZO9,069,3227-May-49Cra 91B 34E - 77 2 piso, Santa Monica2529633 3240679 [email protected] Anibal ORTIZ ARROYAVE2,705,4194-Dec-39Cra 4 66B - 16 apt 301, San Joaquin2303275.199Gustavo de Jess LOPEZ GUARIN13,878,28819-Apr-50Cra 63A 34 - 65, [email protected] de Jess CARDENAS RODRIGUEZ17,147,45716-Jun-04Calle 29 41 - 98 apt 1206, Poblado de San [email protected] Jesus SUAREZ ACEVEDO13,821,52024-Jun-52Carrera 77 34A - 70 apt 402, Laureles 411 71 [email protected] Arturo GONZALEZ CALLE10,216,96825-Dec-47Cra 77 35 - 28, Laureles2506381 [email protected] BERGSNEIDER SERRANO63,277,8639-Nov-55Calle 23sur 44 - 66 Bosques de Zuiga2707432.204Mara Elena RODRIGUEZ VDA DE ARRIETA28,008,7358-Agto-48Cra 93 44 -31 [email protected] Fernando RESTREPO VALDERRAMA3,621,1714-Dec-52Calle 275 28 - 131 casa 95, [email protected] Jos MANTILLA CARRILLO13,878,43011-Apr-50Cra 48 32sur - 36 apt 202 Portal [email protected] Javier LONDOO GUARIN8,278,35729-Mar-47Cra 80C 40-106 Belen 4137049.208Jess Angel JARAMILLO JARAMILLO3,620,28918-Feb-42Calle 37A 84A - 37, Simon Bolivar4163850 [email protected] Octavio QUINTERO ARIAS13,875,19113-Dec-47Calle 20 sur 41aa - 161 apt 1205 Portal de la Frontera, Poblado3130066 2321776 [email protected] Carlos SALAS TOROSE RETIRO211Jos DIAZ VILLADA6,083,2531-May-41Diagonal 75A 2 - 35, Kalamari 22564834.212William Sanchez Rojas8,215,7672-Sep-40Calle 78 71 - 93, Bosques de San Pablo, Robledo2573564.213Cecilia RESTREPO DE BOLIVAR21,543,99226-Jun-38Calle 25 57A - 61, La Cabaita2739412.214William Hernando GOMEZ VALENCIA3,446,18817-Mar-56Calle 15A 83 - 33, Belen [email protected] MARTINEZ PEDROZO13,881,55410-Mar-52Calle 8sur 83A - 83614905.216Stella SANCHEZ VDA DE QUINTERO41,630,19215-Jun-54Avenida 44 55 - 46, Bello Niquia4815874.217Francisco Fabian VELAZQUEZ RAMIREZ4,430,0707-May-58Calle 47D 70 - 7, Florida Nueva2601640 2352062.218Luis Alfedredo Herrera AtehortuhaSE RETIRO219Eudato Antonio RESTREPO SANCHEZ4,975,82610-Agot-41Calle 17 80B - 56, Belen La Nubia 2560877.220Jairo VALLEJO TOBON502,48928-Jan-32Calle 75 72B - 101 casa 120, La [email protected] Enrique GOMEZ MORENO19,186,0261-Jun-51Diagonal 75DD 4 - 25B 53 apt 502, Urb La Mota3414139 [email protected] LAGOS GRISALES21,255,77915-May-33Cra 80A 34 - 19, Laureles 2503157223Antonio Hernan LORA LUZ19,223,95711-Feb-53Calle 29 41 - 98, apt 1703, Poblado de San [email protected] Stella MEJIA MEJIA21,953,0492-Aug-55Cra 76 51 - 60, Estadio4361301225Jose Durabio REYES MOSCOSO14,223,9408-Dec-57Calle 78sur 40-210 [email protected] William GIL LOPEZ 14,954,4739-Feb-49Cra 63AA 42 - 90, Conquistadores [email protected] MORENO GALVIS10,073,51814-Mar-52Calle 49E 83A - 171, [email protected] Javier RAMIREZ RAMIREZ8,276,32015-Jul-47Circular 74 76E - 8 apt 101, [email protected] Enrique AGUIRRE8,309,32019-Jul-50Cra 83E 17 - 44Belen [email protected] Humberto PALACIO CUARTAS8,317,05616-Dec-50Cra 37 66 - 8 Villa Hermosa2545884 2847351231Luis Fernando HERNANDEZ RESTREPO8,342,7281-Jan-45Calle 40DDsur 41A - 05 apt 301 El Dorado Envigado3332932232Jorge Delio BETANCUR PELAEZ15,360,2203-Feb-49Cra 39D 47Asur 22, Triarion, Envigado3328579SE RETIRO233Anibal DURAN CABRERA17,134,75317-Jul-45Cra 78 51 -14 Los Colores 4212357 [email protected] Jos AGUIRRE ORTEGA13,876,8221-Oct-49calle 4sur 48 - 110 vegas del Poblado Bl 3 apt [email protected] Garcia Guzman 13,254,89010-Jan-54Cra 71 44 - 24 Florida Nueva250 64 65236Aura Mara ESCOBAR PAEZ37,175,99310-Jun-62Carrera 66 52B - 23 Barrio el carmelo Urb Florida Verde 2752242237Ovidio MORENO GOMEZ8,301,76218-Jan-04Cra 32B 10 -99 apt 232312 03 [email protected] Luis ORTIZ PETRO8,293,90318-May-49Cra 29A 136Dsur - 11, urbanizacin San Gabriel, Envigado.3025634 [email protected] Ismenia MARTINEZ DURAN37,817,03428-Nov-52Cra 32B 10 -99 apt 232312 03 [email protected] RUEDA DE CHAPARRO37,824,23119-Agt-53Cra 45 15sur - 38 apt 604 Santa Maria de los Angeles, Poblado. 313 37 [email protected] Luis BERMUDEZ CUNHA3,706,3757-Jul-355371284SE RETIRO242Juan Pablo PEALOZA DELGADO5,585,34928-Sep-40Calle 33 83-37 apt 902 Castellana Real411 30 [email protected]