Lab Test 1 Review Guide

Review your material in your Office 2000 book, Labs 6 through 8. Test 1 Topics.

Format of the Lab Test
  • The first 50 minutes of lab.
  • Open book, open notes.
  • Have a formatted labeled diskette
  • Include your name, section #, lab instructor and label: Lab Test 1
    • Examples of Spreadsheet Topics on Lab Test 1 Spreadsheet
  • Retrieving a spreadsheet from a network drive.
  • Editing or entering information into spreadsheet cells
  • Entering formulas (using values, functions)
  • Add a column, add a row
  • Add a title(s) (text)
  • Merging cells
  • Formatting spreadsheet cells (bold, autoformat,font size)
  • Changing the background of a cell, adding borders
  • Entering a spreadsheet function to sum up a range, find the max, min
  • Use the NOW funtion
  • Rotate text in cell
  • Copying spreadsheet function/formulas
  • Working with 2 worksheets.
  • Making a graph from spreadsheet cells
  • Saving the changed spreadsheet on your test diskette