martes, 11 de marzo de 2014

Formulas
First, enter excel 2010
In order to use formulas, you have to be in the option : home 
Select all the information you want (names, ages,dates,total)
Then, you have to select the symbol of sum and select the formula you need
Finally press enter
The most common used formulas are, SUM, AVERAGE, MULTIPLICATION, CALCULATING PERCENTAGES and DIVISION.
Sum: for performing this task you need to enter this formula :=SUM(A2:B3)
Average: for performing this task you need to enter this formula :=AVERAGE(A1:C4)
Multiplication: For performing this task you need to enter this formula: =(A1*C4)
Division: For performing this task you need to enter this formula: =(A1/C4)
Calculating percentages: For performing this task you need to enter this formula: =(A1*C4/100) or


 =(D4 /C4) *100











Types of graphs/charts

There are many Types of graphs or charts you can use in order to organize your information. I use charts and graphs because it is easier for me to visualize data and information. Its a good way to divide information and i think it looks better with different colors and forms.
In addition, it is a very good way to summarize the information. I use graphics in order to display the most relevant information and make emphasis on the most important data as total, average etc. There are several types of charts and this makes it easier to find the right one to display any type of information and make it clearer.





No hay comentarios:

Publicar un comentario