Quattro Pro: Introduction (Day 1 of 2)

Performance Based Objectives

  • Understand the basics of the Quattro Pro environment; create a basic spreadsheet by entering text, values, and formulas.

  • Modify a spreadsheet; use Quattro Pros built-in functions.

  • Copy and move spreadsheet data by using drag-and-drop editing, toolbar buttons, and menus.

  • Change the appearance of spreadsheet data by using a variety of formatting techniques.

  • Correct a spreadsheet by using absolute addresses, correcting circular references, and using the Spell Checker.

  • Prepare a spreadsheet for printing by previewing it and specifying page settings.

  • Use notebooks to create three-dimensional formatting and formulas.

Course Content
Lesson 1: Creating a Basic Spreadsheet
  • The Spreadsheet Environment
  • Using Formulas
  • Observing Automatic Recalculation

Lesson 2: Modifying a Spreadsheet

  • Navigating in a Spreadsheet
  • Working with Functions
  • Working with Titles

Lesson 3: Moving and Copying Data

  • Inserting Rows and Blocks
  • Moving Data
  • Copying Data
  • Using QuickFill

Lesson 4: Formatting a Spreadsheet

  • Formatting Cell Contents
  • Changing Number Formats and Aligning Text
  • Formatting a Spreadsheet
 Lesson 5: Correcting a Spreadsheet
  • Using Absolute Reference
  • Eliminating Circular Reference
  • Spell Checking a Spreadsheet

Lesson 6: Printing a Spreadsheet

  • Using Print Preview
  • Selecting Page Setup Options
  • Print Options

Lesson 7: Introduction to Notebooks

  • Navigating in a Notebook
  • Working with Notebooks
this document.

Toll Free 877.NOVATECH (668.2832)