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

Header/Footer Rows

Rename Table

Create charts quickly

Changing the chart

The Inspector

Cell Control

checkbox

slider

stepper

pop-up

Adding Text, Shapes and Other Objects

Textbox on the toolbar

Click Shapes on the toolbar

Use Media for audio, graphic or movie

Practice

Open a "New Spreadsheet" - File Menu, New, Choose Blank Spreadsheet

Adjust the default table to have only columns A-F and rows 1-10

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

Adjust the fonts, size, shading, etc. to your liking.

Add the Heading "Total Sales" in cell E1

Add the Heading "Total boxes sold" in cell A8

Add the Heading "Total Sales" in cell A9

Add formulas in Row 8 to calculate the total boxes sold for each type of fruit

Add formulas in Row 9 and Column E to calculate the total sales for each student and each type of fruit

Format for currency where appropriate.

Create a chart showing the sales for each student for each type of fruit.

## Numbers - Beginning

## Get Familiar with the Numbers Window

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???

Adding Text, Shapes and Other ObjectsPracticeFiles