Microsoft Works 2000: Formulas and Formatting


Microsoft Works 2000: Formulas and Formatting

General Information

Course Duration:
1 hour

Audience:
End-users

Prerequisites:
The SmartCourse Microsoft Works 2000: Getting Started

Topics Covered

  • Subtracting
  • Multiplying
  • Dividing
  • Averaging
  • Choosing a function
  • Calculating compounding terms
  • Inserting and deleting rows and columns
  • Formatting numbers, fonts, and alignment
  • Borders and shading
  • AutoFormat, locking, and protection
  • Using the View menu
  • Setting the print area
  • Freezing titles
  • Setting row height and column width

Course Aim

To teach how to use formulas and how to format a spreadsheet in Microsoft Works 2000

Learning Objectives

After taking this course, the student should be able to

  • use the Easy Calc feature to subtract, multiply, divide, and average

  • choose an appropriate function

  • calculate compounding terms

  • insert and delete rows and columns

  • format numbers, fonts, and alignment

  • apply borders and shading

  • use AutoFormat, locking, and protection

  • use the View menu, and set the print area

  • freeze titles

  • alter the row height and column width



Course Incorporates: Not applicable