Table of Contents

Introduction

Some Key Terms

Things to Keep in Mind

How to Use This Book

Conventions Used in This Book

I. The Basics

1. Getting Started

Opening the Program

Selecting a Mode

Using the Menus

Using the Toolbars

Understanding Dialog Boxes

Understanding Spreadsheets and Notebooks

Reviewing the Construction of a Spreadsheet

Understanding Spreadsheets and Math

Using Spreadsheets to Create Charts

Getting Help

Using the Help System

Using the CorelTUTOR

PerfectExpert

Corel on the Web

Exiting the Program

2. Working with Windows

Working with Windows

What Size Is the Window?

Minimizing, Maximizing, or Restoring a Window

Resizing a Window

Arranging Windows

Exploring Views

3. Navigating in a Notebook

Selecting Cells

Moving Around in a Spreadsheet

Moving to a Different Spreadsheet

Entering Information

Entering Text and Numbers

Entering Formulas

Filling a Range

Correcting Mistakes

Saving a Notebook

4. Editing in a Spreadsheet

Renaming a Spreadsheet

Moving Information

Copying Information

Inserting and Deleting Rows and Columns

Hiding and Redisplaying Rows and Columns

Locking Row and Column Titles Onscreen

5. More Editing in a Spreadsheet

Working with Ranges

Automatically Filling a Range with Numbers

Naming a Range

Finding and Replacing Information

Checking Spelling

Using QuickCorrect

A Word About the Quattro Pro Experts

II. The Intermediate Stuff

6. Printing

Setting Up the Spreadsheet for Printing

Selecting a Paper Type

Including a Header or Footer

Printing Headings

Printing Row/Column Borders

Setting Print Margins

Centering a Printout on the Page

Scaling the Printout

Positioning Page Breaks

Printing Cell Contents

Printing Gridlines

Saving Print Settings

Printing All or Part of a Notebook

7. Managing Notebooks

Closing a Notebook

Creating a New Notebook

Without a Template

With a Template

Opening an Existing Notebook

Opening an Excel or Lotus 1-2-3 File

Saving an Excel or Lotus 1-2-3 File

Rearranging Spreadsheets

Inserting and Deleting Spreadsheets

Grouping Spreadsheets

Linking Notebooks

8. Formatting Notebooks

Using SpeedFormatting

Aligning Information

Joining Cells

Applying Numeric Formatting to Cells

Setting Row Height and Column Width

Swapping Rows and Columns

9. More Notebook Formatting

Changing Fonts

Using Color

Changing Text Color

Applying Color to Cell Backgrounds

Coloring Cells That Meet Certain Criteria

Adding Borders to Cells

Hiding and Displaying Gridlines

Underlining Totals

Copying Cell Formatting

10. Working with Calculations

Calculating Within Cells

Using Numbers

Using Cell References

Understanding the Order of Calculation Operations

Creating Mathematical Calculations

On Your Own

Using Quick Math

A Shortcut to Commonly Used Functions

Copying Formulas and Functions

III. The Advanced Stuff

11. Graphing Data

Understanding Chart Types

Creating a Chart

Creating a Chart Using the Chart Expert

Drawing a Chart

Formatting a Chart

Printing a Chart

Modifying Chart Information

12. Setting Up a Database in Quattro Pro

Understanding Databases, Fields, and Records

A Word of Caution Concerning Spreadsheet Databases

Adding Information to a Spreadsheet Database

Adding Records Manually

Using a Data Form to Add Records

Navigating and Editing in a Notebook Database

Searching a Database Using a Data Form Window

Creating Database Queries

Creating a Criteria Table

Creating the Search Output Range

Setting Up Queries

Creating CrossTab Reports

13. Analyzing Data

Sorting Data

Filtering Information

Transposing Rows and Columns

Creating What-If Tables

Consolidating Data

14. More Data Analysis

Preparing an Amortization Schedule

Auditing Spreadsheet Formulas

Solving for a Variable

Creating a Frequency Distribution

15. Customizing Menus and Toolbars

Customizing Toolbars

Hiding and Showing Toolbars

Changing the Appearance of a Toolbar

Adding or Removing Toolbar Buttons

Creating Your Own Toolbar

Customizing Menus

Adding, Deleting, and Rearranging Commands

Adding or Changing Shortcut Keys

16. Customizing Quattro Pro

Using Workspaces

Switching Between Predefined Workspaces

Creating a Workspace

Controlling Quattro Pro’s Behavior

Controlling Mathematical Formula Entry

Setting Folder Locations

Glossary

Index