Spreadsheet+Lesson1

toc 1. Open Excel 2. Save your spreadsheet ⁃ Name the file TypingScores ⁃ Save the file in the .xls file format (97-2004 file format) ⁃ Save the file to your desktop 3. Type in a column with the test labels 4. Enter the typing scores 5. Find the weekly average of your typing scores 6. Find the average of the first five test (1-5) 7. Find the average of the second five test (6-10) 8. Find the average of the last five test (11-15) 9. Label the average values in column A 10. Resize column A to fit the text 11. Format the cells with the average values to two decimal places 12. Add a row 13. Enter your name and the words "Typing Scores" (Example Michael Yackel Typing Scores) ⁃ Change the font size of this cell to 20 ⁃ Bold the font in this cell ⁃ Merge cell A1 and A2 ⁃ Wrap the text in the merged cells 14. Resize the row to fit you text 15. Save the file again 16. Upload the file to you digital locker in Gaggle 17. Delete the file from your desktop





Saving your work
2. Save your spreadsheet ⁃ Name the file TypingScores ⁃ Save the file in the .xls file format (97-2004 file format) ⁃ Save the file to your desktop



File Format


3. Type in a column with the test labels

Auto Fill


4. Enter the typing scores. Today just use the scores posted here.

Calculating an Average
5. Find the weekly average of your typing scores



Entering a formula
6. Find the average of the first five test (1-5) 7. Find the average of the second five test (6-10) 8. Find the average of the last five test (11-15)



Automatically Re-size a Column
9. Label the average values in column A 10. Re-size column A to fit the text

Formatting Cells Type
11. Format the cells with the average values to two decimal places







Inserting a row
12. Add a row



13. Enter your name and the words "Typing Scores" (Example Michael Yackel Typing Scores) ⁃ Change the font size of this cell to 20 ⁃ Bold the font in this cell ⁃ Merge cell A1 and A2 ⁃ Wrap the text in the merged cells

The Toolbox




Manually Re-sizing Rows
14. Resize the row to fit you text

15. Save the file again

16. Upload the file to you digital locker in Gaggle

Uploading a file to Gaggle




Cleaning up your desktop
17. Delete the file from your desktop