Post on 28-Feb-2018
7/25/2019 1. Repaso Basico.xlsx
1/11
MANEJO DE VENTANAS E INMOVILIZAR TITULOS EN FILAS
Vehiculo Comisin
Automvil S/. 30.00
Camin S/. 70.00
Camioneta S/. 35.00Omnibus S/. 50.00
VENTA DE VEHICULOS
Aenci! Vehiculo M!"c! Tu"no Lu!" Ven#e#o" C!n$i#!#
El Triunfo Camin Volvo Maana ima !obles "
El Triunfo Camioneta Volvo Tar#e ima !obles $
El Triunfo Omnibus Volvo Maana %rovin&ias !obles 3
El Triunfo Automvil Volvo Maana ima Alva 3
El Triunfo Automvil Volvo Maana %rovin&ias Alva 5
El Triunfo Automvil Volvo Tar#e ima Alva 5El Triunfo Camioneta Volvo Maana ima Alva 3
El Triunfo Camin Volvo Maana %rovin&ias Cueva "
a Estrella Camin Volvo Tar#e %rovin&ias !obles '
a Estrella Camin Volvo Tar#e ima !obles 7
a Estrella Camin Volvo Maana ima !obles 5
a Estrella Camin Volvo Maana ima !obles $
a Estrella Camioneta Volvo Tar#e %rovin&ias !obles 3
a Estrella Omnibus Volvo Maana %rovin&ias !obles 7
a Estrella Omnibus Volvo Tar#e ima !obles (
a Estrella Automvil Volvo Tar#e ima Alva (
a Estrella Camioneta Volvo Tar#e %rovin&ias Alva 7
El Triunfo Omnibus )*un#ai Maana %rovin&ias Alva 5El Triunfo Camin )*un#ai Maana ima Alva 3
El Triunfo Omnibus )*un#ai Maana ima Alva 3
El Triunfo Automvil )*un#ai Tar#e ima +ara '
El Triunfo Automvil )*un#ai Maana %rovin&ias +ara 5
El Triunfo Automvil )*un#ai Tar#e ima +ara 5
El Triunfo Camioneta )*un#ai Maana ima +ara '
El Triunfo Camioneta )*un#ai Tar#e ima +ara 3
El Triunfo Omnibus )*un#ai Tar#e %rovin&ias Cueva ,
a Estrella Camin )*un#ai Tar#e %rovin&ias Alva 5
a Estrella Camin )*un#ai Maana %rovin&ias Alva "
a Estrella Camin )*un#ai Maana ima Alva ,
a Estrella Omnibus )*un#ai Tar#e ima Alva -a Estrella Automvil )*un#ai Tar#e %rovin&ias +ara 7
a Estrella Camioneta )*un#ai Tar#e ima +ara 3
El Triunfo Omnibus or# Tar#e ima !obles 5
El Triunfo Omnibus or# Maana ima !obles '
El Triunfo Omnibus or# Tar#e %rovin&ias !obles "
El Triunfo Omnibus or# Tar#e ima +ara 5
El Triunfo Camin or# Maana %rovin&ias +ara -
El Triunfo Camin or# Maana ima +ara 3
El Triunfo Camioneta or# Tar#e ima Cueva (
El Triunfo Automvil or# Tar#e ima Cueva -
El Triunfo Camioneta or# Maana ima Cueva 'El Triunfo Automvil or# Maana %rovin&ias Cueva $
7/25/2019 1. Repaso Basico.xlsx
2/11
El Triunfo Automvil or# Tar#e ima Cueva "
El Triunfo Camioneta or# Tar#e %rovin&ias Cueva '
El Triunfo Camioneta or# Tar#e %rovin&ias Cueva ,
a Estrella Automvil or# Tar#e ima !obles (
a Estrella Camin or# Tar#e ima !obles 7
a Estrella Camin or# Tar#e %rovin&ias !obles (
a Estrella Automvil or# Tar#e ima Cueva (
a Estrella Omnibus or# Maana ima Cueva 3
7/25/2019 1. Repaso Basico.xlsx
3/11
Y COLUMNAS
Vehiculo Fo"# Vol%o H&un#!i
Au$om%il S/. ,$000 S/. 3$000 S/. -000
C!min S/. $3000 S/. 5,000 S/. 35000
C!mione$! S/. "0000 S/. "3000 S/. ,'000Omni'us S/. $"000 S/. $5000 S/. 3-000
H&un#!i 3
Comisin Mon$o(
S/. ,$0 S/. 5,000
S/. ,$0 S/. "3000
S/. ,50 S/. $5000
S/. -0 S/. 3$000
S/. ,50 S/. 3$000
S/. ,50 S/. 3$000S/. ,05 S/. "3000
S/. ,$0 S/. 5,000
S/. 5(0 S/. 5,000
S/. $-0 S/. 5,000
S/. 350 S/. 5,000
S/. "'0 S/. 5,000
S/. ,05 S/. "3000
S/. 350 S/. $5000
S/. 300 S/. $5000
S/. ,'0 S/. 3$000
S/. "$5 S/. "3000
S/. "50 S/. 3-000S/. ",0 S/. 35000
S/. ,50 S/. 3-000
S/. "$0 S/. -000
S/. ,50 S/. -000
S/. ,50 S/. -000
S/. "'0 S/. ,'000
S/. ,05 S/. ,'000
S/. 50 S/. 3-000
S/. 350 S/. 35000
S/. ,$0 S/. 35000
S/. 70 S/. 35000
S/. $50 S/. 3-000S/. ",0 S/. -000
S/. ,05 S/. ,'000
S/. "50 S/. $"000
S/. $00 S/. $"000
S/. ,00 S/. $"000
S/. "50 S/. $"000
S/. (30 S/. $3000
S/. ",0 S/. $3000
S/. ",0 S/. "0000
S/. "70 S/. ,$000
S/. "'0 S/. "0000S/. ,"0 S/. ,$000
7/25/2019 1. Repaso Basico.xlsx
4/11
S/. (0 S/. ,$000
S/. "'0 S/. "0000
S/. 35 S/. "0000
S/. ,'0 S/. ,$000
S/. $-0 S/. $3000
S/. $"0 S/. $3000
S/. ,'0 S/. ,$000
S/. ,50 S/. $"000
7/25/2019 1. Repaso Basico.xlsx
5/11
LICORES !on Cartavio Cervea Cristal 1is2* Ol# %ar !on a&ar#i
ENE S/. 500.00 S/. ,"5'.00 S/. '(3.00 S/. 5(.00
FE) S/. '00.00 S/. $57.00 S/. ,5'.00 S/. $7(.00
MAR S/. ,000.00 S/. 3"$.00 S/. ,$7.00 S/. ,"5'.00
TOTAL en S*+ S/. "300.00 S/. "03-.00 S/. ,,('.00 S/. ,7-0.00
To$!l en , 4730.,( 4($7.30 4370.7- 45('."5
SU-ERMERCADOS R.R SRL
TIPO CAMBIO 3.15
alt6S8ift606 es e9uivalente a A:
7/25/2019 1. Repaso Basico.xlsx
6/11
Cervea %ilsen SU)TOTAL S*+ SU)TOTAL ,
S/. $7'.00 S/. 3,55.00 4,00,.5-
S/. 3",.00 S/. "",".00 470".""
S/. $7'.00 S/. 3"07.00 4,0,'.,0
S/. ,"77.00 S/. '57$.00
4$05.$0 4"7",.-0
S/. ,7,$'.00 45$$3.',
TOS:MA
7/25/2019 1. Repaso Basico.xlsx
7/11
DISTRI)UIR -ORCENTAJES/
ENCUESTA SO)RE -REFERENCIAS
)E)IDA TOTAL 0
1ASEOSA RES-UESTAS -REFERENCIAS
COCA COA "3 ,3;
%E%S< COA 3$ ,-;
A COA ", ,";
>OA !EA $5 "(;
CA=A?A ?!@ 3$ ,-;
SEVE= :% ,' ,0;TOTAL (23 (440
!ealiar rafi&o &omo mostra#o en la fiura
7/25/2019 1. Repaso Basico.xlsx
8/11
COCA COLA; 13%
PEPSI COLA; 19%
INKA COLA; 12%
KOLA REAL; 26%
CANADA DRY; 19%
SEVEN UP; 10%
RESPUESTAS
7/25/2019 1. Repaso Basico.xlsx
9/11
TRANSPORTE AEREO DE PASAJEROS
O"#en Ae"oL5ne! O"ien Des$ino -!s!6e"os In"esos7,8 Du"!cin
00, TACA rasil %erB ,50 ,0500 730
00" an %erB %erB Veneuela "00 ,"000 500
003 an %erB rasil C8ile ,75 ,,500 '$500$ Tans C8ile E&ua#or ,"0 ,0300 -30
005 TACA Veneuela rasil ,35 -500 700
00( Tans E&ua#or %erB "30 ,$000 (30
007 an %erB Veneuela rasil ,75 ,3500 '"0
00' Tans E&ua#or C8ile ,50 ,"500 5$5
00- TACA %erB Veneuela ,$5 ,,700 -$0
0,0 TACA rasil E&ua#or ""0 ,5000 '"0
0,, an %erB C8ile Veneuela ,'0 ,$550 (50
0," TACA Veneuela %erB ,"0 ,5550 -35
0,3 Tans E&ua#or %erB ,50 ,'000 -50
0,$ TACA Veneuela rasil ,70 ,(000 '"0
0,5 Tans E&ua#or C8ile ,50 7000 7000,( an %erB C8ile Veneuela "00 7500 '00
0,7 Tans Veneuela E&ua#or ,'0 -'00 -00
0,' TACA E&ua#or rasil ,05 ,0000 -"0
0,- an %erB Veneuela E&ua#or ,"5 ,"500 '$0
0"0 TACA E&ua#or C8ile ,30 ","00 735
0", Tans %erB Veneuela ,$0 "3000 755
0"" TACA rasil E&ua#or ,"0 ""500 '55
0"3 Tans C8ile Veneuela ,50 ,'500 -35
0"$ an %erB Veneuela E&ua#or ,'0 ,$000 (30
0"5 Tans E&ua#or %erB "00 ,3$50 ($5
0"( TACA Veneuela rasil ""0 ,7750 735
0"7 Tans E&ua#or C8ile ,50 ,'550 (550"' an %erB C8ile Veneuela ,70 ""$50 755
0"- Tans Veneuela E&ua#or ,"0 "5000 '50
030 TACA E&ua#or Veneuela "00 "0500 -30
03, TACA Veneuela E&ua#or ,50 '050 -$0
03" an %erB Veneuela C8ile ,'0 ,"550 '$5
033 an %erB E&ua#or rasil ,70 ,5700 '55
03$ an %erB Veneuela E&ua#or "50 ,7550 -$5
ranoD #on#e bus&ar el &riterio
7/25/2019 1. Repaso Basico.xlsx
10/11
, Conteo #e viaFes Gor 3 Conteo #e viaFes Gor
O"ien
Ae"oL5ne! Conteo Ae"oL5ne! rasil
TACA ," TACA 3
an %erB ,, an %erB ,
Tans ,, Tans 0
-!s!6e"os
O"ien Conteo O"ien H,30
rasil $ rasil ,
%erB 3 %erB 0
C8ile 5 C8ile ,
Veneuela ," Veneuela 3
E&ua#or ,0 E&ua#or ,
-!s!6e"os
-!s!6e"os Conteo Ae"oL5ne! H,30
H,30 ( TACA 3H,50 ,0 an %erB ,
H"00 "( Tans "
I,30 "7
I,50 ,7
I""0 "
" Total
7/25/2019 1. Repaso Basico.xlsx
11/11
%erB C8ile Veneuela E&ua#or
, 0 5 3
, 3 5 ,
, " " (
H,50 H"00 I,30 I,50 I""0
, 3 3 " 0
" " 3 , 0
, $ $ 3 0
$ ,0 - 7 ,
" 7 ' $ ,
H,50 H"00 I,30 I,50 I""0
( - ' $ 0, ' ,0 ,0 ,
3 - - 3 ,
%erB C8ile Veneuela E&ua#or
,,700 0 (('50 5,700,"000 $$500 70,00 ,5700
"3000 "''00 3$'00 '3500
H,50 H"00 I,30 I,50 I""0
""500 $$500 37000 "(500 0
3$700 3$700 $(700 ,"000 0
,0300 (5'00 (3000 $$500 0
("550 ,3($50 ,,'700 ,0,,50 ,7550
3,"00 ,0"-50 ,,-700 (3(50 ,$000
H,50 H"00 I,30 I,50 I""0
0 0 0 0 0
-0$50 ,"5000 ,0-000 (-"50 0
,"500 ,,(750 ,$,300 ,$,300 ,7550