Check nearby libraries
Buy this book
This edition doesn't have a description yet. Can you add one?
Check nearby libraries
Buy this book
Previews available in: English
Showing 1 featured edition. View all 1 editions?
Edition | Availability |
---|---|
1 |
aaaa
Libraries near you:
WorldCat
|
Book Details
Table of Contents
Introduction
Page xix
1.
Getting to Know Your Spreadsheet
Page 1
What Is a Spreadsheet?
Page 2
Starting Quattro Pro
Page 5
The Quattro Pro Screen
Page 6
The Important Keys
Page 11
Getting Help from Quattro Pro
Page 15
Navigating the Spreadsheet
Page 17
Summary of Quattro Pro's Special Keys
Page 21
Leaving Quattro Pro
Page 22
2.
Building a Spreadsheet
Page 25
Types of Cell Entries
Page 26
Entering Your Text in a Cell
Page 27
Underlining Text
Page 30
Correcting Mistakes
Page 30
Entering Numbers
Page 31
Entering Dates
Page 33
Using Simple Formulas
Page 34
Functions vs. Formulas
Page 36
Saving Your Work
Page 39
Aligning Labels
Page 41
Entering Labels That Start with a Number
Page 43
Rules for Entering Numbers
Page 44
3.
Learning Basic Editing Techniques
Page 47
Retrieving Your Spreadsheet
Page 48
Retrieving vs. Opening
Page 49
Editing a Cell Entry
Page 50
Changing a Column Width
Page 49
Inserting a Row
Page 55
Inserting a Row Block
Page 56
Inserting a Column
Page 57
Inserting a Column Block
Page 58
Deleting a Row Block
Page 59
Deleting a Row
Page 59
Deleting a Column
Page 60
Deleting a Column Block
Page 61
Using the Ready SpeedBar to Insert or Delete Rows or Columns
Page 61
Erasing a Block of Data
Page 62
Erasing the Entire Spreadsheet
Page 65
The Importance of Saving Your Work
Page 66
4.
Copying and Moving Blocks of Data
Page 69
Simplifying Your Work with the Pointing Method
Page 70
Creating a Function with the Pointing Method
Page 70
Entering the Point Mode
Page 72
Copying Information from One Cell to Several
Page 74
Copying Blocks of Information
Page 77
A Shortcut for Copying
Page 79
Using the Ready SpeedBar to Copy
Page 80
A Slight Diversion
Page 80
Copying a Formula
Page 81
Understanding Relative and Absolute Cell References
Page 83
Creating Absolute References
Page 84
Copying Only the Cell Format or Contents
Page 87
Changing Existing References
Page 87
Moving Data
Page 88
A Shortcut for Moving
Page 91
Using the Ready SpeedBar to Move Blocks
Page 91
Some Finishing Touches
Page 91
Saving the Modified Spreadsheet
Page 92
5.
Formulas and Functions
Page 95
Why a Function?
Page 96
Types of Function Arguments
Page 97
Summary of Quattro Pro Functions
Page 100
Getting Help with Functions
Page 108
A Shortcut for Entering Functions
Page 108
Nesting Functions
Page 110
Advanced Use of Operators
Page 111
Sample Applications of Formulas
Page 113
Solving for X
Page 118
6.
Enhancing Your Spreadsheet's Appearance
Page 121
Formatting Numbers
Page 122
Formatting Dates and Times
Page 124
Formatting Labels
Page 126
Reformatting Entries on a Sample Spreadsheet
Page 127
7.
Effective Management of Blocks
Page 131
Filling a Block
Page 132
Simplifying Your Work with Named Blocks
Page 135
Naming a Block
Page 137
Cell Labels as Block Names
Page 138
Placing Block Names in a Function
Page 140
How to Go to a Named Block Quickly
Page 142
Giving Blocks Absolute and Relative Names
Page 143
Moving a Named Block
Page 144
Reassigning a Block Name
Page 146
Deleting a Block Name
Page 147
Listing Block Names
Page 148
Adding Notes
Page 149
8.
Making More Productive Use of Your Spreadsheet
Page 151
Protecting a Spreadsheet
Page 152
Reformatting Long Labels
Page 155
Searching a Spreadsheet for a Specific Entry
Page 157
Transposing Blocks
Page 162
Freezing Titles
Page 164
Viewing Two Spreadsheet Areas Simultaneously
Page 167
Emphasizing Special Cells
Page 169
Auditing the Spreadsheet
Page 176
9.
Working with Multiple Spreadsheets
Page 179
Opening a Second File Window
Page 180
The Window Menu
Page 181
The File Manager
Page 188
The File Manager Menus
Page 190
10.
Printing Your Spreadsheet
Page 197
Overview of Printing Options
Page 198
The General Printing Technique
Page 199
Printing with Headings
Page 201
Setting the Page Layout
Page 205
Setting the Page Length and Margins
Page 208
Adding Page Breaks
Page 209
Choosing the Printer Orientation
Page 211
Adjusting the Printer
Page 212
How to Start and Stop Printing
Page 213
Using the Quattro Pro Print Manager
Page 214
Printing a Spreadsheet to a Disk File
Page 215
Previewing a Spreadsheet
Page 218
Handling Printer-Setup Strings
Page 219
11.
Creating Quality Graphs
Page 225
Types of Graphs
Page 226
Creating and Viewing a Graph
Page 234
Adding Titles to a Graph
Page 238
Saving a Graph
Page 240
Erasing a Graph
Page 242
Plotting Multiple Data Groups
Page 242
Adding Legends to a Graph
Page 245
From Bar Graph to Pie Chart
Page 247
Customizing Titles
Page 249
Changing Markers and Fill Patterns
Page 250
Choosing Graph Colors
Page 251
Annotating a Graph
Page 251
Creating a Slide Show
Page 261
Inserting a Graph in a Spreadsheet
Page 262
Creating a Fast Graph
Page 264
Combining Graph Types
Page 264
12.
Printing Graphs
Page 267
Selecting a Graphics Printer
Page 268
Printing a Graph
Page 271
13.
Exploring the Quattro Pro Database
Page 277
What Is a Database?
Page 278
Structuring a Database
Page 278
Creating a Sample Database
Page 282
Sorting the Database
Page 284
Searching a Database for Specific Data
Page 289
Locating and Changing Records
Page 293
Extracting Database Records
Page 294
Deleting Database Records
Page 296
Database Statistical Functions
Page 298
14.
Customizing Quattro Pro
Page 301
Changing the Screen Colors
Page 302
How to Internationalize Quattro Pro
Page 308
Changing the Default Formats
Page 311
How to Change the Working Directory
Page 312
Creating Customized Shortcuts
Page 313
Saving and Applying a Named Style
Page 313
15.
Special Features
Page 315
Linking Spreadsheets
Page 316
Installing Quattro Pro
Page 325
Index
Page 330
Edition Notes
Spine title: Quattro pro 4 for DOS.
Rev. ed. of: The ABC's of Quattro pro 3. 2nd ed. c1991.
Includes index.
Classifications
The Physical Object
ID Numbers
Community Reviews (0)
Feedback?October 18, 2022 | Edited by ImportBot | import existing book |
June 11, 2022 | Edited by ImportBot | import existing book |
March 17, 2010 | Created by WorkBot | work found |