Excel Formulas
Formulas are important for us to make math processes
quicker. With them we can have our information in order and record notes
about grades, money, etc.
How to use these formulas?
It’s not that difficult; in this port I’ll teach two formulas and
how to use them
The first one is simple.
1. You create the table with all the data you
need. In my example the information isn’t true, but it is to give just an idea.
To
know the average you have to place the square in the place of the total, than,
go to the upper part of your tools and select the one that says average and it
automatically solves the problem
The formula used in here is =AVERAGE(B3:B9), you just have
to put the name of the cells you want to make the average and then ENTER.
The Second formula is easy too, it is SUM
1.
Using the same example, I’ll sum the amount of
fruits for each month
You select the cell where you want the results.
Cllick the SUM symbol at the right upper corner.
And just like the other formula, you press ENTER
and have the results. The formula used here is =SUM(B3:E3).
How to use Graphs?
- Using the information in the chart, you can make graphs to order and show your information in a funny way.
- You just have to order the inrformation in the chart, and the select the data you want to be inside the graph
- IN the upper part of excel, INSERT, there you have the tipes of graphs
I hope the information in here works! Good Luck :)
If there is something missing check this video:
