First, you need to have numeric information in your Excel cells. Account information, grade books, pays... anything is useful. There are 2 ways of using formulas:
1. In the upper "menu" inside Home, in the further right side in the Editin subtitle there is an adding simbol. If you press the little arrow beside it, more options will appear, but if you need another formula clicking "more functions" must do it. After selecting the formula you just have to select the cells (clicking with your mouse) you want to be part of the formula.
2. The second way is easier, but you have to know in what language is your computer. For this way, you just choose the cell where you want and the first thing you will write down is "=". This will tell Excel that you want to activate a formula. After =, you write the first letters of the command you want to give. Automatically, Excel will give you further options and you can select them or erase and write again.
Using graphs depend on your formulas or information
For using them you need to have information! After, you select the cells with the mouse, and in insert there is a picture for "graphs" you click in it and you can choose from all different options depending on how you want to picture your information. It will appear, and if you are not happy enough you can edit it, by using "chart tools".
Easy and useful formulas I have used in class:
for adding - =SUM()
for average - =AVERAGE()
No comments:
Post a Comment