Study Sheet Prior to Test - Word and Excel

I. Microsoft Word
    General
    1. Screen and Toolbars - name of, recognizing tools
    2. Menus - locating functions
    3. Download - Be able to download the practice files.

    Editing
    1. How to Select text
    2. How to cut/copy and paste,
    3. How to find and replace
    4. How do you check spelling and grammar?
    5. What's the clipboard?
    6. Find a synonym for a word
    7. Check spelling and grammar at once

    Formating
    1. Putting text in with different fonts and font sizes
    2. Font effects or styles - Bold, Italics, Underline
    3. Fonts types: Serif (feet - body text), Sans Serif (no feet - headings)
    4. How do you Indent a paragraph of text? (left and right, different types)
    5. Tabs - how to add, remove, types
    6. Alignment - how to (meaning left, center, right, justify)
    7. Page margins - how to set
    8. Font effects (bold, italics, underline) and Font styles
    9. Bullets and Numbering
    10. Using WordArt & inserting Pictures
    11. How to view and change the header or footer
    12. How to insert a page break, column break, or continuous break.
    13. How to format a section with 2 or more columns.

    Tables (only if included in the class):
    1. A cell is the intersection of rows and columns
    2. How to insert a table in a document


II. Microsoft Excel
    1. Parts of the screen - Name Box, Formula Bar, Status Bar, Active Cell
    2. Toolbars - you need to recognize icons
    3. Cell = intersection of row and column
    4. Types of data - labels(text), values(numbers), formulas(computations)
    5. Can do What-if analysis with cell
    6. Workbook can have multiple worksheets (see tabs at bottom of sheet)
    7. How to move around in a worksheet
    8. How to change the name of a worksheet and a workbook
    9. How to print a worksheet with the formulas showing.

    Editing, Formulas and Functions
    1. Entering data in cells
    2. How to edit data in cells
    3. What is a Range - how to select it and write it down.
    4. How to cut and paste (text, numbers, and formulas)
    5. Formulas - how to write
    6. Functions - SUM, AVERAGE, MIN, MAX, PMT, TODAY() - several ways to enter.
    7. Absolute and relative addressing - how to write, how to use in a spreadsheet
    8. How to Insert special data into cells, such as MSN Stock Market Data using the "Import External Data" capability.
    9. Enter a formula using the keyboard
    10. Enter formulas using Point mode

    Formatting
    1. Using different fonts, font sizes for a cell
    2. Formatting for a range of cells or a whole row or column
    3. Inserting and deleting rows and columns
    4. Make cells different background colors, patterns
    5. Make the letters in a cell different colors.
    5. Put a border around a group of cells or the whole page
    6. How to use Spell checker
    7. How to you use "Merge and Center" to center text over columns A through H.
    8. Display and print the formulas version of a worksheet

    Charts:
    1. How to make (and resize to fit) simple charts.
    2. How to print your data and it's chart.

    Other - varies with semester:
    1. Inserting specific functions into worksheet (PMT, SUM, MAX, MIN, IF...)