How to use formulas and graphs/charts in Excel 2010
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:a 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