Tuesday, March 11, 2014

Formulas in Excel:

Addition: =(D4+C1)

SuBstraction: =(B7-D2)

Multiplication: =(E5*D3)

Average: =average(A1:A10)

Division: =(A2/D3)

Percentage: =(D2*100)/A4

1)    Bar Graphs: Bar graphs are one of the most common graphs used to compare information. Also known as column charts.


 2) Line Graphs: Line graphs are used to compare changes in information over time



 3) Scatter Plot Graphs: Scatter plot graphs are used to show trends in information.


 4) Pie Charts: A special graph that uses "pie slices" to show relative sizes of
information.


5) Column Charts: Also known as Bar Graph


 6) Area Charts: displays graphically quantitive information


7) Stock Charts: is a simple two-axis (x-y) graph of price and time.


 8) Doughnut Charts: the same as a pie chart but the difference is that in this one the center is blank

 9) Radar Charts: graphical method of showing multivariate information in the form of a two-dimensional chart of three or more variables represented on axes starting from the same point

 10) Surface Charts:  a surface chart shows the distribution of sea-level pressure, the location and nature of fronts and air masses


 10) Surface Charts:  a surface chart shows the distribution of sea-level pressure, the location and nature of fronts and air masses



VIDEO:





No comments:

Post a Comment