User Guide

data analysis ..........233-234
data models
scenarions ............216
data ranges
coloring ...........204-205
data types
changing color ...........204
database files
opening ............220
saving .............220
databases .............233
multidimensional ..........234
relational ............233
using OLAP............234
date formats ............208
DATE function ..........184,186
dates
current .............185
entering ...........184-186
formatting ............209
in footers ............210
in headers ............210
international settings ........170,173
printing ............210
spreadsheet functions .........186
DDE..............225
decimal format ...........208
default column width..........198
default margin settings .........211
default row height ..........198
default templates...........181
delay time
changing ............196
drag and drop ...........197
deleting
columns ............167
rows.............167
spreadsheets ...........169
delimiters for columns ........223,225
division .............187
division signs
forward slashes ..........187
Draft View
selecting ............173
drag and drop
delay time ............197
Quattro Pro objects .........226
dragging
cells ............196-197
page breaks ...........209
dynamic
data .............233
E
edit mode.............192
editing
cells ............191-192
data .............192
footers .............210
headers ............210
multiple spreadsheets .........195
emailing
notebooks ............221
sending notebooks .........221
embedding
OLE..............225
Quattro Pro objects ........226-227
equations
simple .............187
solving .............213
erasing .............192
ERR..............167
examining data ..........233-234
exchanging
columns and rows ..........197
exiting
notebooks ............180
Experts .............157
Analysis ............157
Budget .............157
Chart .............157
Consolidate ...........157
Database ............157
Map .............157
Scenario ............157
Slide Show ............157
What-If .............157
explanatory reporting .........233
external data sources ........233-234
external databases
CrossTab reports.........233-234
extracting
files ............178-179
F
fields
CrossTab reports ..........233
file extensions
.QPW.............178
.XLS .............178
default ...........178-179
file formats
.QIF .............220
.QPX .............224
opening ............219
240 Index: Quattro Pro 10