funciones_basicas_busqueda

16
REPORTE DE EQUIPOS VENDIDOS EQUIPO PRECIO S/ CANTIDAD MONTO S/ IMPUESTO S/ IMPRESORA S/. 400.00 250 ### S/. 7,000.00 LAPTOP ### 300 ### S/. 48,000.00 PROYECTOR ### 50 ### S/. 15,000.00 PROYECTOR ### 70 ### S/. 21,000.00 PC ### 156 ### S/. 11,700.00 PROYECTOR ### 116 ### S/. 34,800.00 PC ### 199 ### S/. 14,925.00 LAPTOP ### 124 ### S/. 19,840.00 LAPTOP ### 160 ### S/. 25,600.00 PRECIO S/ IMPUESTO % LAPTOP S/. 2,000.00 8% PC S/. 1,500.00 5% PROYECTOR S/. 3,000.00 10% IMPRESORA S/. 400.00 7%

Upload: clayton-farias

Post on 04-Dec-2015

217 views

Category:

Documents


0 download

DESCRIPTION

excel ejercicio

TRANSCRIPT

Page 1: FUNCIONES_BASICAS_BUSQUEDA

REPORTE DE EQUIPOS VENDIDOSEQUIPO PRECIO S/ CANTIDAD MONTO S/ IMPUESTO S/

IMPRESORA S/. 400.00 250 S/. 100,000.00 S/. 7,000.00LAPTOP S/. 2,000.00 300 S/. 600,000.00 S/. 48,000.00PROYECTOR S/. 3,000.00 50 S/. 150,000.00 S/. 15,000.00PROYECTOR S/. 3,000.00 70 S/. 210,000.00 S/. 21,000.00PC S/. 1,500.00 156 S/. 234,000.00 S/. 11,700.00PROYECTOR S/. 3,000.00 116 S/. 348,000.00 S/. 34,800.00PC S/. 1,500.00 199 S/. 298,500.00 S/. 14,925.00LAPTOP S/. 2,000.00 124 S/. 248,000.00 S/. 19,840.00LAPTOP S/. 2,000.00 160 S/. 320,000.00 S/. 25,600.00

PRECIO S/ IMPUESTO %

LAPTOP S/. 2,000.00 8%

PC S/. 1,500.00 5%

PROYECTOR S/. 3,000.00 10%

IMPRESORA S/. 400.00 7%

Page 2: FUNCIONES_BASICAS_BUSQUEDA

REPORTE DE EQUIPOS VENDIDOSDESCUENTO S/

S/. 5,000.00S/. 60,000.00S/. 10,500.00S/. 14,700.00S/. 28,080.00S/. 24,360.00S/. 35,820.00S/. 24,800.00S/. 32,000.00

DESCUENTO %

10%

12%

7%

5%

Page 3: FUNCIONES_BASICAS_BUSQUEDA

LISTADO DE EMPRESAS CAPACITADAS

CLIENTE MONTO S/ DESCUENTO S/

INTERCORP 31 S/. 80.00 S/. 2,480.00 S/. 223.20INTERCORP 19 S/. 80.00 S/. 1,520.00 S/. 136.80TKTIC 24 S/. 65.00 S/. 1,560.00 S/. 93.60EDUCLICK 40 S/. 70.00 S/. 2,800.00 S/. 196.00EDUCLICK 29 S/. 70.00 S/. 2,030.00 S/. 142.10EDUCLICK 37 S/. 70.00 S/. 2,590.00 S/. 181.30INTERCORP 36 S/. 80.00 S/. 2,880.00 S/. 259.20CIVTI 35 S/. 50.00 S/. 1,750.00 S/. 70.00TKTIC 17 S/. 65.00 S/. 1,105.00 S/. 66.30EDUCLICK 25 S/. 70.00 S/. 1,750.00 S/. 122.50INTERCORP 23 S/. 80.00 S/. 1,840.00 S/. 165.60

EDUCLICK TKTIC

PRECIO S/ S/. 70.00 S/. 65.00

DESCUENTO % 7% 6%

CANTIDAD DE PERSONAS

PRECIO X PERSONA

Page 4: FUNCIONES_BASICAS_BUSQUEDA

INTERCORP CIVTI

S/. 80.00 S/. 50.00

