Mathematical Operators

Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents. 

Standard operators

All formulas in Excel must begin with an equal sign (=). This is because the cell contains, or is equal to, the formula and the value it calculates.

Understanding Cell References

While you can create simple formulas in Excel manually (for example, =2+2 or =5*5) most of the time you will usecell addresses to create a formula. This is known as making a cell reference. Using cell references will ensure that your formulas are always accurate, because you can change the value of referenced cells without having to rewrite the formula.

Using cell references to recalculate a formula

By combining a mathematical operator with cell references, you can create a variety of simple formulas in Excel. Formulas can also include a combination of cell references and numbers, as in the examples below:

Formulas 

• ·         Enter excel 2010
• ·         Add the information that you want, ages, grades, sells, etc.
• 
• ·         Go to the option home
• 
• ·         Select the sum symbol to sum, or chose another option.
• 
• ·         Press enter
• ·         And enjoy your formula J

Types of Charts 

·         Column charts

A column chart shows data that illustrates a comparison between 2 things or shows data changes over a period of time.

·         Bar charts

A bar chart illustrates comparisons among individual items.

There are different types of Bar charts:

o  I would use it most of the times to make a chart about a data in different years to see how it increased or decreased. 

 

·         Pie charts

A pie chart shows the size or percentage of items that make up a data series, proportional to the sum of the items. Is usefull for percentage. 

Graphs and Charts 

• ·         Enter excel 2010
• ·         Add the information that you want names, ages, grades, sells, etc.
• 
• ·         Chose the information you want to make a chart of.
• ·         Go to the option insert
• 
• ·         Chose the chart or graph that will better organize your information
• 
• ·         Enjoy your new chart J