Organizing Information An introduction to organizing information in

  • Slides: 10
Download presentation
Organizing Information An introduction to organizing information in spreadsheet format so Excel can use

Organizing Information An introduction to organizing information in spreadsheet format so Excel can use it. Click to Continue

Organizing Data Into Tables n Here is a multiplication table: 1 2 3 4

Organizing Data Into Tables n Here is a multiplication table: 1 2 3 4 2 4 6 8 3 6 9 12 4 8 12 16 Click to Continue

Organizing Data Into Tables n Note how it has rows 1 2 3 4

Organizing Data Into Tables n Note how it has rows 1 2 3 4 2 4 6 8 3 6 9 12 4 8 12 16 Click to Continue

Organizing Data Into Tables n And Columns: 1 2 3 4 2 4 6

Organizing Data Into Tables n And Columns: 1 2 3 4 2 4 6 8 3 6 9 12 4 8 12 16 Click to Continue

Using Rows and Columns n Identifying positions in a grid: A 1 1 2

Using Rows and Columns n Identifying positions in a grid: A 1 1 2 3 4 Lets call this square ‘A 1’ 4 6 8 6 9 12 8 12 16 Click to Continue

Using Rows and Columns n Identifying positions in a grid: 1 2 A B

Using Rows and Columns n Identifying positions in a grid: 1 2 A B 1 2 3 4 2 4 6 8 3 4 6 8 Lets call this square ‘B 2’ 9 12 12 16 Click to Continue

Using Rows and Columns n We keep labeling rows and cols: A B C

Using Rows and Columns n We keep labeling rows and cols: A B C D 1 2 3 4 2 2 4 6 8 3 3 6 9 12 1 4 4 8 12 16 Click to Continue

Adding our own Titles The data at a particular row and column is called

Adding our own Titles The data at a particular row and column is called a ‘cell’. n We can use some of the cells as titles or ‘Headers’ to indicate what the column represents. n Click for an example n

Adding our own Titles n Column A will be the ‘city’. Column B will

Adding our own Titles n Column A will be the ‘city’. Column B will be the ‘Population’ in that city. A 1 2 3 City B C Population Englewood 26, 203 Lodi 23, 971 4 Bergenfield 26, 247 Click to Continue

Part 4 Finished n Press the ‘Back’ button in your browser to select part

Part 4 Finished n Press the ‘Back’ button in your browser to select part 5. (You might have to press it twice. )