9% 4%

Page 5: FUNCIONES_BASICAS_BUSQUEDA

CUADRO DE VENTAS DEL PRIMER TRIMESTRE DEL 2015CODIGO VEHÍCULO AÑO COLOR ORIGEN CANTIDAD PRECIO S/.

X001 Auto 1995 Rojo Alemania 120 S/. 18,000.00 X002 Camioneta 1990 Azul Chile 60 S/. 38,000.00 X003 Motocicleta 1980 Verde Japón 80 S/. 3,500.00 X004 Auto 1995 Rojo Alemania 40 S/. 18,000.00 X005 Deportivo 1998 Azul Japón 100 S/. 35,000.00 X006 Camioneta 1990 Azul Alemania 150 S/. 38,000.00 X007 Motocicleta 2000 Verde Japón 140 S/. 3,500.00 X008 Auto 1999 Rojo Chile 160 S/. 18,000.00 X009 Deportivo 2001 Azul Japón 90 S/. 35,000.00 X010 Auto 2002 Rojo Alemania 85 S/. 18,000.00 X011 Camioneta 1999 Azul Japón 100 S/. 38,000.00 X012 Motocicleta 2001 Verde Alemania 95 S/. 3,500.00 X013 Deportivo 2002 Rojo Japón 85 S/. 35,000.00 X014 Camioneta 1995 Azul Chile 120 S/. 38,000.00 X015 Motocicleta 1997 Azul Japón 150 S/. 3,500.00 X016 Auto 1998 Verde Alemania 125 S/. 18,000.00 X017 Deportivo 1997 Rojo Japón 130 S/. 35,000.00 X018 Auto 2000 Azul Alemania 120 S/. 18,000.00

VEHÍCULOS

VEHÍCULOS PRECIO S/. FLETE % PAISES

Auto S/. 18,000.00 10% ORIGEN DESCUENTO %

Camioneta S/. 38,000.00 20% Alemania 15%

Deportivo S/. 35,000.00 5% Japón 12%

Motocicleta S/. 3,500.00 15% Chile 10%

G2
ING. ISAIAS: Se calcula usando la FUNCION BUSCARV(), tomando como referencia la columna VEHÍCULO.
Page 6: FUNCIONES_BASICAS_BUSQUEDA

CUADRO DE VENTAS DEL PRIMER TRIMESTRE DEL 2015MONTO S/. FLETE S/. DESCUENTO S/. TOTAL S/.

S/. 2,160,000.00 S/. 216,000.00 S/. 324,000.00 S/. 1,620,000.00 S/. 2,280,000.00 S/. 456,000.00 S/. 228,000.00 S/. 1,596,000.00 S/. 280,000.00 S/. 42,000.00 S/. 33,600.00 S/. 204,400.00 S/. 720,000.00 S/. 72,000.00 S/. 108,000.00 S/. 540,000.00 S/. 3,500,000.00 S/. 175,000.00 S/. 420,000.00 S/. 2,905,000.00 S/. 5,700,000.00 S/. 1,140,000.00 S/. 855,000.00 S/. 3,705,000.00 S/. 490,000.00 S/. 73,500.00 S/. 58,800.00 S/. 357,700.00 S/. 2,880,000.00 S/. 288,000.00 S/. 288,000.00 S/. 2,304,000.00 S/. 3,150,000.00 S/. 157,500.00 S/. 378,000.00 S/. 2,614,500.00 S/. 1,530,000.00 S/. 153,000.00 S/. 229,500.00 S/. 1,147,500.00 S/. 3,800,000.00 S/. 760,000.00 S/. 456,000.00 S/. 2,584,000.00 S/. 332,500.00 S/. 49,875.00 S/. 49,875.00 S/. 232,750.00 S/. 2,975,000.00 S/. 148,750.00 S/. 357,000.00 S/. 2,469,250.00 S/. 4,560,000.00 S/. 912,000.00 S/. 456,000.00 S/. 3,192,000.00 S/. 525,000.00 S/. 78,750.00 S/. 63,000.00 S/. 383,250.00 S/. 2,250,000.00 S/. 225,000.00 S/. 337,500.00 S/. 1,687,500.00 S/. 4,550,000.00 S/. 227,500.00 S/. 546,000.00 S/. 3,776,500.00 S/. 2,160,000.00 S/. 216,000.00 S/. 324,000.00 S/. 1,620,000.00

