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 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 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 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 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 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 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 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 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 5. (You might have to press it twice. )