Corel wordperfect office 2002 Manuel D’Utilisation
Creating a spreadsheet
3
Quattro Pro contains spreadsheets in a notebook. Once you have created a spreadsheet, you can
enter data and perform calculations. For example, you can enter a list of items and the cost of
each item and then calculate the total cost of all items.
In this section, you’ll learn about
In this section, you’ll learn about
creating and opening notebooks
entering labels and special characters
entering values
filling cells and spreadsheet tabs automatically
creating simple equations
performing running calculations
Creating and opening notebooks
When you start a new spreadsheet in Quattro Pro, you must first create a notebook. You can
create a notebook from a list of project templates or from the default template. Project
templates prompt you for data and then format and calculate it automatically. When you create a
notebook from the default template, you must format the data yourself and perform your own
calculations.
A Quattro Pro spreadsheet consists of 1,000,000 rows and 18,000 columns. Each notebook
A Quattro Pro spreadsheet consists of 1,000,000 rows and 18,000 columns. Each notebook
contains 18,000 spreadsheets. If a project does not require such a large range, you can change
the size of the notebook. Limiting the size of a notebook makes the scroll bars more useful and
protects you from writing data out of range.
You can also open a notebook or customize the start options to automatically open a specific
You can also open a notebook or customize the start options to automatically open a specific
notebook every time you start Quattro Pro.
To create a notebook
Click File } New.
Creating a spreadsheet
181