# 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