H2
ING. ISAIAS: Se calcula multiplicando la CANTIDAD * PRECIO S/
I2
ING. ISAIAS: Se calcula usando la FUNCIÓN BUSCARV(), tomando como referencia a la columna VEHÍCULO
J2
ING. ISAIAS: Se calcula usando la FUNCIÓN BUSCARV(), tomando como referencia la columna ORIGEN.
K2
ING. ISAIAS: Calcularemos sumando el MONTO S/ - FLETE S/ - DESCUENTO S/.
Page 7: FUNCIONES_BASICAS_BUSQUEDA

LISTA DE EQUIPOS VENDIDOS

EQUIPO MONTO S/. FLETE S/ IMPUESTO S/

IMPRESORA 25 S/. 10,000.00 S/. 700.00 S/. 1,100.00 IMPRESORA 30 S/. 12,000.00 S/. 840.00 S/. 1,320.00 LAPTOP 42 S/. 105,000.00 S/. 6,300.00 S/. 13,650.00 LAPTOP 44 S/. 110,000.00 S/. 6,600.00 S/. 14,300.00 LAPTOP 43 S/. 107,500.00 S/. 6,450.00 S/. 13,975.00 PROYECTOR 48 S/. 144,000.00 S/. 14,400.00 S/. 23,040.00 PC 45 S/. 67,500.00 S/. 5,400.00 S/. 8,775.00 LAPTOP 29 S/. 72,500.00 S/. 4,350.00 S/. 9,425.00 PC 42 S/. 63,000.00 S/. 5,040.00 S/. 8,190.00 PC 21 S/. 31,500.00 S/. 2,520.00 S/. 4,095.00 IMPRESORA 36 S/. 14,400.00 S/. 1,008.00 S/. 1,584.00 PROYECTOR 21 S/. 63,000.00 S/. 6,300.00 S/. 10,080.00 PROYECTOR 28 S/. 84,000.00 S/. 8,400.00 S/. 13,440.00 LAPTOP 26 S/. 65,000.00 S/. 3,900.00 S/. 8,450.00

CANTIDAD VENDIDA

C2
ING. ISAIAS: Calculamos el MONTO S/ usando la FUNCIÓN BUSCARV(), tomando como referencia la columna EQUIPO
D2
ING. ISAIAS: Calculamos el FLETE S/ usando la FUNCIÓN BUSCARV(), tomando como referencia la columna EQUIPO.
E2
ING. ISAIAS: Calculamos el IMPUESTO S/ usando la FUNCIÓN BUSCARV(), tomando como referencia la columna EQUIPO.
Page 8: FUNCIONES_BASICAS_BUSQUEDA

LISTA DE EQUIPOS VENDIDOS

DESCUENTO S/ TOTAL S/ EQUIPO FLETE % IMPUESTO %

S/. 600.00 S/. 11,200.00 LAPTOP S/. 2,500.00 6% 13%

S/. 720.00 S/. 13,440.00 PC S/. 1,500.00 8% 13%

S/. 5,250.00 S/. 119,700.00 PROYECTOR S/. 3,000.00 10% 16%

S/. 5,500.00 S/. 125,400.00 IMPRESORA S/. 400.00 7% 11%

S/. 5,375.00 S/. 122,550.00 S/. 5,760.00 S/. 175,680.00 S/. 4,725.00 S/. 76,950.00 S/. 3,625.00 S/. 82,650.00 S/. 4,410.00 S/. 71,820.00 S/. 2,205.00 S/. 35,910.00 S/. 864.00 S/. 16,128.00 S/. 2,520.00 S/. 76,860.00 S/. 3,360.00 S/. 102,480.00 S/. 3,250.00 S/. 74,100.00

PRECIO X UNIDAD

F2
ING. ISAIAS: Calculamos el DESCUENTO S/ usando la FUNCIÓN BUSCARV(), tomando como referencia la columna EQUIPO.
G2
ING. ISAIAS: Calculamos el TOTAL S/ restando el MONTO S/-FLETE S/-IMPUESTO S/-DESCUENTO S/
Page 9: FUNCIONES_BASICAS_BUSQUEDA

