Catégories : Tous - texto - fecha - promedio - sumar

par julieth toncon Il y a 3 années

285

FUNCIONES DE EXCEL

Excel ofrece una amplia gama de funciones para gestionar datos de manera efectiva. Las funciones matemáticas incluyen herramientas como CONTAR.SI.CONJUNTO, ENTERO y PROMEDIO, que permiten contar elementos según condiciones, redondear números y calcular promedios.

FUNCIONES DE EXCEL

FUNCIONES DE EXCEL

To name your story, you have to think about the overall message and what you want your audience to understand from the story. Also, make it relevant and easy to remember.

FUNCIONES DE EXCEL LÓGICAS

The ending of a story is essential. We all know that if the ending is weak, what happened before loses its importance. So make it unpredictable, but fair. A resolved ending answers all the questions and ties up any loose threads from the plot.

o

This is the closure section of the story.
See examples of possible outcomes below:

anidar dos o más condiciones de manera no excluyente.

Try answering these questions to come up with a closure:
- Have all the problems been solved?
- Is there a clear picture of what happens with each character in the story?
- Has the challenge transformed your main character?
- How do the characters feel in the end?

Y

This is the moment when the main character surpasses the last obstacle and finally faces their greatest challenge.
The climax usually follows one of these patterns:


Type in your answer.

anidar dos o más condiciones de manera excluyente.
si
nos permite evaluar una condición y devolver un resultado si se cumple y otro sino se cumple

FUNCIONES DE FECHA

SIFECHA
esta función permite hacer un condicional con una fecha.
AÑO
obtener el año de una fecha.
AHORA
esta función nos devuelve la fecha del día y la hora.
HOY
esta función nos devuelve la fecha del día.

Funciones de texto

The middle of the story is where you add layers of complications that will lead to the end. Reveal more about the character's journey. Did their personality go through changes? How did they overcome the challenges? And as you build up the story’s central conflict, make it more personal to that character. Also, from the middle act, you have to lead into the final act.

IGUAL( texto1 ; texto2 )
Compara dos cadenas de texto y devuelve VERDADERO si son exactamente iguales FALSO si no lo son. Esta función reconoce mayúsculas y minúsculas, pero pasa por alto las diferencias de formato.
EXTRAE( texto ; inicial ; caracteres )
Devuelve un número específico de caracteres de una cadena de texto, comenzando en la posición que especifique y en función del número de caracteres que especifique.
ENCONTRAR( texto ; dentro ; inicial )

There wouldn't be any tension and excitement in your story if there weren't any obstacles in your character's way.

Esta función encuentra una cadena de texto dentro de otra y devuelve el número del carácter en el que aparece por primera vez texto desde el primer carácter de dentro.

A story is nothing more than a character overcoming a series of difficulties to reach the desired goal. Obstacles usually create suspense and conflict. In overcoming obstacles, there is growth: weak becomes strong; hatred turns into love; sadness into happiness; wrong into right; lies into truth; or evil becomes good.

See a few examples below:

Inicial: especifica el carácter a partir del que comenzará la búsqueda.

dentro: es el texto que a su vez contiene el texto que se desea encontrar.

texto: es el texto que se desea encontrar.

DERECHA

Your character(s) need(s) motivation in order to solve the challenge(s).

Extrae un número de caracteres a partir de otra cadena, desde la derecha.

Secondary characters might also have motives that lead them to cross paths with the main character or which might trigger them to help the main character.

devuelve un número de caracteres dado empezando por la derecha.

Why does your character need to confront this challenge? What does he/she expect to accomplish by solving it?
See a few examples:

DERECHA(texto,[núm_de_caracteres])

CONCATENAR( texto1 ; texto2 ; ... )

Each story has a main character and that character usually needs to solve a problem or challenge. The character's challenge is the one that creates tension throughout the story.

une varias celdas o cadenas de texto.

Type in any other challenges which other characters in the story need to face.

Other challenges

Concatena argumentos de texto.

In most stories, there are 3 challenges. The number 3 is a mystical number symbolizing completeness. Try to come up with interesting challenges with which your character needs to struggle.
See a few examples below:

FUNCIONES DE EXCEL MATEMÁTICAS

In the beginning of the story (or the exposition), you will need to introduce the setting and characters. You might also want to introduce the main conflict. This part of the story is important because it gives the reader necessary background information and maybe even a first insight into a character’s personality.

PUEDEN SER

The setting (time & place) of a story can change throughout the plot.

PROMEDIO

Sensory details include sight, sound, touch, smell, and taste. These details are important because they create depth in your setting.
See a few examples below:

otro tipo de funcion es PROMEDIO.SI.CONJUNTO

Devuelve el promedio (media aritmética) de todas las celdas que cumplen múltiples criterios.

Escribimos =PROMEDIO. A continuación, seleccionamos con el ratón el rango de celdas del cuál queremos calcular el promedio.

calcula la media aritmética de un rango de celdas.

entero

The weather is an important element in your story because it can highly influence the ambiance and the mood of the characters.

Redondea 8,9 hacia abajo 8

The most affected character is the main character. Write down here if he/she is affected by these weather conditions in any way. For example, if they lost a family member or their home during a hurricane, etc.

=ENTERO(8,9)

Decide if you want to include an element of nature in your story. For example, a rainbow can be a very nice choice for a happy ending. The mist in a story can represent mystery and secrets. A thunder can appear in the background at the moment when the 'bad guy' of the story makes its appearance, etc.

extraer el número entero de un valor.

Does your story include catastrophic weather? See a few suggestions below or add your own:
- hurricane, earthquake, storm, etc

CONTAR.SI.CONJUNTO

The time of the story can also change. It can describe the event of a single day or can include an entire year's plot. Anyway, don't forget to mention it.

=CONTAR.SI.CONJUNTO(A2:A7, "<5",B2:B7,"<3/5/2011")

contar los elementos de una lista dependiendo de varias condiciones.

contar

Your story can take place wherever your imagination will take you to.
For example: in an elevator, in an enchanted forest, etc. Don't forget to give details of the environment each time the setting changes, otherwise, the story can be confusing. Also, mention the seasons as each of them has unique weather and events.

=CONTAR(A2:A7)

contar los elementos que hay en un rango.

SUMAR.SI

Characters are essential to a good story. Usually, the protagonist(s) is/are the most affected by the plot. Introduce a character by focusing on their actions, interests, and occupation, as the physical appearance doesn't make a difference in most cases.

Por ejemplo, la fórmula =SUMAR.SI(B2:B5,"Juan",C2:C5)

Type in the name of your character.

suma de varios elementos con una condición.