ࡱ> fheq` bjbjqPqP 8T:: VVVVVVV33333944444444n9p9p9p9p9p9p9$:h =9V444449VV4495554 V4V4n954n955VV544 PH%34R5j59095=4=55=V2584454444499544494444d00jD,VVVVVV Using AutoSum and Creating Formulas Using AutoSum The AutoSum button looks like this:  When you click on the AutoSum button, Excel tries to highlight any column above it with the marching ants, the blinking dashes that surround something highlighted. In the formula bar, Excel will insert a formula that looks something like this: =SUM(A1:A10) The two cell references (in this example, A1 and A10) with the colon between it is called a range. A range represents all of the cells between the first cell reference (A1) and the last cell reference (A10). In the example above, cells A1, A2, A3, A4, A5, A6, A7, A8, A9, and A10 would be selected to be summed. Quick Tip: You dont have to use the AutoSum button to use the SUM( ) function. You can type =SUM(Cell1:Cell2) and it will work just the same. How to Create Formulas in Excel To create a formula in Excel, ALWAYS start with an = sign. Then, click on the cell you want to include in your calculation. After that, you can put whatever mathematical operator you want, then click on another cell. All of the following examples involve Cell A1 and Cell B1. Addition Example (+): =A1 + B1 Subtraction Example (-): =A1 - B1 Multiplication Example (*): =A1 * B1 Division Example (/): =A1 / B1 Adding and Subtracting in the Same Formula: =A1 + B1 - C1 Adding and Subtracting and Multiplying in the Same Formula: =A1 + B1 - C1 * D1 Order of Operations Just like in Math class, Excel will do certain operations first from left to right. Use this acronym to help you remember which operations Excel will do first from left to right: Please Excuse My Dear Aunt Sallie Parenthesis Exponents Multiplication Division Addition Subtraction. What does all this mean? Lets look at a few examples: 5 + 2 * 6 = 17 Why does this equal 17? Because we start from left to right and find the mathematical operator that gets taken care of first. In this example, the multiplication symbol takes precedence. 2 * 6 = 12 Now that the multiplication is taken care of, we can rewrite our problem substituting what we got from the multiplication into the rest of the problem: 5 + 12 = 17 Now, consider this: (5 + 2) * 6 = 42 Its the same as above except we have added parenthesis. We know that whats in parenthesis gets taken care of first, so: (5 + 2) = 7 7 * 6 = 42 See how adding a set of parenthesis can make a world of difference! Directions: First, see if you can figure out what each of the following formulas is going to equal. Remember to use the order of operations to try to get the answers. Then, put the formula into Excel and see if you got the right answer: FormulaWhat you think it will equalWhat Excel says it equalsWere you right? Yes / NoIf you were wrong, why?=5+7*2 =(5+7)*2 =15/3+2 =15/(3+2) =5-2*2 =(5-2)*2 =7*3+5 =7*(3+5) =15/5-2 =15/(5-2) =12/3+1 =12/(3+1) =30/5+1 =30/(5+1) =18/6-3 =18/(6-3) =50/10-5 =50/(10-5) =24/6-3 =24/(6-3)  #$VW  & , % & \ l p q u v w x {             [ \ ] _ ` a b d e f ˿˿˿hfhUg5 hUg5hUghfhf5hBq h>5 hf5hfhf6h0+h0+6jh0+Uh0+ hfhfhfF$2XYP ] & F [ \ r { | $a$gdfgdfgdf$a$gd0+gd0+gd0+$a$gdf   \ p q 9:\]isgd>gd>$a$gdUggdUg$a$gdfgdff g i j k l p q JZ[fJ%&56DEUVdeuv h9&h9&h9&CJaJh9&CJOJQJ^JaJ h9&5h9& h>6h>hfhUghBq=LMYZno  ZIJRp$If $Ifgd9&gd>F=7777$If $Ifgd9&kd*$$IflrsA$&hfcX0 %644 la_p @7 $Ifgd9&kd$$IflrsA$&hfcX0 %644 la_p $If@7 $Ifgd9&kd $$IflrsA$&hfcX0 %644 la_p $If@kd$$IflrsA$&hfcX0 %644 la_p $If$If $Ifgd9&F=7777$If $Ifgd9&kd$$IflrsA$&hfcX0 %644 la_p @7 $Ifgd9&kd$$IflrsA$&hfcX0 %644 la_p $If@7 $Ifgd9&kd$$IflrsA$&hfcX0 %644 la_p $If !"#$%&@kd$$IflrsA$&hfcX0 %644 la_p $If&/012345$If $Ifgd9&56>?@ABF=7777$If $Ifgd9&kd $$IflrsA$&hfcX0 %644 la_p BCDEOPQ@7 $Ifgd9&kd $$IflrsA$&hfcX0 %644 la_p $IfQRSTUV^@7 $Ifgd9&kd $$IflrsA$&hfcX0 %644 la_p $If^_`abcde@kdz $$IflrsA$&hfcX0 %644 la_p $Ifeopqrstu$If $Ifgd9&uv~F=7777$If $Ifgd9&kdj $$IflrsA$&hfcX0 %644 la_p @7 $Ifgd9&kdZ$$IflrsA$&hfcX0 %644 la_p $If@7 $Ifgd9&kdJ$$IflrsA$&hfcX0 %644 la_p $If@kd:$$IflrsA$&hfcX0 %644 la_p $If$If $Ifgd9&F=7777$If $Ifgd9&kd*$$IflrsA$&hfcX0 %644 la_p @7 $Ifgd9&kd$$IflrsA$&hfcX0 %644 la_p $If@7 $Ifgd9&kd $$IflrsA$&hfcX0 %644 la_p $If@kd$$IflrsA$&hfcX0 %644 la_p $If$If $Ifgd9&FAgd>kd$$IflrsA$&hfcX0 %644 la_p 6&P1h:p/ =!"#$% *Dd;L  C (AautosumbOɣX @afDn^OɣX @aPNG  IHDR$`PLTE»ľĿqi=bKGDH cmPPJCmp0712HsIDAT8O0 PvMg'/+ؒ w!iO^x `Z1NQ"%|j?q] &MO!wmb7{${sCY8 p*Q/7 -IENDB`$$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p $$If_!vh55h5f5c5X#v#vh#vf#vc#vX:V l0 %6,55h5f5c5X9a_p @@@ NormalCJ_HaJmH sH tH \@\ f Heading 2$<@& 56CJOJQJ\]^JaJV@V 0+ Heading 3$<@&5CJOJQJ\^JaJDA@D Default Paragraph FontRi@R  Table Normal4 l4a (k@(No List T!z z z zr[ $2XYP]&F[\r{| \pq9:\]isLMYZno   I J R p                  ! " # $ % & / 0 1 2 3 4 5 6 > ? @ A B C D E O P Q R S T U V ^ _ ` a b c d e o p q r s t u v ~  $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$v:v:v:v:v:v:tv:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`v:v:v:v:v:v:v:`$$2XYP]&F[\r{| \pq9:\]isLMYZno   Z I J R p                  ! " # $ % & / 0 1 2 3 4 5 6 > ? @ A B C D E O P Q R S T U V ^ _ ` a b c d e o p q r s t u v ~  0(00$0$0$0$0$0$0$(00&0&0&00&0&00&0&00&0&00&0&00000(00000000000000000000000000000000000000 0 0 00 0 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0 0 0 0 000 0 0    / > O ^ o ~ K0K0K0K0K0K0 K0 K0K0K0K0K0K0K0K0K0K0 K0"K0$K0& 0f   &5BQ^eu  !"#$%&'() QUjo ::::::f  M-lBq>9&=f0+UgJ R p              ! " % & / 0 1 2 5 6 > ? @ A D E O P Q R U V ^ _ ` a d e o p q r u v ~  @  s `@UnknownGz Times New Roman5Symbol3& z Arial"hLfXMfk0 0 a!924 3HX ?0+2#Using AutoSum and Creating FormulasJerry T. SmithJerry T. SmithOh+'0 ,8 X d p|$Using AutoSum and Creating FormulasJerry T. Smith Normal.dotJerry T. Smith4Microsoft Office Word@B@rE %@8%0 ՜.+,0  hp|    $Using AutoSum and Creating Formulas Title  !"#$%&'()*,-./012345789:;<=>?@ABCDEFGHIJKLMNOPQRSTVWXYZ[\^_`abcdgRoot Entry F.H%iData +1Table6=WordDocument8TSummaryInformation(UDocumentSummaryInformation8]CompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q