لطفا منتظر باشید ...
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 TERMFunctions Built-in mathematical and logical routines that perform common calculations.
