Numbers - Beginning


Awesome set of Youtube Tutorials
http://www.youtube.com/playlist?list=PL574F7FA47EA5DF41&feature=plcp

Online Resources
http://www.apple.com/iwork/resources/

Print Resources

Get Familiar with the Numbers Window


Numbers_Window.png


  • Sheets - Like chapters in a book, sheets let you divide information into manageable groups. For example, you might want to place charts in the same sheet as the tables whose data they display. Or you may want to place all the tables on one sheet and all the charts on another sheet. The sheets in a spreadsheet and the tables and charts on each sheet are represented in the Sheets pane, located to the left of the canvas above the styles pane.
  • Formula Bar - The Formula Bar, located beneath the Format Bar, lets you create and modify formulas in a selected cell. If you click a selected formula cell, the Formula Editor opens and you can use it to edit your formula instead of using the Formula Bar.
  • Styles - A table style is predefined formatting that you can apply to a table with the click of a mouse.
  • Calculations - In the lower left of the Numbers window, you can view the results of common calculations using values in two or more selected table cells.
  • Table - Tables help you organize, analyze, and present data.
  • Chart - You can turn data that appears in one or more tables into charts. Charts can visually reveal trends or relationships that aren’t as apparent when you view the data in rows and columns.
  • Format Bar - Use the Format Bar, displayed beneath the toolbar, to quickly change the appearance of tables, charts, text, and other elements in your spreadsheet.
  • Inspector - Most elements of your spreadsheet can be formatted using the Numbers inspectors. Each inspector focuses on a different aspect of formatting. For example, the Cells Inspector lets you format cells and cell values.



Tables???

  • Formula Bar
  • Active Cell
  • Resizing Handles
  • Selecting
  • Moving
  • Cell References
    • Change this under Preferences
  • The Inspector
Numbers_table.png


  • Header/Footer Rows
  • Rename Table
Numbers_Header.png


  • Create charts quickly
  • Changing the chart
  • The Inspector
Numbers_Chart.png


  • Cell Control
    • checkbox
    • slider
    • stepper
    • pop-up
Cell_Types.png






Adding Text, Shapes and Other Objects
  • Textbox on the toolbar
  • Click Shapes on the toolbar
  • Use Media for audio, graphic or movie

Practice
  1. Open a "New Spreadsheet" - File Menu, New, Choose Blank Spreadsheet
  2. Adjust the default table to have only columns A-F and rows 1-10
  3. Enter the information from the following table

Apples
Oranges
Grapefruit
Price per box
1.50
2.25
3.75
Sarah
5
3
2
Jake
10
6
7
Mary
3
3
7
Bill
6
5
5
Joe
9
4
1
  1. Adjust the fonts, size, shading, etc. to your liking.
  2. Add the Heading "Total Sales" in cell E1
  3. Add the Heading "Total boxes sold" in cell A8
  4. Add the Heading "Total Sales" in cell A9
  5. Add formulas in Row 8 to calculate the total boxes sold for each type of fruit
  6. Add formulas in Row 9 and Column E to calculate the total sales for each student and each type of fruit
  7. Format for currency where appropriate.
  8. Create a chart showing the sales for each student for each type of fruit.
  9. Rename the table "Fruit Sales."
  10. Rename the chart "Fruit Sales"
  11. Make any other adjustments you would like.


Files