How to Use Excel Spreadsheets
with Formulas and Charts

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

2.      Type the following into the following cells: 3.      Now to get it to multiply click into B6 and click the AutoSum button in your toolbar. This 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.
It will calculate like this once you press the enter/return key. 4.      If you want to copy this equation as a template for another one.  Highlight the cells and click .
Now click into cell d3 and click .

5.      You will see that you just copied your first example. 6.      You can now change your equation to 5 x 3 and you will notice it will automatically correctly total the new equation. 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. 8.      Now that this is done you can paste another equation in G3 just like you did in steps 71 and 72. 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. If I click on E6 and click and then click into B6 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. 11.     To double check your formula in B6 just double click on it and it will show you its current formula. Now click the enter/return key.

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

13.     Now click on B11 and click the AutoSum button in your toolbar. 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 .  Now click .
Now in cell A10 type and in B10 type 9.
Notice that it automatically added the new row in. If you check the formula it will look like this: 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. Then go to your toolbar and click into the Border box
Click on the and the finished equation will look like this. I could then do it for my other equations so my page might look like this: 16.     Now click into cell A14 and type the following: 17.     Click in B18 and click the AutoSum button in your toolbar.  The equation will look like this .  Replace the : with – so your formula looks like this: 18.     Now click in cell B16 to include it in the formula.  It will now look like this: 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: Now press the enter/return key.

19.     Your finished equation will look like this: 20.     Now go to cell A20 and type the following: 21.     Go to cell B23 and click the AutoSum button in your toolbar.  The equation will look like this
Replace the : with a / and it will change the formula to division.  It will look like this: Now press the enter/return key.

22.     Your finished equation will look like this: 23.     Go to A25 and enter the following information: 24.     Go to cell B32 and click the AutoSum button in your toolbar.  The equation will look like this: 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 The equation will look like this: 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: 27.     Now press the enter/return key.

28.     We can see the average temperature is 20 for this week. 29.     Now lets make a temperature chart.  Highlight the following cells: 30.     Click .  Click and .

31.     The following chart will now appear 32.     If you want to change the blue color to purple.  Double click on the column so it looks like this:

33. 34.     The following box will then appear:

35. 36.     Click on the and select purple then click .

37.     You will now notice that your chart looks like this: 38.     If you want to show your label values click on the chart and in the chart box
click Show Value 39.     Then click .

40.     Your chart will now have values and look like this: 41.     If I want to change it to a pie chart, I would click and .
You will notice that my entire chart is purple. 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. 44.     Click on and change it to red and then click .  My first piece will look like this: 45.      Now I will select colors for the other pieces so my finished chart will look like this: 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: 47.     Then when the Format Data Point box appeared I would click Label and Show category name and percent. .   Then I would click .

48.     It would then look like this: 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.