Examen I - Excel Intermedio
Examen I - Excel Intermedio
Examen I - Excel Intermedio
21 DE JUNIO 2016
CORREO: percy.ceups@gmail.com
59 HORAS
1) La bonificación será del 20% del sueldo para aquellos que ganen menos de 2000 soles
y cuyo tiempo de servicio sea mayor a 3 años; de lo contrario, no recibirán ningún monto.
2) El total será igual a la suma del sueldo y la bonificación
Tiempo
Empleado Sueldo de Servicio Bonificación Total
Carlos Pacheco S/.2,500 3 S/. 0 S/. 2,500 20
Juan Osores S/.1,800 4 S/. 360 S/. 2,160 30
Andrea Porras S/.3,000 1 S/. 0 S/. 3,000 15
Sol Miranda S/.700 5 S/. 140 S/. 840 54
Mónica Santa Cruz S/.1,200 8 S/. 240 S/. 1,440 65
Sara Mariátegui S/.3,500 2 S/. 0 S/. 3,500 45
Gloria Velásquez S/.1,500 9 S/. 300 S/. 1,800 -50
Francisco Montoya S/.2,000 4 S/. 0 S/. 2,000 20000
20179
En las columnas en blanco colocar las formulas que permitan llenar la tabla
Cuadro de Ventas
Cod Descrip Año Color Origen Cant Precio Total
X001 Auto 1995 Rojo Alemania 120 S/. 18,000.00 S/. 2,160,000.00
X002 Auto 1990 Azul Chile 60 S/. 18,000.00 S/. 1,080,000.00
X003 Motocicleta 1980 Verde Japón 80 S/. 3,500.00 S/. 280,000.00
X004 Auto 1995 Rojo Alemania 40 S/. 18,000.00 S/. 720,000.00
X005 Deportivo 1998 Azul Japón 100 S/. 35,000.00 S/. 3,500,000.00
X006 Camioneta 1990 Azul Alemania 150 S/. 38,000.00 S/. 5,700,000.00
X007 Motocicleta 2000 Verde Japón 140 S/. 3,500.00 S/. 490,000.00
X008 Motocicleta 1999 Rojo Chile 160 S/. 3,500.00 S/. 560,000.00
X009 Deportivo 2001 Azul Japón 90 S/. 35,000.00 S/. 3,150,000.00
X010 Auto 2002 Rojo Alemania 85 S/. 18,000.00 S/. 1,530,000.00
X011 Camioneta 1999 Azul Japón 100 S/. 38,000.00 S/. 3,800,000.00
X012 Motocicleta 2001 Verde Alemania 95 S/. 3,500.00 S/. 332,500.00
X013 Deportivo 2002 Rojo Japón 85 S/. 35,000.00 S/. 2,975,000.00
X014 Camioneta 1995 Azul Chile 120 S/. 38,000.00 S/. 4,560,000.00
X015 Auto 1997 Azul Japón 150 S/. 18,000.00 S/. 2,700,000.00
X016 Auto 1998 Verde Alemania 125 S/. 18,000.00 S/. 2,250,000.00
X017 Deportivo 1997 Rojo Japón 130 S/. 35,000.00 S/. 4,550,000.00
X018 Auto 2000 Azul Alemania 120 S/. 18,000.00 S/. 2,160,000.00
ntas
Flete Desc Venta Productos
S/. 216,000.00 S/. 324,000.00 S/. 2,052,000.00 Descrip Precio Flete
S/. 108,000.00 S/. 108,000.00 S/. 1,080,000.00 Auto 18000 10%
S/. 42,000.00 S/. 33,600.00 S/. 288,400.00 Camioneta 38000 20%
S/. 72,000.00 S/. 108,000.00 S/. 684,000.00 Deportivo 35000 5%
S/. 175,000.00 S/. 420,000.00 S/. 3,255,000.00 Motocicleta 3500 15%
S/. 1,140,000.00 S/. 855,000.00 S/. 5,985,000.00
S/. 73,500.00 S/. 58,800.00 S/. 504,700.00
S/. 84,000.00 S/. 56,000.00 S/. 588,000.00 Paises
S/. 157,500.00 S/. 378,000.00 S/. 2,929,500.00 Origen Desct
S/. 153,000.00 S/. 229,500.00 S/. 1,453,500.00 Alemania 15%
S/. 760,000.00 S/. 456,000.00 S/. 4,104,000.00 Japón 12%
S/. 49,875.00 S/. 49,875.00 S/. 332,500.00 Chile 10%
S/. 148,750.00 S/. 357,000.00 S/. 2,766,750.00
S/. 912,000.00 S/. 456,000.00 S/. 5,016,000.00
S/. 270,000.00 S/. 324,000.00 S/. 2,646,000.00
S/. 225,000.00 S/. 337,500.00 S/. 2,137,500.00
S/. 227,500.00 S/. 546,000.00 S/. 4,231,500.00
S/. 216,000.00 S/. 324,000.00 S/. 2,052,000.00
Categoria - all -
TABLA I TABLA II
Cod. Nombre Puntaje
Facul Facultad Requerido Categoria Total a Pagar
AD Administración 650 F 3600
CT Contabilidad 620 G 3200
EC Economia 700 D 2400
ST Sistemas 850 C 1900
TH Turismo y Hotelería 570 E 1700
DC Derecho 700 A 1500
MK Marketing 645 B 1000