Using Formulas and Functions in Excel 2010www.ptraining.com

Formulas•Start with an equals sign (=)•Operators Operation Symbol

Addition +Subtractions -Multiplication *Division /Exponent ^

The Order of OperationsWhat is the right answer?

=2+3*4=2+3*4 = 2 + 12 = 14

ParenthesesExponentMultiplicationDivisionAdditionSubtraction

PleaseExcuseMyDearAuntSally

Functions• Specialized formulas

=keyword (arguments)=how-to-calculate (what-to-calculate)

• Examples:=SUM(D2:D9)=AVERAGE(A10:A40)=PMT(interest,term,amount)

Formula ProblemThe formula for converting Fahrenheit to Centigrade is:

Centigrade = (Fahrenheit-32) * 5/9Set up your spreadsheet to convert any Fahrenheit temperature to Centigrade.Hint:

Fahrenheit

Centigrade

212 Formula here

Centigrade to Fahrenheit Fahrenheit = C*9/5+32