Friday, January 13, 2012

Using Math Formulas

You can calculate how much you spend and how much you earn by using excel. Excel does calculations just like you would do on a calculater. If you key a formula for an addition symbol (+), a subtraction sign (-), a multiplication symbol(*), and a division symbol(/), Excel will calculate the multiplication first, then division,then addition, and the subtraction.

Skill Builder:
1) First it would be multiplication, then division, then addition, and then subtraction.
2) Th order of precedence is important because if they were not in order, the calculations would mess up.
3) 5-2*3+7-4= 5-6+7-4= 5-13-4= -12

No comments:

Post a Comment