How to Use Excel Spreadsheets
with Formulas and Charts


1.      Click on your 32013_91130_0.jpg  icon to open up a blank Excel Spreadsheet.

2.      Type the following into the following cells:
32013_91138_1.png

3.      Now to get it to multiply click into B6 and click the AutoSum 32013_91209_2.png button in your toolbar.    32013_91233_3.pngThis will now show the cells that the AutoSum is calculating.  
Notice that there is a : between B4 & B5.  We know we need to change this to an * so it will multiply as the default : adds it.  To change it click on the : between B4 and B5 and change it to a *.  
It will look like this when done correctly.  
32013_91301_5.png  
It will calculate like this once you press the enter/return key.
32013_91311_6.png

4.      If you want to copy this equation as a template for another one.  Highlight the cells   32013_91340_7.pngand click 32013_91346_8.png .  
Now click into cell d3 and click 32013_91411_9.png .

5.      You will see that you just copied your first example.
32013_91438_10.png
6.      You can now change your equation to 5 x 3 and you will notice it will automatically correctly total the new equation.
32013_91453_11.png

7.      If you want to change the column width of column C so you can fit more on a page just click the line to the right of Column C until you have a double arrow.  You can then just drag the column to the left.  You can do the same with Column F so you can fit three equations across.
32013_91517_12.png

8.      Now that this is done you can paste another equation in G3 just like you did in steps 71 and 72.
32013_91612_13.png
 
9.      Once you have your document created you could save the first sheet as the answer sheet and another one the student test but just deleting the formula from each of the answer cells.  To do this deletion just click in the answer cell and press the space bar.  

10.     What if you have an equation that you deleted the formula from and want to quickly add it.  You could copy the answer from another similar equation.  Notice that E6 has the answer formula but B6 doesn’t.
32013_91717_14.png
 If I click on E6 and click32013_92106_15.png  and then click into B6 32013_92120_16.png   it will put the right formula and answer in as it just copied the formula.   You will also notice that there are dancing dots around the cell that you are copying.
32013_92137_17.png
11.     To double check your formula in B6 just double click on it and it will show you its current formula.    
32013_92203_18.png
Now click the enter/return key.

12.     Now go to cell A8 and type the following:
32013_92225_19.png
  I normally put the + in () so it doesn’t try to guess your AutoSum.

13.     Now click on B11 and click the AutoSum32013_91209_2.png button in your toolbar.
32013_92319_22.png
   This will now show the cells that the AutoSum is calculating.  Notice that there is a : between B9 & B10.  The : symbol adds all cells in this range.  You could also put a + in there instead but it automatically defaults to the : to add it up.  Now press the enter/return key.

14.     Now lets add a row as we want to add up one more number.  Click on row 10 so that it will highlight the row 32013_92342_23.png .  Now click 32013_92410_24.png .  
Now in cell A10 type  32013_92419_25.png and in B10 type 9.  
Notice that it automatically added the new row in.
32013_92430_26.png
   If you check the formula it will look like this:
32013_92512_27.png
This shows that is includes the new row.

15.     You could also border your equations to make them easier to see when you print.  To do this highlight the cells you want to border.   
32013_92625_28.png
 Then go to your toolbar and click into the Border box
32013_92631_29.png .  
Click on the  32013_92719_34.png  and the finished equation will look like this.    
32013_92724_35.png
I could then do it for my other equations so my page might look like this:
32013_92731_36.png
16.     Now click into cell A14 and type the following:  
32013_92750_37.png

17.     Click in B18 and click the AutoSum  32013_91209_2.png button in your toolbar.  The equation will look like this 32013_92822_39.png .  Replace the : with – so your formula looks like this:  
32013_92830_40.png

18.     Now click in cell B16 to include it in the formula.  It will now look like this:   
32013_92923_41.jpg
Because it didn’t put the – between B16 and B17 you will need to do that.  Click inside the formula and put the – symbol there.  When it is done it will look like this:
32013_92939_42.png
Now press the enter/return key.

19.     Your finished equation will look like this:  
32013_93006_43.png

20.     Now go to cell A20 and type the following:
32013_93023_44.png

21.     Go to cell B23 and click the AutoSum  32013_91209_2.png button in your toolbar.  The equation will look like this  
32013_93445_46.png.  
Replace the : with a / and it will change the formula to division.  It will look like this:    
32013_93457_47.jpg
Now press the enter/return key.

22.     Your finished equation will look like this:
32013_93516_48.png

23.     Go to A25 and enter the following information:
32013_93530_49.jpg

24.     Go to cell B32 and click the AutoSum 32013_91209_2.png button in your toolbar.  The equation will look like this:   
32013_93600_51.png
Now press the enter/return key.  This will give you a total of 100 in B32.

25.     Click into B33 to find the Average and click the AutoSum  32013_100209_0.png
32013_100244_1.png  button in your toolbar.  
The equation will look like this:    
32013_100310_2.png

26.     Because we want don’t want B32 in the average because it is the total we will change B32 to B31 like shown below:   
32013_100414_3.png

27.     Now press the enter/return key.

28.     We can see the average temperature is 20 for this week.  
32013_100445_4.jpg

29.     Now lets make a temperature chart.  Highlight the following cells:
32013_100501_5.png

30.     Click 32013_100531_6.png .  Click  32013_100548_7.png and 32013_100557_8.png .

31.     The following chart will now appear
32013_100607_9.png

32.     If you want to change the blue color to purple.  Double click on the column so it looks like this:  

33.      32013_100820_10.png
34.     The following box will then appear:

35.      32013_100837_11.png

36.     Click on the  32013_100940_13.png and select purple   32013_100948_14.pngthen click 32013_100953_15.png .

37.     You will now notice that your chart looks like this:
32013_101022_16.png

 
38.     If you want to show your label values click on the chart and in the chart box
32013_101120_21.png 
click Show Value
32013_101140_22.png
39.     Then click  32013_101151_23.png.

40.     Your chart will now have values and look like this:
32013_101217_24.png

41.     If I want to change it to a pie chart, I would click 32013_101247_25.png  and  32013_101252_26.png.  
You will notice that my entire chart is purple.
32013_101316_27.png

 
42.     To fix this I will double click on the circle and under my Format Data Point click on Fill.  Now I will change the color to red.

43.      32013_101414_28.png

44.     Click on 32013_101431_29.png  and change it to red
32013_101444_30.png
and then click32013_101517_31.png.  My first piece will look like this:
32013_101534_34.png

45.      Now I will select colors for the other pieces so my finished chart will look like this:  
32013_101610_35.png

46.     If I want to change my label show the day and percentage to each piece of the pie I would double click on one of the pieces so it would look like this:
32013_101630_36.png

47.     Then when the Format Data Point box appeared I would click Label and Show category name and percent.   
32013_101706_37.png
.   Then I would click 32013_101731_38.png .  

48.     It would then look like this:
32013_101741_39.png

49.     Because you are showing the temperature for that day I don’t think this would be a good option for this particular chart but this is an example of what you could do with any given pie chart.