1. Repaso Basico.xlsx

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 $


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


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


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


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:


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/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


8/11

COCA COLA; 13%

PEPSI COLA; 19%

INKA COLA; 12%

KOLA REAL; 26%

CANADA DRY; 19%

SEVEN UP; 10%

RESPUESTAS


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


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


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

Documents

1. Repaso Basico.xlsx