DESCUENTO %

5%

7%

4%

6%

Page 10: FUNCIONES_BASICAS_BUSQUEDA

REPORTE DEL RECORRIDO DE LA MOVILIDAD

MOVILIDAD IMPUESTO S/

AUTO 153 16.83 S/. 133.11 S/. 3.99 MINIVAN 131 35.37 S/. 148.03 S/. 7.40 VAN 219 83.22 S/. 339.45 S/. 23.76 AUTO 221 24.31 S/. 192.27 S/. 5.77 AUTO 189 20.79 S/. 164.43 S/. 4.93 MINIVAN 162 43.74 S/. 183.06 S/. 9.15 VAN 217 82.46 S/. 336.35 S/. 23.54 MINIVAN 127 34.29 S/. 143.51 S/. 7.18 VAN 150 57 S/. 232.50 S/. 16.28 AUTO 143 15.73 S/. 124.41 S/. 3.73 MINIVAN 203 54.81 S/. 229.39 S/. 11.47 MINIVAN 140 37.8 S/. 158.20 S/. 7.91 MINIVAN 196 52.92 S/. 221.48 S/. 11.07 AUTO 226 24.86 S/. 196.62 S/. 5.90

KM RECORRIDOS

GALONES DE COMBUSTIBLE

MONTO S/ DE COMBUSTIBLE

Page 11: FUNCIONES_BASICAS_BUSQUEDA

VAN MINIVAN AUTO

COMBUSTIBLE X KM 0.38 0.27 0.11PRECIO S/ X KM S/. 1.55 S/. 1.13 S/. 0.87

IMPUESTO 7% 5% 3%

Page 12: FUNCIONES_BASICAS_BUSQUEDA

RELACION DE DOCENTESISAIAS MEDINA CARLOS BERROCAL RAUL PADILLA

CURSO INFORMÁTICA CONTABILIDAD LIDERAZGOHORAS 3 4 2AULA D104 D 204 D304

Page 13: FUNCIONES_BASICAS_BUSQUEDA

RELACION DE DOCENTESMELANI SANCHEZADMINISTRACION

4D404

Page 14: FUNCIONES_BASICAS_BUSQUEDA

REGISTRO DE NOTASDOCENTE: ISAIAS MEDINA HORAS: 3CURSO: INFORMÁTICA AULA: D104

ESTUDIANTE N1 N2 N3 N4 PROMEDIOALDO JOSE PEÑA RUIZ 12 15 14 15 14ANGEL ELIAS CALCINA CARTA 17 15 14 15 15.25ARIAS IDAZ 13 15 14 15 14.25DANIEL MONTENEGRO CHORE 17 15 13 15 15EDITH CAROLA ALAGON QUISPE 16 15 14 15 15ELIBERTA APAZA QUISPE 12 15 16 15 14.5FIORELA ADELA CHORRES ALVAREZ 16 15 13 15 14.75HENRRY GONZALO CHATA ARRAYA 15 15 14 15 14.75JHENY MARGOTH MELENDEZ CASTILLEJOS 17 15 14 15 15.25JOEL MEZA TERRAZAS 12 15 14 15 14JORGE LUIS POMA ALANYA 17 15 18 15 16.25LIZ BEDITH ARIAS TORRES 12 15 14 15 14LUCILA CRISPIN CONDORI 17 15 19 16 16.75LUCILA CRISPINCONDORI 12 15 14 15 14LUZ MERY QUISPE ACHAHUANCO 17 15 14 15 15.25MADELEINE AURORA 14 15 14 15 14.5MARIA DEL PILAR ROMANI SOTO 12 15 18 15 15MICHAEL ALEXANDER USCAMAITA PINCHI 14 14 14 15 14.25OMAR PUMA ZAVALETA 12 15 12 15 13.5PARIONA INFANZON MIRIAM CASI 12 15 14 15 14PATRICIA GATICA RODRIGUEZ 19 16 18 18 17.75PATRICK JESUS ROMERO MONROY 12 15 14 15 14SANDRA KATHERINE 16 15 19 15 16.25YANETH MENDOZA CHAMBILLA 16 15 14 15 15YOVANA PELAYO JIMENEZ 14 15 17 15 15.25