Spreadsheets 1

For this lesson, it may be helpful to have an example ledger page, grading sheet, etc.

Goals

Students will learn rudimentary spreadsheet skills. Students will be able to:

• Explain the concept and advantages of spreadsheets.
• Describe a cell and a reference.
• Describe a formula and give 2 examples.

Formulas

References

Absolute

Relative

Key Navigation: Enter, Tab

Formatting

Re-sizing columns

Note that if column is too small to display number, "####" will display instead.

Goals

Students will learn additional spreadsheet skills. Students will be able to:

• Sort data by different columns.
• Generate graphs from data.
• Set the print area, and fit to a page.

Data/Sorting

Graphs & Charts

Useful Formulas

Offest References

IF, Nested IF (e.g. letter grade)

Hide/Show Columns

Set Print Area

Fit to Page Printing

Conditional Formatting

Please send feedback to: alingelb at yahoo dot com
URL: http://www.redoubt.com/tzict/textbook/spreadsheets01.html
Version: 0.06