Guide to Spreadsheet Operations

Most spreadsheets operate in basically the same way: you enter data into a cell in an array of cells, then perform calculations with groups of cells by entering formulas that use the data you've entered.

1. Parts of a typical spreadsheet
2. Selecting cells
3. Entering data
   1. Numerical data
   2. Text data
4. Formulas (Calculations)
5. Functions
6. Copying and Pasting
7. Cell references
   1. Standard (variable)
   2. Fixed
   3. Labeled
8. Formatting cells
9. Sorting
10. Designing the spreadsheet
11. Exporting data

1. Graphing and charting
2. Printing the document

Department of Geography San Jose State University 118 Washington Square Hall One Washington Square San Jose, CA 95192-0116 Telephone: 408-924-5475 Fax: 408-924-5477 http://www.sjsu.edu/depts/geography