How to Use Numbers Spreadsheets
with Formulas & Charts

1.      Open Numbers by clicking on the  32013_82431_0.jpg icon.

2.      Under Template Chooser click on the  32013_82449_1.png spreadsheet and then click  32013_82504_2.png.

3.      Lets say you want to create a Math Quiz for your class.  You would type Math Quiz on line 2 column B.

4.      Go down to line 5  and type the following:

5.       32013_82615_3.png

6.      Click on row 7 column C and type an = sign.  The following box will appear 32013_82630_4.png .  This is an auto sum box.  The following symbols do the following operations.  (: adds all of the cells together, + adds two cells together, - subtracts two cells, * multiplies two cells, / divides cells.)

7.      Click on the 32013_82654_5.png .

8.      Then highlight the cells you want to multiply together.   
 It will automatically add the cells.  Go to the : and replace it with a *.  This will then multiply the cells.

9.      The finished multiplication problem will look like this:

10.     If you wanted to make an answer key and do multiple multiplication questions you could highlight the cells and copy them.   32013_82826_8.png
Then click 32013_82833_9.pngand click into the cell E4 to paste by clicking  32013_82918_11.png.  

11.     Your copied cells will look like this:
You can now change the numbers inside this cell to lets say 5 times 3 so it looks like this.  You will notice that it automatically correctly recalculated the answer.

12.     Now lets add an addition problem.  Type in the following in the next set of boxes:  

13.     Type in an = sign in box C12 so that your auto sum box appears 32013_83116_15.png .  

14.     Then highlight the cells you want to add up.    32013_83137_16.jpg
The program automatically adds them up.

15.     Now lets add another row as we want to add an additional number.  Click on row 11 so it looks like this  32013_83259_17.png

16.     Go up to the top and click on  32013_83312_18.png

17.     It will now look like this:

18.      32013_83350_19.png

19.     Now type in + in B11 and 9 in C11.

20.     It will now look like this but you will notice that the sum is correct as it added the additional cell in the Total.  

21.     Now double click in C13 and it will look like this:  

22.     Now press return and you will see that your sum is correct.  

23.     Go to B15 and type Subtract and type the following in the cells:  

24.     Go to C18 and type the = sign and highlight C16 and C17 so it looks like this:

25.     Since it automatically adds the cells you will need to replace the : with a – so it looks like this:  

26.     Now when you press return your problem will show the correct subtraction answer.  

27.     Again if you chose to add an additional subtraction number to the problem click on row 17 and    32013_83548_27.png 
32013_83626_28.png  and enter – 2 in Row 17 so it appears as below:  

28.     You will notice that the sum is wrong so you will need to click in C19 to fix it.  Always check the sum formula when you add or subtract a row.  When we check this problem we see that C17 is not highlighted so it is not in the formula. 32013_83757_30.jpg

29.     To add it to the formula just click on it.  When you do this it will automatically add C17 so you will need to go in and change the + to a – next to C17.

30.     When done correctly it will look like this:  
 Make sure you have also deleted the ) so that the formula is correct.

31.     Now press return and you will see that your answer is correct.

32.     Now go to B21 and enter the following:  

33.     Click into C24 and type in an =.  Now highlight C22 and C23 so it looks like this:  

34.     Replace the : with a / so it looks like this:  

35.     Press return and your answer will be correct as shown below:  

36.     Notice your Formula list at the bottom of your page.

37.     C7 show you how to multiply.  

38.     C13 shows you how to add multiple cells.

39.     C19 shows you how to subtract multiple cells.

40.     C24 shows you how to divide two cells.

41.     Now go back and highlight C10-C12 like this:

42.     Look in your lower left corner of your screen.  Number automatically shows the sum, average, min, max, and count.  

43.     Now type the following in these cells starting with cell B26:  

44.     If you click and = sign in C33 it will add up your temps once you highlight C28 through C32.  

45.     Now press return.  It will show the five temps added up.  

46.     Now type the word average in B34 and = in c34.

47.       Because we want the average of the temperatures we will click on c33 then type /5  so it looks like this:  
Then press return.  Your answer will show that your average temperature for the week was 71.

48.     If we wanted to make a chart of these temperatures we could do the following.  Highlight the following fields:  32013_84646_49.png

49.     Then you would click on the  32013_84704_50.png icon.  For this exercise we will click on the first one that looks like this  32013_84714_51.png.

50.     You will notice a chart will now appear below your numbers.  It looks like this:

51.     You can rename Chart 4 to Temperatures this week by clicking on  32013_84813_53.png and typing in 32013_84819_54.png .

52.     If you want to change the colors, click on 32013_84843_55.png  in the Inspector

53.     If I wanted to change the chart from blue to purple,  
I would click on the 32013_85006_58.png  and change it to 32013_85024_59.png as this is a 2D image.  Also change the 32013_85033_60.png  to   32013_85039_61.pngso it looks like this:  

54.     I would then click on the purple 32013_85120_63.png  and  32013_85130_64.png.  This will now make my chart look like this:

55.     You could then click on your chart again so it looks like this:

56.     This will now activate your Inspector so you can click on the Chart Icon 32013_85244_67.png  and try different type charts.

57.     I chose this chart type 32013_85311_68.png  which now made my chart look like

58.     You would then do a file print.  Your chart would normally print on page two.

59.     There are many other charts you could create including pie charts.  

60.     If we wanted to change this to a pie chart we could click on the numbers again 32013_85423_71.png 
and then click on 32013_85440_72.png  under  32013_85447_73.png .

61.     Pie charts are normally based on 100% so the default will go to percentage as shown below:

62.     To change the pieces from percentage to numbers click on  32013_85649_75.png and change it to 32013_85701_76.png  .  

63.     You can then change your title from 32013_85733_77.png to Temperatures this week by just clicking on the word  32013_85733_77.png and Typing in 32013_85750_79.png .

64.     If you click on the pie piece so it has some dots around it like this blue piece does 32013_85822_80.jpg , then you can add the day of the week in the pie piece but clicking on the pie piece and checking the following box in Inspector 32013_85834_81.png .  
Your chart will now look like this:

65.     Now we will do it to each piece so the end result looks like this:


66.     You can rotate your chart by clicking on the  32013_90024_85.png and sliding the rotation to the angle you would like.  This is how I chose to change my angle.

67.     You can also export a Number Spreadsheet to a PDF, an Excel spreadsheet or CSV file.  To do this click on    32013_90102_87.png

68.     The following screen will appear.

69.     For this exercise we will click on 32013_90224_90.png and 32013_90229_91.png .

70.     It will now want you to name the Excel spreadsheet so lets name it as shown and then click  32013_90250_92.png.

71.     You may get the following message which is okay to disregard as you are going to double check the formulas when it converts over to Excel.

72.       32013_90353_94.png

73.     If this box appears just click 32013_90413_95.png and click on the 32013_90419_96.png  to close the window.

74.     You should now see the Numbers Example spreadsheet in Excel.  You will know it  is an Excel spreadsheet because you will see XLS on the icon.  32013_90443_97.jpg