trabajo encargado de ofimatica 2

8/19/2019 Trabajo Encargado de Ofimatica 2

1/46

UNIVERSIDAD ALAS PERUANASFacultad de Ciencias contables y Administrativas

FACULTAD DE CIENCIAS EMPRESARIALES

ESCUELA PROFESIONAL: CIENCIAS CONTABLES FINANCIERAS

TEMA:

“FUNCIONES DE BASE DE DATOS, FUNCIONESFINANCIERAS, FUNCIONES DE BÚSQUEDA Y

REFERENCIA”

CICLO ACADEMICO: SEGUNDO

ASIGNATURA: OFIMATICA II

DOCENTE: FREDY RENE MAQUERA SANGINES

ESTUDIANTE: GUISELA YUDIT TESILLO MAMANI

TACNA-2016

Om!tica IIP!"ina #


2/46


INDICE

INTRODUCCION………………………………………………………………….

OBJETIVO…………………………………………………………………………

I. FUNCIONES DE BASES DE DATOS..

1.1. FUNCION BDPROMEDIO……………………………………………….1.2. FUNCION BDCUENTA…………………………………………………..1.3. FUNCION BDCONTARA…………………………………………………1.4. FUNCION BDEXTRAER…………………………………………………1.5. FUNCION BDMAX………………………………………………………..1.. FUNCION BDMIN…………………………………………………………1.!. FUNCION BDPRODUCTO………………………………………………

1.". FUNCION BDSUMA………………………………………………………II. FUNCIONES FINANCIERAS.

2.1. FUNCION INT.EFECTIVO……………………………………………2.2. FUNCION VF…………………………………………………………..2.3. FUNCION PAGOINT…………………………………………………..2.4. FUNCION TASA.NIMINAL……………………………………………2.5. FUNCION NPER……………………………………………………….2.. FUNCION VNA…………………………………………………………2.!. FUNCION PAGO………………………………………………………

2.". FUNCION PAGOPRIN………………………………………………..2.#. FUNCION VA…………………………………………………………..2.1$. FUNCION TASA……………………………………………………….

III. FUNCIONES DE BÚSQUEDA Y REFERENCIA

3.1. FUNCION ELEGIR…………………………………………………………3.2. FUNCION BUSCAR%……………………………………………………..3.3. FUNCION BUSCAR……………………………………………………….3.4. FUNCION COINCIDIR……………………………………………………..3.5. FUNCION BUSCARV………………………………………………………

I!. CONCLUCION!. BIBLIOGRAFIA..

INTRODUCCION

E& '()' )*+,+- /*'('&) 0+( &&'( ' E6'0 7' (' )08+& '& &'()* +9/

0+,*+0

Om!tica IIP!"ina $


3/46


L+( ,+(' ' +)( ;BD< (& &+ ='**+9'&)+ &(/'&(+,0' '& 0+ +)+0('+ ' 0+ &*9+>&? ( )0+ & (>0 (' ',' + 7' '( & &-&) '+)( +09+'&+( ' +0@&+ *9+ ')'*9&++? '& &+ BD )+9,& '6()'& &++&)+ ' '0'9'&)( 7' ++& + *@+&8+* (()'9)+9'&)'? *'0+&+*?

/*)'@'*? +9&()*+* ' 9+&'*+ ''&)' 0( +)(.

E& '()+ U&+ +/*'&'* +'*+ '0 ( ' 0+( &&'( ' +)( ' E6'0?+/0+>& ' *9+)( &&+0'( ++&8+( /*)'>& ' '0'9'&)( ' 0+=-+ ' 00.

L+ &>& &+&'*+ )'&' 9 ,-') /*&/+0 00'+* + 0+ 9+* 9+698+>&/(,0' '0 +0* 7' 0+ '9/*'(+ /'' 00'@+* + )'&'*? +9'&)+* ) 0 7'*'/*'('&)+ )'&' & +0* '& 0+ *@+&8+>&.

TRABA"O ENCARGADO DE OFIMATICA II

Om!tica IIP!"ina %


4/46


I. FUNCIONES DE BASE DE DATOS

1.1. FUNCION BDPROMEDIO

1.1.1. DESCRIPCIOND''0' & +0* &9*. D++ &+ ,+(' ' +)(? ''0' '0

/*9' '0 +9/ 7' (' 0' &7' + 0+ &>&. L+ &>& /*9'*

('0'&+ 0( *'@()*( 7' 9/0'& & 0+ &>&? /()'**9'&)'

+00+ '0 /*9' ' 0( +0*'( /'*)'&''&)'( +0 +9/ &+.

1.1.2. SINTA#IS

BDPROMEDIO $,+(''+)( &9,*''+9/ *)'*(%

B&'()*()*&+'.- '( '0 *+&@ ' '0+( 7' 9/&' 0+ 0()+

,+(' ' +)(. U&+ ,+(' ' +)( '( &+ 0()+ ' +)(

*'0+&+( '& 0+ 7' 0+( 0+( ' &*9+>& (& *'@()*( 0+(

09&+( ' +)(? +9/(. L+ /*9'*+ 0+ ' 0+ 0()+ &)'&'

0( *>)0( ' ++ 09&+.

N/()*()&.- &+ 7 09&+ (' (+ '& 0+ &>&.

E(*,+ '0 *>)0 ' 0+ 09&+ '&)*' 900+(? 9 /* '-'9/0

E+ R'&9'&)? & &9'* ;(& 0+( 900+(< 7'

*'/*'('&)' 0+ /(>& ' 0+ 09&+ '& 0+ 0()+: 1 /+*+ 0+

/*9'*+ 09&+? 2 /+*+ 0+ ('@&+ +(H ('(+9'&)'.

C/+(/'.- '( '0 *+&@ ' '0+( 7' &)'&' 0+( &&'(

'(/'++(. P'' (+* +07'* *+&@ '& '0 +*@9'&)

C*)'*( 9'&)*+( '()' &0+ /* 0 9'&( & *>)0 '

09&+ +0 9'&( &+ '0+ ',+- '0 *>)0 ' 09&+ '&

0+ 7' (' /'+ '(/'+* &+ &>& ' 09&+.

1.1.3. E"EMPLO

4BDPROMEDIO $D&+'.A1:F57A3:F8%.- D''0' "!5?$$$.$

P*9' '0 (+0+* ' 0( '9/0'+( 7' )'&'& $ 3 =-(.

Om!tica IIP!"ina &


5/46


4BDPROMEDIO $D&+'.A1:F57A1:F2%.- D''0' "#?25$.$

P*9' '0 (+0+* ' 0( '9/0'+( 7' (& 9-'*'(.

4BDPROMEDIO $D&+'.A1:F59I"OS9A6:A;%.- D''0' 1.!

P*9' ' =-( ' 0( '9/0'+( & >@ 1$$5? 1$$" 1$$#.

1.1.7. APLICACI


6/46


Y '0 *'(0)+ ('@& 0( +0*'( ' 0+ ,+(' ' +)( '(:

1.2. FUNCION BDCUENTA

1.2.1. DESCRIPCION

C'&)+ 0+( '0+( 7' &)'&'& & &9'* '& &+ ')'*9&++09&+ ;+9/


7/46


Q'*'9( (+,'* &)( *'@()*( )'&'& +0@& &9'* '& '0 +9/

+K(? 7' 9/0+& & 0+( (@'&)'( &&'( A)9>0 F* P0+8+( 5 ;R'* 7' ++ '-'9/0 0 )'&(

7' =+'* '& ) /*/+ B+(' ' D+)(? 9/*,+* 7' )' ' '09(9 *'(0)+<R'(0>&: E(*,*

4BDCUENTA;A5:E14AK(A1:E2<C9 *'(0)+ ,)'&'9( 2

1.2.7. APLICACI


8/46


L+ &>& BDCONTAR '& E6'0 '&)+ 0( *'@()*( '&)* ' &+

09&+ &9*+ 7' /'*9+&''& '(/( ' +/0+* & @*/ '

*)'*( (,*' 0( +)(. L+ &>& (' /'' )08+* (,*' +07'*

*+&@ ' '0+( ('9/*' +& (' &0+ & &9,*' /+*+ ++09&+.

1.3.2. SINTA#IS

BDCONTARA $,+(''+)(? &9,*''+9/? *)'*(%

&'()*()*&+' ;,0@+)*&. C/+(/' ;,0@+)*


9/46


L+ &>& + 9/0* '() &++ '& '0 *+&@ A1:A2 '0 +0 )'&' &

)H)0 ' 09&+ &) +0 )H)0 ' 0+ )+,0+ &' '()& 0( +)(. L+

&>& 7' =' 0+ '& 0+ '0+ G2 '( 0+ (@'&)':

4BDCONTAR;A4:D#? IDP*)? A1:A2<

1.7. FUNCION BDE#TRAER

1.7.1. DESCRIPCION

L+ &>& BDEXTRAER E6)*+' & & +0* ' &+ 09&+ '

