Spreadsheets 1

Please refer to the Syllabus Master Page for an overview of the course.

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:

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:

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