Chapter 7. Working with Calc Data

IN THIS CHAPTER:

48 Find and Replace Data

49 About Calc Ranges

50 Create a Range

51 Fill Cells with Data

52 About Calc Functions

53 Enter Calc Functions

54 Use the Function Wizard

55 Reference Data Outside This Sheet

56 Work with Dates and Times

57 About Names as Addresses

This chapter teaches you how to manage and organize your Calc spreadsheets to make them really work for you. You'll be surprised how Calc follows and updates formulas as you modify worksheet data. If you really want to master Calc, you must understand how to set up and work with cell ranges. Therefore, this chapter's material will greatly enhance your Calc expertise. You will learn to use range names and references to produce more powerful Calc formulas and functions.

In addition to learning about Calc's range features, you'll also see how Calc's built-in functions save you many steps when you need to perform calculations. By using functions, you'll leverage the use of common calculations such as averages and advanced calculations such as trigonometric calculations.

KEY TERM

Functions Built-in mathematical and logical routines that perform common calculations.