Copyright Goodheart-Willcox Co., Inc.
xiii xiii
Copyright Goodheart-Willcox Co., Inc.
Chapter 9
Advanced Spreadsheet Uses. . . . . . 322
Section 9.1 Calculating with Functions . . . . . . .324
Using Functions . . . . . . . . . . . . . . . . . . . . . . . . 325
Complex Financial Formulas. . . . . . . . . . . . . 331
Logical Functions. . . . . . . . . . . . . . . . . . . . . . . 332
Section 9.2 Visual Enhancements of Data . . . . .335
Conditional Formatting . . . . . . . . . . . . . . . . . 336
Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 338
Spreadsheet Charts in Text Documents . . . . 341
Tables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 344
Comma-Separated Values Files. . . . . . . . . . . 344
Chapter Summary . . . . . . . . . . . . . . . . . . . . . . .346
Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . .346
Application and Extension of Knowledge . . . . .347
Capstone Project. . . . . . . . . . . . . . . . . . . . . . . .349
Chapter 10
Database Software . . . . . . . . . . . . . 350
Section 10.1 Introduction to Databases . . . . . .352
Overview of Databases . . . . . . . . . . . . . . . . . . 353
Examining a Database. . . . . . . . . . . . . . . . . . . 356
Creating a Database Structure . . . . . . . . . . . . 359
Section 10.2 Importing and Viewing Data . . . . .365
Importing Records into a Database. . . . . . . . 366
Securing a Database . . . . . . . . . . . . . . . . . . . . 366
Viewing Data . . . . . . . . . . . . . . . . . . . . . . . . . . 368
Joining Tables . . . . . . . . . . . . . . . . . . . . . . . . . . 375
Section 10.3 Queries. . . . . . . . . . . . . . . . . . . . .380
Locating Data . . . . . . . . . . . . . . . . . . . . . . . . . . 381
Creating Calculated Fields . . . . . . . . . . . . . . . 387
Creating Statistical Fields . . . . . . . . . . . . . . . . 389
Chapter Summary . . . . . . . . . . . . . . . . . . . . . . .392
Chapter Test . . . . . . . . . . . . . . . . . . . . . . . . . . .392
Application and Extension of Knowledge . . . . .393
Capstone Project. . . . . . . . . . . . . . . . . . . . . . . .395
Glossary . . . . . . . . . . . . . . . . . . . . . 396
Appendix A:
Math Skills Review . . . . . . . . . . . . . . 402
Appendix B:
Punctuation, Capitalization,
and Number Expression . . . . . . . . . 419
Index. . . . . . . . . . . . . . . . . . . . . . . . 424