How to Use Numbers Spreadsheets
with Formulas & Charts

1.      Open Numbers by clicking on the icon.

2.      Under Template Chooser click on the spreadsheet and then click .

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. 6.      Click on row 7 column C and type an = sign.  The following box will appear .  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 .

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. Then click and click into the cell E4 to paste by clicking .

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 .

14.     Then highlight the cells you want to add up. 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 16.     Go up to the top and click on 17.     It will now look like this:

18. 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  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. 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: 49.     Then you would click on the icon.  For this exercise we will click on the first one that looks like this .

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 and typing in .

52.     If you want to change the colors, click on in the Inspector 53.     If I wanted to change the chart from blue to purple, I would click on the and change it to as this is a 2D image.  Also change the to so it looks like this: 54.     I would then click on the purple and .  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 and try different type charts.

57.     I chose this chart type 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 and then click on under .

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 and change it to .

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

64.     If you click on the pie piece so it has some dots around it like this blue piece does , 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 .
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 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 68.     The following screen will appear. 69.     For this exercise we will click on and .

70.     It will now want you to name the Excel spreadsheet so lets name it as shown and then click . 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. 73.     If this box appears just click and click on the 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. 