&+ 0()+ ,+(' ' +)( 7' &+ & 0+( &&'(

'(/'++(.

1.7.2. SINTA#IS

BDE#TRAER $,+(''+)(? &9,*''+9/? *)'*(%

B&'()*()*&+' O,0@+)*. E0 *+&@ ' '0+( 7' 9/&' 0+

0()+ ,+(' ' +)(. U&+ ,+(' ' +)( '( &+ 0()+ ' +)(

*'0+&+( '& 0+ 7' 0+( 0+( ' &*9+>& (& *'@()*( 0+(

09&+( ' +)(? +9/(. L+ /*9'*+ 0+ ' 0+ 0()+ &)'&' 0(

*>)0( ' ++ 09&+. N/()*()&. I&+ 7 09&+ (' (+ '& 0+ &>&.

E(*,+ '0 *>)0 ' 0+ 09&+ '&)*' 900+(? 9 /* '-'9/0

E+ R'&9'&)? & &9'* ;(& 0+( 900+(< 7'

*'/*'('&)' 0+ /(>& ' 0+ 09&+ '& 0+ 0()+: 1 /+*+ 0+ /*9'*+

09&+? 2 /+*+ 0+ ('@&+ +(H ('(+9'&)'. C/+(/. E( '0 *+&@ ' '0+( 7' &)'&' 0+( &&'(

'(/'++(. P'' (+* +07'* *+&@ '& '0 +*@9'&)

*)'*( 9'&)*+( '()' &0+ +0 9'&( & *>)0 ' 09&+

&+ '0+ ',+- '0 9(9 '& 0+ 7' (' /'+ '(/'+* &+

&>& /+*+ 0+ 09&+.

1.7.3. E"EMPLO

BDE#TRAER;A4:E2$? N9,*'? A1:A2< D''0' '0 +0* ' 0+

'0+ ' 0+ 09&+ N9,*' 7' 9/0' & 0+ &>&

'(/'H++ '& A1:A2

Om!tica IIP!"ina +


10/46


1.7.7. APLICACI0 )'&' &+ *'&)+,0+ #

R'(0>&: P*9'* )'&'9( 7' '(*,* '& 0+ 8&+ ' *)'*(?',+- ' R'&)+,0+? '0 +0* # ;+(00+ D2<

L'@ '(*,9( 0+ &>&BDEXTRAER;A5:E14A)90D1:D2<C9 *'(0)+ ,)'&'9( F* ? '0 +0* '0 +9/ A)90

'& 0+ 0+ 7' 9/0+ 0+ &>& &0+ '& '0 *+&@ D1:D2N)+: '()' '-'9/0 &&+ /*7' =+ & (>0 *'@()* 7' 9/0'

0+ &>&? =+ & (0 +)90 & *'&)+,0+ #

1.8. FUNCION BDMA#

1.8.1. DESCRIPCION

L+ &>& BDMAX (' )08+ /+*+ ,)'&'* '0 +0* 969 '&+ 0()+ '&+ '& &+ ,+(' ' +)(? ('9/*' +& 0+('0+( 9/0'& &+ +*+( &&'(.

1.8.2. SINTA#IS

BDMA# $,+(''+)(? &9,*''+9/? *)'*(% &'()*()*&+': R+&@ ' '0+( 7' 9/&' 0+ ,+('

' +)(. L+ /*9'*+ 0+ '0 *+&@ &)'&' 0( )H)0( '

++ 09&+ =/()*()&: L+ 09&+ ' 0+ +0 (' ,)'&*

'0 +0* 969. /+(/': R+&@ ' '0+( 7' &)'&' 0( *)'*( +

9/0*.

1.8.3. E"EMPLO

E-'9/0: S' 7'*' (+,'* +0 '( '0 9+* ,'&' '&)*' 0(

+)9>0'( F* P'@')R'(0>&: E(*,*

BDMA#;A5:E14B'&'A1:A3<C9 *'(0)+ ,)'&'9( 123

Om!tica IIP!"ina #,


11/46


BDMA#;A4:E2$? E+? A1:E2< D''0' '0 +0*

969 ' 0+ 09&+ E+ 7' 9/0' & 0+(

&&'( '(/'H++( '& A1:E2

1.8.7. APLICACI& ' 0+( &&'( ' B+('( '

+)( '(/'H+9'&)' & 0+ &>& BDMAX? +9( + *'+08+*

'()+ '8 & '-'* &' &0*+*'9( 9( ' &+

+*+,0' /+*+ '&)'&'* '0 /)'&+0 ' '()+ &>&

L+ &>& BDMAX (' )08+ /+*+ ,)'&'* '0 +0* 969 '&+ 0()+ '&+ '& &+ ,+(' ' +)(? ('9/*' +& 0+(

'0+( 9/0'& &+ +*+( &&'(.#l o$%etivo es a"licar en la celda #1& la función '()*+

"ara o$tener el valor m,imo de las ventas reali!adas y

ue en la $ase de datos cum"len con las condiciones

indicadas en el rango de celdas '1/:G10 en este e%em"lo

se trata de o$tener el m,imo de ventas registrados en la

2ona 3orte y ue SI cum"lieron el "resu"uesto:

4 el resultado seg5n los valores de la $ase de datos es:

Om!tica IIP!"ina ##


12/46


1.6. FUNCION BDMIN

1.6.1. DESCRIPCION

O,)'&' '0 +0* 9H&9 ' &+ 09&+ ' 0+ ,+(' ' +)(&('*+& (0 0( *'@()*( 7' 9/0'& & 0( *)'*(

'()+,0'(.

1.6.2. SINTA#IS

BDMIN $,+(''+)(? &9,*''+9/?*)'*(<

B&'()*()*&+': '( '0 *+&@ ' '0+( 7' 9/&' 0+

0()+ ,+(' ' +)(. U&+ ,+(' ' +)( '( &+ 0()+ '

+)( *'0+&+( '& 0+ 7' 0+( 0+( ' &*9+>& (&

*'@()*( 0+( 09&+( ' +)(? +9/(. L+ /*9'*+ 0+

' 0+ 0()+ &)'&' 0( *>)0( ' ++ 09&+. N/()*()&: &+ '0 +9/ 7' (' )08+ '& 0+

&>&. N9,*''+9/ /'' ('* )'6) & '0 *>)0

'&'**+ '&)*' ,0'( 900+(? 9 /* '-'9/0 E+

C+9/? 9 & &9'* 7' *'/*'('&)' 0+ /(>& '

0+ 09&+ '& 0+ 0()+: 1 /+*+ 0+ /*9'*+ 09&+? 2 /+*+ 0+

('@&+ +(H ('(+9'&)'. C/+(/': '( '0 *+&@ ' '0+( 7' &)'&' 0+(

&&'( '(/'++(. P'' )08+* +07'* *+&@ '&

'0 +*@9'&) C*)'*( 9'&)*+( ()' &0+ /* 0 9'&(

& *>)0 ' 09&+ /* 0 9'&( &+ '0+ ',+- '0

*>)0 ' 09&+ 7' '(/'7' &+ &>& '

09&+.1.6.3. E"EMPLO

BDMIN;A4:E2$? E+? A1:E2< D''0' '0 +0* 9H&9

' 0+ 09&+ E+ 7' 9/0' & 0+( &&'(

'(/'H++( '& A1:E21.6.7. APLICACI& + &+ '&)*++ +&)'**? '& 0+ 7' & 0')* /0+&)',+

'()+ '()>&: ...)'&@ '& A1 + A1$ *+&@( & '=+ =*+ ' 0+(

Om!tica IIP!"ina #$


13/46


00+9++( ='=+( '& B1 + B1$ '0 &9,*' '0 +@'&)' 0 7' ', '

=+'* '( ,)'&'* '0 9H&9 '0 969 *'@()* ' ++ +@'&)'. ...

L *'(0'* '()+ '8 '9/0'+& &&'( /+*+ B+(' ' +)(? '&

&*') 0+( &&'(:

BDMIN;,+(' ' +)( +9/ *+&@ ' *)'*(<

BDMAX;,+(' ' +)( +9/ *+&@ ' *)'*(<

A/0+*'9( '()+( >*90+( (,*' &'()* 0()+:

I&)'*/*')+* 0+( &&'( ++(.P+*+ ,)'&'* '0 9H&9 +0*:BDMIN;A1:B11%*+E2:E3<

E( '*? 0+ (9+ ' 0( I9/*)'( ' 0( *'@()*( ;'&)+( ' @+()<

7' 9/0'& 0+ &>& ++? '( '*? 7' 0+ '=+ (' '&'&)*'

'&)*' '0 3$$!2$$# '0 $!$"2$$#? '( ' 43."5$?$$ '*.

1.?. FUNCION BDPRODUCTO

1.?.1. DESCRIPCION

M0)/0+ 0( +0*'( ' &+ 09&+ ' 0+ ,+(' ' +)( 7'

9/0'& & 0( *)'*( '()+,0'(.

1.?.2. SINTA#IS

BDPRODUCTO $,+(''+)(? &9,*''+9/? *)'*(%

Om!tica IIP!"ina #%


14/46


B&'()*()*&+'. E0 *+&@ ' '0+( 7' 9/&' 0+ 0()+ ,+('

' +)(. U&+ ,+(' ' +)( '( &+ 0()+ ' +)( *'0+&+(

'& 0+ 7' 0+( 0+( ' &*9+>& (& *'@()*( 0+( 09&+( '

+)(? +9/(. L+ /*9'*+ 0+ ' 0+ 0()+ &)'&' 0( *>)0( '

++ 09&+. N/()*()&. I&+ 7 09&+ (' (+ '& 0+ &>&.

E(*,+ '0 *>)0 ' 0+ 09&+ '&)*' 900+(? 9 /* '-'9/0

E+ R'&9'&)? & &9'* ;(& 0+( 900+(< 7'

*'/*'('&)' 0+ /(>& ' 0+ 09&+ '& 0+ 0()+: 1 /+*+ 0+ /*9'*+

09&+? 2 /+*+ 0+ ('@&+ +(H ('(+9'&)'.

C/+(/'. E( '0 *+&@ ' '0+( 7' &)'&' 0+( &&'('(/'++(. P'' (+* +07'* *+&@ '& '0 +*@9'&)

*)'*( 9'&)*+( '()' &0+ +0 9'&( & *>)0 ' 09&+

&+ '0+ ',+- '0 9(9 '& 0+ 7' (' /'+ '(/'+* &+

&>& /+*+ 0+ 09&+.

1.?.3. E"EMPLO

BDPRODUCTO;A4:E2$? E+? A1:E2< M0)/0+ 0( +0*'(

' 0+ 09&+ E+ 7' 9/0'& & 0+( &&'(

'()+,0'+( '& A1:E2

1.?.7. APLICACI& BDPRODUCTO /+*+

')'*9&+* '0 /*) ' 0+( &+'( *'@()*++( 7' 9/0'& &

0+( &&'( &++( '& '0 *+&@ ' '0+( B15:G1! '& '()'

'-'9/0 (' )*+)+ ' 0+( '&)+( '& &+'( ' 0+ &+ N*)' 7' SI9/0'& 90)/0+ /* 0+( '&)+( '& &+'( ' 0+ &+ S* 7'

NO 9/0'&

Om!tica IIP!"ina #&


15/46


4 el resultado seg5n los valores de la $ase de datos es:

1.5. FUNCION BDSUMA

1.5.1. DESCRIPCION

S9+ 0( &9'*( ' & +9/ ;09&+< ' *'@()*( ' &+

0()+ ,+(' ' +)( 7' 9/0'& 0+( &&'(

'(/'++(.

1.5.2. SINTA#IS

BDSUMA $,+(''+)(? &9,*''+9/? *)'*(%

B&'()*()*&+': E0 *+&@ ' '0+( 7' 9/&' 0+ 0()+

,+(' ' +)(. U&+ ,+(' ' +)( '( &+ 0()+ ' +)(

*'0+&+( '& 0+ 7' 0+( 0+( ' &*9+>& (& *'@()*( 0+(

09&+( ' +)(? +9/(. L+ /*9'*+ 0+ ' 0+ 0()+ &)'&'

0( *>)0( ' ++ 09&+. N/()*()&: I&+ 7 09&+ (' (+ '& 0+ &>&.

E(*,+ '0 *>)0 ' 0+ 09&+ '&)*' 900+(? 9 /* '-'9/0

E+ R'&9'&)? & &9'* ;(& 0+( 900+(< 7'

Om!tica IIP!"ina #'


16/46


*'/*'('&)' 0+ /(>& ' 0+ 09&+ '& 0+ 0()+: 1 /+*+ 0+ /*9'*+

09&+? 2 /+*+ 0+ ('@&+ +(H ('(+9'&)'. C/+(/': E( '0 *+&@ ' '0+( 7' &)'&' 0+( &&'(

'(/'++(. P'' (+* +07'* *+&@ '& '0 +*@9'&)C*)'*( 9'&)*+( '()' &0+ /* 0 9'&( & *>)0 '

09&+ +0 9'&( &+ '0+ ',+- '0 *>)0 ' 09&+ '&

0+ 7' (' /'+ '(/'+* &+ &>& ' 09&+.

1.5.3. E"EMPLO

BDSUMA;A4:E2$? E+? A1:E2< O,)'&' 0+ (9+ ' 0+

09&+ E+ 7' 9/0'& & 0( *)'*( '()+,0'+( '&

A1:E2

1.5.7. APLICACI& ' '6'0 BDSUMA ;'* F&&'( /+*+ ,+('( '

+)(<S )'*+9( 0+ (@'&)' )+,0+ ' +)( &''()+*+9( &'*

0+ (9+ ' 0( 9/*)'( 7' **'(/&+& +0 *+&@ ' '=+( '& )

'-'9/0? '0 3$$!$# +0 !$"$# :

0>@+9'&)' (+,'9( 7' ','9( +/0+* 0+ &>&BDSUMA;,+(' ' +)( +9/ *)'*(<

7' '& &'()* '-'9/0 ('*H+:

Om!tica IIP!"ina #(


17/46


II. FUNCIONES FINANCIERAS

2.1. FUNCION INT.EFECTI!O

2.1.1. DESCRIPCION

E()+ &>& &( +00+ '0 )/ ' &)'*( '') +&+0 ;0+ TAE:

)+(+ +&+0 '7+0'&)'< (& @+()(? ('9/*' 7' &8+9(/*'+9'&)' '0 )/ ' &)'*( +&+0 &9&+0 0+ *''&+ '

+/)+08+>& ' 0+ /'*+>& &+&'*+.

2.1.2. SINTA#IS

INT.EFECTI!O;&)&9&+0? &9/'*+K<

=+)==&@ ;,0@+)*


18/46


Datos Descripción

4IN.5EFEC.IVO6A$7A

%8

.asa de inter/s e9ectiva con

los t/rminos anteriores

,-,'%'&$)

INT.EFECTIVO;5.25? 4< $.$53542!

2.1.7. APLICACI


19/46


P* '0 &)*+*? ( '6()'& @+()( + +*@ '0 0'&)' '& 0+ /'*+>&

&+&'*+ & (' )08+* '& 0+ &>& INT.EFECTIVO '0 )/ '

&)'*( &9&+0 /,0)+ /+*+ +00+* 0+ TAE.

P+*+ ')+* '()' &&'&'&)' /*9'* )08+9( 0+ &>& TASA

()+ '& '&)*++( +&)'**'( /+*+ +00+* '0 &)'*( &9&+0 )+&) (

=+ @+() & + +*@ '0 0'&)'.

E0 *'(0)+ 7' &( +* ('* '0 *'(0)+ ' +00+* 0+ >*90+ '

0+ TAE '& 9+)'9)+( &+&'*+(:

2.2. FUNCION !F

2.2.1. DEFINICI


20/46


2.2.7. APLICACI


21/46


U& &'*(* '('+ &*'9'&)+* ( *7'8+. E& 0+ '0+ E1# ('

'6/*'(+ '0 /0+8 ' ( &'*(>& '& 0+ '0+ E1! '() '0 9&) 7'

/*H+ &'*)* +&+09'&)'. L+ '0+ E1" )'&' 0+ )+(+ ' &)'*( 7'

@+&+*H+. E& 0+ '0+ G1" '('+ +00+* '0 &'* 7' )'&* +0 &+0

' ( &'*(>&. A &)&+>& (' /*'('&)+ 0+ (0>&:

2.3. FUNCION PAGOINT

2.3.1. DEFINICION

E()+ &>& &+&'*+ &( ''0' 0+ )+ ' &)'*( ' &/*()+9? +9*)8+,0' 9'+&)' '0 (()'9+ *+&(? '& & /'*H

')'*9&+. E0 )/ ' &)'*( ','* /'*9+&''* &()+&)'

*+&)' '0 )'9/ 7' *' 0+ /'*+>& &+&'*+.

2.3.2. SINTA#IS

PAGOINT;)+(+/'*H&/'*+)/<

T&'& '( 0+ )+(+ ' &)'*( /* /'*H.

Om!tica IIP!"ina $#


22/46


P(/* '( '0 /'*H /+*+ '0 7' (' '('+ +00+* '0 &)'*(

7' ',' '()+* '&)*' 1 '0 +*@9'&) &/'*. N(/ '( '0 &9'* ))+0 ' /'*H( ' /+@ '& &+ +&+0+. !& '( '0 +0* +)+0 0+ (9+ ))+0 ' &+ ('*' ' )*( /+@(. ! '( '0 +0* )* & (+0 '& '') 7' (' '('+ 0@*+*

'(/( ' '')+* '0 0)9 /+@. S '0 +*@9'&) (' 9)'? ('

(/&' 7' '0 +0* '( $ ;/* '-'9/0? '0 +0* )* ' & /*()+9

'( $


23/46


U& /'*(&+ +&+08+ 0( )*9&( ' & /*()+9 =/)'+* &+( '&

'0 *+&@ D1!:E1#. E& 0+ '0+ G1" '('+ +'*@+* +&) (& 0(

&)'*'('( &0H( '& 0+ )+ &++ '& 0+ '0+ E2$. A &)&+>& ('

/*'('&)+ 0+ (0>&:

2.7. FUNCION TASA.NOMINAL

2.7.1. DEFINICION

E()+ &>& &( +00+ '0 )/ ' &)'*( &9&+0 ;TIN< 7' ='9(

/+)+ '& &+ /'*+>& &+&'*+. N*9+09'&)' '( '0 7' &(

'& '& 0( 9()*+*'( ' &+ '&)+ &+&'*+ +&/*'@&)+9( + 7 )/ ' &)'*( &( +& + &''* & /*()+9.

D'/'&'& ' 0( @+()( ' +/'*)*+ ' 0+ *''&+ ' /+@(

'0 /*()+9 +* 0@+* + & ')'*9&+ TAE '& 0+ /'*+>& ;)+(+

+&+0 '')+


24/46


N)(/)& '( '0 &9'* ' /'*H( ' &)'*(

9/'() /* +K.

2.7.3. E"EMPLO

2.7.7. APLICACI


25/46


2.8. FUNCION NPER

2.8.1. DESCRIPCION

L+ &>& &+&'*+ NPER &( +00+ '0 &9'* ' /'*H( 7'

9/&'& &+ *'&)+ &+&'*+ ,+(&(' '& 7' ()+? '()

*9++ /* )*9&( /'*>( &()+&)'(? 7' '0 )/ ' &)'*(

/'*9+&'8+ &()+&)' *+&)' )( 0( /'*H(.

2.8.2. SINTA#IS

NPER;)+(+ /+@ + )/<

M( &*9+>& +'*+ ' 0+( &&'( ' +&+0+'(? '+ VA.

T&'& '( 0+ )+(+ ' &)'*( /* /'*H. P&> '( '0 /+@ '')+ '& ++ /'*H ',' /'*9+&''*

&()+&)' *+&)' 0+ + ' 0+ +&+0+. P* 0 @'&'*+0? /+@&0' '0 +/)+0 '0 &)'*(? /'* & &0' &&@& )* +*+&'0 9/'().

!& '( '0 +0* +)+0 0+ (9+ ))+0 ' &+ ('*' ' )*(

/+@(. ! '( '0 +0* )* & (+0 '& '') 7' (' '('+ 0@*+*

'(/( ' '')+* '0 0)9 /+@. S '0 +*@9'&) (' 9)'?(' (/&' 7' '0 +0* '( $ ;/* '-'9/0? '0 +0* )* ' &/*()+9 '( $


26/46


2.8.7. APLICACI


27/46


2.6. FUNCION !NA

2.6.1. DESCRIPCION

L+ &>& VNA.NO.PER &( ''0' '0 +0* +)+0 &') ' 0(

0-( ' +-+ /()( &'@+)( @'&'*+( /* &+ &'*(>&? &

&''(+*+9'&)' /'*>(? '(/'*+( ' & +) /*') '

&'*(>& )'&'& '& '&)+ & ')'*9&+ )/ ' '('&).

R''*+ 7' ( 0( 0-( )'&'& & 9/*)+9'&) /'*>

)08+*'9( 0+ &>& VNA.

2.6.2. SINTA#IS

!NA;)+(++0*1+0*2...<

T&'& O,0@+)*. L+ )+(+ ' '('&) + 0 0+*@ ' & /'*H. !&@/1 &@/2... V+0*1 '( ,0@+)*? 0( +0*'( (@'&)'( (&

/&+0'(. V+0*1 +0*2 ... ','& )'&'* 0+ 9(9+ *+>& *** +0 &+0

' ++ /'*H. VNA (+ '0 *'& ' +0*1 +0*2 ... /+*+ &)'*/*')+* '0 *'& '

0( 0-( ' +-+. A('@*'(' ' '(*,* 0( +0*'( ' 0( /+@(

' 0( &@*'(( '& '0 *'& +'+.

L( +*@9'&)( 7' (& '0+( +H+(? +0*'( 0>@( *'/*'('&)+&'( )'6)+0'( ' &9'*(? +0*'( ' '*** )'6)

7' & (' /''& )*+* + &9'*(? (' /+(+& /* +0). S & +*@9'&) '( &+ 9+)*8 &+ *''*'&+? (0 ('

&('*+*& 0( &9'*( ' '(+ 9+)*8 *''*'&+. S' /+(+&

/* +0) 0+( '0+( +H+(? +0*'( 0>@(? )'6) +0*'( ' '***

' 0+ 9+)*8 ' 0+ *''*'&+.2.6.3. E"EMPLO

4!NA;1$?1$$?1$$?1$$?1$$?1$$< 3!#.$"

Om!tica IIP!"ina $)


28/46


Datos Descripción

,-# .asa anual de descuento

:#,,,, Costo inicial de la inversi=n un

a3o des1u/s de la 9eca

actual

%,,, Rendimiento del 1rimer a3o

&$,, Rendimiento del se"undo a3o

(*,, Rendimiento del tercer a3o

Fórmula Descripción Resulta

do

4VNA6A$7A%7A&7A'7

A(8

Valor neto actual de esta

inversi=n

##**-&&

?

2.6.7. APLICACI


29/46


U& &'*(* '+0+ & &'@. E& '0 *+&@ E1!:E21 '() 0+

&'*(>& &''(+*+? 0( ,'&'( '(/'*+( '0 +0* ' *'/'*

' 0+ &'*(>&. E& 0+ '0+ E23 '() 0+ )+(+ ' '('&) + )08+*.

E& 0+ '0+ G1" '('+ +'*@+* '0 +0* +)+0 &') ' ( &'*(>&. A &)&+>& (' /*'('&)+ 0+ (0>&:

2.?. FUNCION PAGO

2.?.1. DESCRIPCION

E()+ &>& +00+ '0 9/*)' ' 0+ +&)+ -+ + '0'* ;)*9&

+9*)8+)< ' & /*()+9 7' (' +9*)' /* '0 9) '0(()'9+ *+&( ' +&+0+ &()+&)'.

R''*+ 7' '()' (()'9+ ' +9*)8+>& ' /*()+9( ('

+*+)'*8+ /*7' )( 0( )*9&( +9*)8+)( (& &()+&)'(

/(/+@+,0'( ;(' /+@+& + &+0 ' ++ /'*H ' +9*)8+>&< ('

&('*+ 7' '0 )/ ' &)'*( ' 0+ /'*+>& & +*H+ '& '0

)'9/.

2.?.2. SINTA#IS

PAGO;)+(+&/'*+)/<

T&'& '( '0 )/ ' &)'*( '0 /*()+9. N(/ '( '0 &9'* ))+0 ' /+@( '0 /*()+9. !& '( '0 +0* +)+0? 0+ +&)+ ))+0 ' &+ ('*' '

)*( /+@(. T+9,& (' &' 9 +0* ,*()0. ! '( '0 +0* )* & (+0 '& '') 7' ('

'('+ 0@*+* '(/( ' '')+* '0 0)9 /+@. S '0

Om!tica IIP!"ina $+


30/46


+*@9'&) (' 9)'? (' (/&' 7' '0 +0* '( $ ;'(

'*? '0 +0* )* ' & /*()+9 '( $


31/46


2.5. FUNCION PAGOPRIN

2.5.1. DESCRIPCION

E()+ &>& ' E6'0 &( +00+ 0+ )+ ' +9*)8+>& ' +/)+0' & /*()+9? +9*)8+,0' 9'+&)' '0 9) *+&( '

+&+0+ &()+&)'? '& & /'*H ')'*9&+. L+ )+(+ (' )'&'

7' 9+&)'&'* &()+&)' *+&)' '0 )'9/ 7' *' 0+ /'*+>&

&+&'*+ '& '()>&.2.5.2. SINTA#IS

4PAGOPRIN;)+(+/'*H&/'*+)/<

P+*+ ,)'&'* &+ '(*/>& 9( 9/0')+ ' 0( +*@9'&)(' PAGOPRIN? '+ 0+ &>& VA.

T&'& '( 0+ )+(+ ' &)'*( /* /'*H. P(/* '(/'+ '0 /'*H? 7' ',' '()+* '&)*' 1

'0 +0* ' &/'*. N(/ '( '0 &9'* ))+0 ' /'*H( ' /+@ '& &+

+&+0+. !& '( '0 +0* +)+0? '( '*? '0 +0* ))+0 7' )'&'

+)+09'&)' &+ ('*' ' /+@( )*(. ! '( '0 +0* )* & (+0 '& '') 7' ('

'('+ 0@*+* '(/( ' '')+* '0 0)9 /+@. S '0

+*@9'&) (' 9)'? (' (/&' 7' '0 +0* '( $ ;'(

'*? '0 +0* )* ' & /*()+9 '( $


32/46


2.5.7.

APLICACI & /*()+9 & & 0'&)' '0 2 ' +,*0 ' 2$14 +'0'* '& " +K(. L+( +*+)'*H()+( &+&'*+( '0 /*()+9 (&

0+( (@'&)'(:C+/)+0 /*'()+: 1#.142?14 '*(N9'* ' )+( 9'&(+0'(: # ;" 6 12<T/ ' &)'*( &9&+0: ?25 F'=+ '0 /*9'* )*9& A9*)8+): 2 ' -& ' 2$14.

T'&'9( 7' +00+* '0 9/*)' ' 0+ )+ ' +9*)8+>& '

+/)+0 & 2 )08+& 0+ &>& PAGOPRIN.

Om!tica IIP!"ina %$

Datos Descripción del argumento

#,@ .asa de inter/s anual

$ N0mero de a3os del 1r/stamo

$,,,-,, ? Im1orte del 1r/stamo

Fórmula Descripción Resultado

=PAGOPRN(

A!"#!$#$A%

!$A')

Pa"o 1rinci1al 1ara el mes # del

1r/stamo

6)'-($ ?8


33/46


2.;. FUNCION !A

2.;.1. DESCRIPCION

E()+ &>& &( ''0' '0 +0* +)+0 ' &+ *'&)+ &+&'*+ /(

/+@+,0' /*'/+@+,0' ;('@& /+*9')* &)*


34/46


2.;.7. APLICACI


35/46


2.10.1. DESCRIPCION

C& 0+ &>& TASA +00+9( '0 )/ ' &)'*( /* /'*H

*+&+ /+*)'& ' & +/)+0 &+0 ' &+ *'&)+ /'*>+

&()+&)' )'9/*+0. E( '* &( +00+* '0 )/ ' &)'*(

&9&+0 /* '0 &9'* ' /+@( 7' =+'9( '& & +K.

2.10.2. SINTA#IS

TASA;&/'*/+@+)/'()9+*<

V'+ 0+ &>& VA /+*+ ,)'&'* &+ '(*/>& 9/0')+ ' 0(

+*@9'&)( &/'* /+@ + )/.

N(/ '( '0 &9'* ))+0 ' /'*H( ' /+@ '& &++&+0+.

P&> '( '0 /+@ '')+ '& ++ /'*H? 7' &

/'' +*+* *+&)' 0+ + ' 0+ +&+0+.

G'&'*+09'&)' '0 +*@9'&) /+@ &0' '0 +/)+0 '0

&)'*(? /'* & &0' &&@& )* +*+&'0 9/'(). S

(' 9)' '0 +*@9'&) /+@? ','* &0*(' '0

+*@9'&) . !& '( '0 +0* +)+0? '( '*? '0 +0* ))+0 7' )'&'

+)+09'&)' &+ ('*' ' /+@( )*(. ! '( '0 +0* )* & (+0 '& '') 7' ('

'('+ 0@*+* '(/( ' '')+* '0 0)9 /+@. S '0

+*@9'&) (' 9)'? (' (/&' 7' '0 +0* '( $ ;/*

'-'9/0? '0 +0* )* ' & /*()+9 '( $& ' 0+ )+(+ ' &)'*(.

S '0 +*@9'&) '()9+* (' 9)'? (' (/&' 7' '( 1$

/* '&).S TASA & &'*@'? )*+)' ' (+* '*'&)'( +0*'(

/+*+ '0 +*@9'&) '()9+*. TASA @'&'*+09'&)' &'*@'

( '0 +*@9'&) '()9+* (' '&'&)*+ '&)*' $ 1.

Om!tica IIP!"ina %'


36/46


2.10.3. E"EMPLO

4TASA;3? 25$$? 12$$$$< 1.4"

2.10.7. APLICACI& )08+& 0+

&>& &+&'*+ TASAD=+ '*)+ (' 9+&)'&* =+()+ '0 2$ ' ),*' ' 2$14.

Om!tica IIP!"ina %(


37/46


III. FUNCIONES DE BUSQUEDA Y REFERENCIA

3.1. FUNCION ELEGIR

3.1.1. DESCRIPCION

U(+ '0 +*@9'&) &9H&' /+*+ '0'* & +0* ' &+ 0()+ '

+*@9'&)( ' +0*'(. U(' ELEGIR /+*+ ('0'&+* & ' 0(

254 +0*'( /(,0'( + /+*)* '0 *+&@ '0 +*@9'&) H&'. P*

'-'9/0? ( +0*1 + +0*! (& 0( H+( ' 0+ ('9+&+? ELEGIR

''0' & ' 0( H+( +& (' (+ & &9'* '&)*' 1 ! 9

+*@9'&) &9H&'.

3.1.2. SINTA#IS

ELEGIR$=)=*( &@/1 &@/2H ...%

N)=*( O,0@+)*. E(/'+ '0 +*@9'&) ' +0* 7'

(' ('0'&+. E0 +*@9'&) &9H&' ',' ('* & &9'*

'&)*' 1 254? ,'&? &+ >*90+ *''*'&+ + &+ '0+ 7'

&)'&@+ & &9'* '&)*' 1 254.

Om!tica IIP!"ina %)


38/46


!&@/1 &@/2... V+0*1 '( ,0@+)*? 0( +0*'( (@'&)'(

(& /&+0'(. D' 1 + 254 +*@9'&)( ' +0*'( '&)*' 0(

+0'( 0+ &>& ELEGIR ('0'&+ & +0* +>& 7' ('

'-')+ ,+(&(' '& '0 +*@9'&) &9H&'. L(

+*@9'&)( /''& ('* &9'*(? *''*'&+( + '0+(? &9,*'(

'&(? >*90+(? &&'( )'6).

3.1.3. E"EMPLO

4ELEGIR;1? UNO? DOS? TRES< UNO4ELEGIR;3? UNO? DOS? TRES< TRES

3.1.7. APLICACI& ELEGIR )'&' &+

@*+& (90) & 0+ &>& BUSCARV 0+ +0 '( &+ &>& 9=9( /'*(+. D' ='=? '0 '-'9/0 +&)'** 0 /9( =+,'*

*'('0) & 0+ (@'&)' >*90+:

BUSCARV;E2? A3:B12? 2<

A(H 7'? )+0 '8 ('*& /+( 0+( +(&'( '& 0+( 7' )0'( 0+

&>& ELEGIR? /'* '( 9/*)+&)' 7' ('/+( ' ( '6()'&+ (

&&+9'&).

3.2. FUNCION BUSCAR $CONSULTA 2010%

Om!tica IIP!"ina %*


39/46


3.2.1. DESCRIPCION

B(+ & +0* '& 0+ 0+ (/'** ' &+ )+,0+ &+ 9+)*8 '

+0*'( ''0' & +0* '& 0+ 9(9+ 09&+ ' &+ 0+'(/'++ '& 0+ )+,0+ 9+)*8. U(' BUSCAR% +& 0( +0*'(

' 9/+*+>& (' '&'&)*'& '& &+ 0+ '& 0+ /+*)' (/'** '

&+ )+,0+ ' +)( '('' '&&)*+* &*9+>& 7' (' =+00'

'&)* ' & &9'* '(/'+ ' 0+(. U(' BUSCARV +&

0( +0*'( ' 9/+*+>& (' '&'&)*'& '& &+ 09&+ + 0+

87'*+ ' 0( +)( 7' '('+ '&&)*+*.L+ % ' BUSCAR% (@&+ %*8&)+0.

3.2.2. SINTA#IS

BUSCAR;+0*,(+? 9+)*8,(+*'&? &+*0+(?

*'&+<

!&@/)'&* O,0@+)*. E( '0 +0* 7' (' ,(+ '& 0+

/*9'*+ 0+ ' 0+ )+,0+. V+0*,(+ /'' ('* & +0*? &+

*''*'&+ &+ +'&+ ' )'6). M&+/J)'&/)(= O,0@+)*. E( &+ )+,0+ ' &*9+>& '& 0+

7' (' ,(+& 0( +)(. U(' &+ *''*'&+ + & *+&@ '0

&9,*' ' & *+&@.L( +0*'( ' 0+ /*9'*+ 0+ '0 +*@9'&) 9+)*8,(+*'&

/''& ('* )'6)? &9'*( +0*'( 0>@(. I=*&*/)@&' O,0@+)*. E( '0 &9'* ' 0+ '&

9+)*8,(+*'& '(' '0 +0 ',' '0'*(' '0 +0*

&'&)'. S &+*0+( '( 1? ''0' '0 +0* ' 0+ /*9'*+

0+ '& 9+)*8,(+*'& ( &+*0+( '( 2? ''0' '0 +0* ' 0+ ('@&+ 0+ '& 9+)*8,(+*'& +(H ('(+9'&)'.O/*(=&* O=&@. E( & +0* 0>@ 7' '(/'+ (

BUSCAR% ',' 0+08+* &+ &'&+ '6+)+ +/*69++. S

0 9)' '( VERDADERO? '0'* &+ &'&+

+/*69++.

3.2.3. E"EMPLO

Om!tica IIP!"ina %+


40/46


BUSCAR;E6'0? A1:J2? 2< E&'&)*+ E6'0 '& 0+

0+ 1 *'@*'(+ '0 +0* 7' 0' **'(/&' ' 0+ 0+ 2

3.2.7. APLICACI& BUSCAR )'&' ( *9+( ' (&)+6(:

F*9+ ')*+0. F*9+ 9+)*+0.

3.3.2. SINTA#IS

Om!tica IIP!"ina &,


41/46


BUSCAR;+0*,(+? *+&@9/+*+>&? *+&@*'(0)+<

&@/)'&* $@>&+/%: V+0* 7' (' ,(+* '& '0

*+&@9/+*+>&. /&=>)&/&K= $@>&+/%: E0 *+&@ ' '0+(

& 0( +0*'( 7' ('*& ,(+(. P'' ('* &+

09&+ &+ 0+. /&=>)/('@+&*: $=&@%: E0 *+&@ ' '0+( 7'

&)'&* 0( *'(0)+(. D',' ('* '0 9(9 )+9+K

7' *+&@9/+*+>&.

3.3.3. E"EMPLOBUSCAR;5? A1:A#? B1:B#< B(+ '0 +0* 5 '& '0 *+&@ A1:A#

( 0 '&'&)*+ ''0' '0 +0* ' 0+ 9(9+ 0+ /'* '0

*+&@ B1:B#

3.3.7. APLICACI& BUSCAR ;9 . T+9,& (' /''

,)'&'* '0 9(9 *'(0)+ & 0+ &>& BUSCARA )+9,&

9'+&)' '0 )*+,+- &-&) ' 0+( &&'( COINCIDIR ' [NDICE.E& 0+ )+,0+ /*'('&)+9( (0 0( 1$ /*9'*( H+( '0 H+ + ,(+*

0 ()+9( '& 0+ '0+ G3 '& '0 '-'9/0:

Om!tica IIP!"ina


42/46


3.7. FUNCION COENCIDIR

3.7.1. DESCRIPCION

L+08+ & +0* '& & ')* ;*+&@ ' &+ (0+ 09&+ 0+<

''0' '0 &9'* ' /(>& '& 0+ 7' (' '&'&)*+ = +0*. S

0 '&'&)*+ '& 0+ /*9'*+ /(>& '0'*H+ & 1? '& 0+ )'*'*+

/(>& '0'*H+ & 3...S' )08+ /+*+ 0+08+*? /* '-'9/0? '& &+ )+,0+ *')+&@0+* '&

&' '6()'& )H)0( ' 0+ )H)0( ' 09&+? '& 7 /(>& ('

'&'&)*+ '& '0 *+&@ ' )H)0( ' 0+ & ')'*9&+ +0*? &

)*+ &>& &* '& 7 /(>& (' '&'&)*+ & +0* '&)* '0*+&@ 7' +,+*+& 0( )H)0( ' 09&+.

3.7.2. SINTA#IS

COINCIDIR;+0*,(+? *+&@? )/'&'&+<

&@/)'&* $@>&+/%: V+0* 7' (' ,(+* '& '0

*+&@ /&=> $@>&+/%: E0 *+&@ ' '0+( & 0( +0*'(. +)*()=*(=& $=&@%: I&+ ( ('* &+

&'&+ '6+)+ > +/*69++. S (' 9)' (' )9+

9 +/*69++.

3.7.3. E"EMPLO

4COINCIDIR;E6'0? A1:A1$? $< E&'&)*+ E6'0 '& 0+

09&+ A *'@*'(+ 0+ /(>& '&)* ' 0+ 0()+ &' '

'&&)*+ '0 +0*

Om!tica IIP!"ina &$


43/46


4COINCIDIR;JOX? A1:A1$< # L+ &>& COINCIDIR

''0' '0 &9'* # /*7' '( '0 '0'9'&) 7' &)'&' +0

9'&( &+ ' 0+( 0')*+( '0 +0* ,(+ '(? /* 0 )+&)? 0+

9'-* &'&+ '&&)*++.3.7.7. APLICACI& '( 9 9/*)+&)' '& E6'0. E( &+ *9+ ++&8++' ,(+* +0*'( '& & *+&@ ' '0+( + 7' (())' '&

9=+( +(&'( + 0+( /(,0+'( ' )*+,+- ' 0+ &>&

BUSCAR.B(+ & +0* '& 0+ /*9'*+ 09&+ ' &+ )+,0+ ;*''*+

9'+&)' ( *+&@ &9,*'


44/46


09&+ ' +)+7' ','* '()+* *'&++ +('&'&)'9'&)' /*

(( +0*'(.

3.8.2. SINTA#IS

BUSCAR! ;+0*,(+? 9+)*8,(+*'&?&+*09&+(? *'&+<

E@ &@/ '&*: +0* '0 +) *''*'&+ + '0+ 7'

&)'&' '0 +) & '0 7' (' '('+ '6)*+'* 0+ &*9+>& ' 0+

09&+ 87'*+ ' 0+ )+,0+ '& 0+ 7' (' 7'*' ,(+*. M&+/J: *+&@ ' '0+( 7' &)'&'& )( 0( +)( ' 0+ )+,0+

;*+&@ ' 0+ )+,0+& + 0+

)+,0+? '& 0+ 7' (' '&'&)*+ '0 +) 7' (' 7'*' '6)*+'* ;( 0+

)+,0+ )'&' 3 09&+( (& 1? 2 ,'& 3


45/46


4BUSCAR!;E6'0? A1:B1$? 2< E&'&)*+ E6'0 '& 0+

09&+ A *'@*'(+ '0 +0* 7' 0' **'(/&' ' 0+ 09&+ B

3.8.7. APLICACI@ ' 9+*+ 7' '('+9( ,(+* '& 0+ )+,0+:

A5. L+ 9+)*8? '( '0 *+&@ 7' +,+*+ 0+ )+,0+ ;(& 0+ ' )H)0(


46/46


L+( &&'( ' E6'0 (& &+ ' 0+( ='**+9'&)+( 9( /'*(+( '&)*

' &+ =-+ ' 00. E()+( &&'( &( +0)+& 9= 0+ *'+08+>& '

00( )*+)+9'&) ' 0( +)(.

P+*+ /'* *'+08+* &+ =-+ ' E6'0 )08+& &&'( '( 9/*'(&,0'

&'* ++ &+ ' '00+( ' *9+ &+0.E6'0 =+ *'+ )+&)+( &&'( /+*+ (+)(+'* ++ &+ ' 0+( '*'&)'(

&''(+'( 7' '6@' ++ & ' (( (+*(? /* '-'9/0 & '9/*'(+*

+07'* /'*(&+ '& 0+ *+9+ ' '6+)+( /+ &&'( '()+H()+(?

&+&'*+( 9+)'9)+(? '). /+*+ )'&'* & )*+,+- 9( *'&+& &

9+'()* /+ &&'( 0>@+( ' '=+ =*+ /+*+ 00'+* & 9'-*

&)*0 ' 0+( +0+&'( ' (( +09&(? +(H ++ &+ ' 0+( &&'(7' )'&' '()+ +/0+>& /* 9( ('&00+ 7' ('+ &( ++& + 9=+( '

0+( )+*'+( 7' ','9( =+'* & (0 '& &'()*+ *'+ 0+,*+0 (& '&

+07'* )*+...

L+( >*90+( &())'& '0 &0' ' +07'* =-+ ' 00? /* )+&) '

E6'0. M'+&)' >*90+(? (' 00'+& + +, )( 0( 00( 7' ('

&''()+&

'& &+ =-+ ' 00. L+( >*90+( (' /''& )08+* /+*+ 90)/0'( )+*'+(:'(' *'+08+* /'*+&'( ('&00+(? )+0'( 9 (9+( *'()+(? =+()+

9/0'-( 00( &+&'*(? '()+H()( '&)H(.

V5 BIBLIOGRAFIA

trabajo encargado de ofimatica 2

Documents