Chapter 7. Working with Calc Data


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.


Functions Built-in mathematical and logical routines that perform common calculations. 2, Firefox, and Thunderbird for Windows All in One
Sams Teach Yourself 2, Firefox and Thunderbird for Windows All in One
ISBN: 0672328089
EAN: 2147483647
Year: 2005
Pages: 232
Authors: Greg Perry © 2008-2017.
If you may any questions please contact us: