Materia informativa Educativa
Prof. Juan Carlos Pérez Molina
Secciones: Primero General A y primero tecnico (contador, Diseño, sistemas)
La seccion de Primero general "B" solo relizara la segunda parte (15%)y el resto completo (35%)
Formama de entrega:Paginas de papel bond, con su respectivo folder
Fecha de entrega: lunes 24 de octubre
Indicación: Utilizando su libro de trabajo conteste cada una de las siguientes preguntas.
1. Cuál es la diferencia entre la función suma y sumar.si
________________________________________________________________________________________________________________________________________________________________________
2. Cuál es la diferencia entre la función contar y contar.si
________________________________________________________________________________________________________________________________________________________________________
3. Mencione y explique cuáles son los argumentos que necesita la función Sumar.Si
________________________________________________________________________________________________________________________________________________________________________
4. Mencione y explique cuáles son los argumentos que necesita la función Si
________________________________________________________________________________________________________________________________________________________________________
5. Explique cuáles son los resultados que arrojarían las siguientes formular.
a. =Contar(A10:A100)
__________________________________________________________________________________________________________________________________________________________
b. =Sumar.si(A10:100;”Juan”;B10:B100)
__________________________________________________________________________________________________________________________________________________________
c. =Sumar.si(B1:B100;”>=10”;C1:C100)
_______________________________________________________________________________________________________________________________________________________
d. =contar.si(A12:A100;”Lopez”)
__________________________________________________________________________________________________________________________________________________________
e. =contar.si(A14:A60;”<20”)
__________________________________________________________________________________________________________________________________________________________
f. =si(a12>20;max(a20:a30);promedio(a20:a30)
__________________________________________________________________________________________________________________________________________________________
g. =si(B12=”Juan”;B20;c20)
__________________________________________________________________________________________________________________________________________________________
SEGUNDA PARTE
Investigue la función, sintaxis, ARGUMENTOS y ejemplo de cada una de las siguientes formulas prediseñadas.
Para realizar esta tarea investiguela utilizando la ayuda de excel, en la seccion "ayuda sobre esta funcion", Formulas/insertar funcion
Función “Y”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
__________________________________________________________________________________________________________________________________________________________________________
Función “O”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “TIR”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “TASA”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “ESPACIOS”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “CARACTER”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “EXTRAER”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “FRECUENCIA”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “PAGOINT”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “PAGOPRIN”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “PRECIO.DESCUENTO”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “PRECIO”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “TIRM”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “VNA”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “HORA”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “AÑO”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “DIA”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “COS”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Función “EXP”
_________________________________________________________________________________________________________________________________________
Sintaxis:
_____________________________________________________________________
Argumentos:
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
