Site MapHelpFeedbackLab 5: Using Data Tables, Creating Macros, and Designing Onscreen Forms
Lab 5: Using Data Tables, Creating Macros, and Designing Onscreen Forms


By the end of this lab students should know how to:

  • Use the PMT function
  • Research information on the Web
  • Create a data table
  • Create and modify shapes
  • Use Lookup functions
  • Create a form
  • Name cell references
  • Use the IF function
  • Create a drop-down list
  • Add cell comments
  • Hide and unhide rows
  • Prepare a workbook for distribution.










Microsoft Office 2007 SeriesOnline Learning Center

Home > Excel > Lab 5: Using Data Tables, Crea