Tip:
Highlight text to annotate it
X
Well, we saw in the video above how easy it is ...
...make a sum with "Auto sum". Now let's do it manually, let's ...
...we will select a cell ...
... we will write a number, ...
...(remember too, but rather, let's say something...
...not mentioned in previous videos...
... and that is to select the cell ...
... we can also use the keys up, down and left, right ...
...of the keyboard...
... always going to be much more comfortable, in this case I'm going to use the keys) ...
...in the second cell write ...
...another number...
...and in the third cell, I will place the result...
To insert a function, we recall that we have to select the cell ...
... in which we will insert the function.
Every function begins ...
...with an equal sign (=).
Place the name of the function, we see that as we write, we see...
...a list of ...
...suggestions.
We write: SUM ...
...brackets ...
...and cells that are to be added, in this case ...
...is the cell D...
...5...
...two points and cell D...
...6.
Press ENTER...
...and see the result.
We see that the result is the same as if we had used the SUM AUTO ...
... but we did it manually. This is important to learn ...
...to do this manually, because later we will serve.
Let's copy and paste this ...
... and now we will use ...
... different function.
Let's clear ...
...the SUM ...
... and we will put a POWER ...
...POWER...
...sorry, a QUOTIENT, a PRODUCT...
...a PRODUCT...
...PRODUCT,select it here.
PRODUCT, always have to press ENTER ...
...and now...
We multiply 5 by 6 and the result is 30.
We even ...
...add,...
... multiply or divide...
...this result and this. We see...
...that changing this or that, change the functions up here.
If we position ourselves in this cell, we see that is a sum.
If we position ourselves in this cell, we see that it is a product ...
...and here...
...we can, for example, add this to the other.
Then we position ourselves...
...and we...
...again write...
...an equal sign(=), SUM ...
...parentheses...
...and chose...
...the cell...
...F...
...7, F7...
...separated by a colon(:)...
...and the cell D7,...
...press ENTER...
...and we see that, now, is adding ...
...11 to 30.
If we change any of these, if we put here a seven...
...would see immediately the result here.
If we turn to change and put 22 ...
...see how it changes and as a result here changes here ...
... and all this is done automatically, the sums ...
...and powers ..
...uh, sorry for the sums and products ...
...the Excel calculates, and we simply modify the cell...
...contents.
Remember that if you modify the contents of the cells that contain...
...functions...
...If, for example, we delete...
...the contents of this cell, the result will not delet ...
...delete the function ...
...unintentionally.
Let's see how important this is...
...because when we...
...erase...
...we will see ...
...that the result, in this case is 51...
...because the content of this cell has been emptied.
If we go back we will have ...
... the result. In this case nothing happens, we do not present any error ...
...but when we divide...
...or use other mathematical functions......
...and function encounters...
...an empty cell, we were introduced errors. That's why it is....
... important to remember ...
...that the cells...
... should never be empty...
...on some occasions. In this case saw......
...that not present any problem.