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.   
32013_82726_6.jpg
 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:
32013_82802_7.png

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:
32013_83011_12.png
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.
32013_83037_13.png

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

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.  
32013_83405_20.png

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

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

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

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

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

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

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:  
32013_83646_29.png

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.
32013_83812_31.png

30.     When done correctly it will look like this:  
32013_83836_32.png
 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.
32013_83849_33.png

32.     Now go to B21 and enter the following:  
32013_84027_36.png

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

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

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

36.     Notice your Formula list at the bottom of your page.
32013_84132_40.png

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:
32013_84201_41.png

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

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

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

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

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

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

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:
32013_84743_52.png

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
32013_84854_56.png

53.     If I wanted to change the chart from blue to purple,  
32013_84929_57.png
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:  
32013_85047_62.png

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:
32013_85145_65.png

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

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
32013_85318_69.png

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

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:
32013_85555_74.png

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:
32013_85857_83.png

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

32013_85953_84.png

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.
32013_90034_86.png

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.
32013_90134_88.png

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.
32013_90256_93.jpg

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