SSOutline

Spreadsheet Outline

I. Spreadsheet
A. Definition
    1. Program that allows you to use rows and columns of data to
        manage, predict, and present numerical information
B. Parts of a Spreadsheet
    1. Row - horizontal, labeled by numbers
    2. Column - vertical, labeled by letters
    3. Cell - the intersection of a column and a row (column letter and
        row number)
C. 3 Types of Data
    1. Label - text, symbols, dates, or numbers (NOT used in
        calculations)
    2. Value - numbers that are used in calculations
    3. Formula - mathematical equation, starts with an =
        (example: =A3+B3)
        a. Functions - a shortcut formula, examples: SUM, AVG
D. Advantages of Spreadsheets
    1. Organizes large amounts of numerical information
    2. Connects numbers to other numbers
    3. Calculates mathematical equations (formulas)
    4. Provides large amounts of space for storage of numbers and
        calculations
    5. Can automate data entry
    6. Recalculates without having to re-input data
    7. Has built-in error-checking functions
    8. Allows for �what-if� questions so that you can see the effect of
        decisions before making them
    9. Prints reports in various formats
    10. Makes simple graphs from data contained in the spreadsheet
E. Terms
    1. Cell Address - the location of the cell (column letter and
        row number)
    2. Range - a defined block of cells that are touching
    3. Active Cell or Selected Cell - the cell that you are currently clicked
        on or working on
    4. Status Line or Formula Line - shows what is really in the cell,
        displays the formula
    5. Grid Lines - the lines that separate the columns and rows, do not
        always have to be showing.