Using preset calculations

Quattro Pro lets you perform calculations quickly by using preset calculations. You can also total cells in rows or columns. For example, you can calculate totals in a single row, or multiple rows or columns. The row or column cannot contain blank cells, and any labels in the selected cells are treated as zero values.

You can also total all cells on multiple spreadsheets and total the subtotals in a column.

Calc As-You-Go lets you display several different running totals for cells you select; the sum, average, count, maximum value, and minimum value display on the application bar. You can disable Calc As-You-Go.

Wordperfect Quattro Pro glance Using preset calculations

This is an example of the application bar displaying different running totals.


To perform preset calculations

Wordperfect Quattro Pro btnbacktotopproc Using preset calculations
1.
 
Type values across a row or down a column.
2.
 
Click the first blank cell after the values.
3.
 
Open the QuickFunction flyout on the Notebook toolbar, and click a function.

Wordperfect Quattro Pro pgx quickfunction Using preset calculations

Wordperfect Quattro Pro note Using preset calculations

•
 
The icon on the flyout varies depending on which calculation you select.

To total cells

Wordperfect Quattro Pro btnbacktotopproc Using preset calculations

To total
Do the following
Cells in a row
Select the cells and one blank cell to the right, and click the QuickSum Wordperfect Quattro Pro pgx quicksum Using preset calculations button on the Notebook toolbar.
Multiple rows
Select the cells and a blank column to the right, and click the QuickSum button Wordperfect Quattro Pro pgx quicksum Using preset calculations on the Notebook toolbar.
Rows and columns for a grand total
Select the cells with a blank column to the right, and a blank row below, and click the QuickSum button Wordperfect Quattro Pro pgx quicksum Using preset calculations on the Notebook toolbar.
Rows or columns on multiple spreadsheets
Select the rows or columns and a blank row and column around the data on each spreadsheet, and click the QuickSum button Wordperfect Quattro Pro pgx quicksum Using preset calculations on the Notebook toolbar.

Wordperfect Quattro Pro note Using preset calculations

•
 
You can total several cells in a column by selecting the data plus one blank cell below. For example, to total the values in the cells A1..A3, select A1..A4. The total appears in cell A4.

Wordperfect Quattro Pro tip Using preset calculations

•
 
You can also total cells in a column or multiple columns.

To total all cells on multiple spreadsheets

Wordperfect Quattro Pro btnbacktotopproc Using preset calculations
1.
 
Select the cells that you want to total on each spreadsheet.
2.
 
Select the same cells on a blank spreadsheet.
3.
 
Click the QuickSum Wordperfect Quattro Pro Using preset calculations iddle" src="http://d2nwkt1g6n1fev.cloudfront.net/helpmax/wp-content/uploads/sub/quattro-pro/en/source/images/pgx_quicksum.jpg" height="17" width="17" border="0" hspace="0" vspace="0"> button on the Notebook toolbar.

To total subtotals in a column

Wordperfect Quattro Pro btnbacktotopproc Using preset calculations
1.
 
Select the first blank cell below the column containing the subtotal cells.
2.
 
Click the QuickSum Wordperfect Quattro Pro pgx quicksum Using preset calculations button on the Notebook toolbar.

To use Calc-As-You-Go

Wordperfect Quattro Pro btnbacktotopproc Using preset calculations
1.
 
Select the cells on which to perform running calculations.
2.
 
View the totals on the application bar.

To disable Calc-As-You-Go

Wordperfect Quattro Pro btnbacktotopproc Using preset calculations
1.
 
Click Tools Wordperfect Quattro Pro onestep Using preset calculations Settings.
2.
 
In the list of categories, double-click Workspaces, Application, and click General.
3.
 
Disable the Calc As-You-Go check box.

Using preset calculations