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
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.


No hay comentarios:
Publicar un comentario