How to Use Excel Spreadsheets

with Formulas and Charts

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.

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.

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 .

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

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:

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:

Now press the enter/return key. This will give you a total of 100 in B32.

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:

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:

34. The following box will then appear:

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

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

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.

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.

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.