OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 236)

Chapter 4: Spreadsheets in Calc

Calc is the powerful spreadsheet program of the OpenOffice.org program. It provides the

functions necessary for professional use with financial and statistical functions as well as

database functions and much more.

Overview of the Functions in Calc

This section contains a short overview of some important functions and capabilities of Calc.

Calculating

Calc works primarily as a spreadsheet program. i.e. it provides a spreadsheet containing cells

into which text, digits and formulae can be entered and, from these, calculate simple and

complex results. Calc, like the other components of OpenOffice.org, has numerous automatic

functions to ease usage.

While Calc provides all the basic calculation types, it also has numerous calculation methods

that can be entered interactively via the Wizard: Functions. In addition, it allows

entering text and flexibly arranging cells, so forms can be comfortably styled, filled in,

calculated and printed.

Database Functions

Data that can be summarized into records, such as addresses, inventory levels, customer

orders or similar, can also be managed by Calc. Even if there are no calculations, Calc can

quickly sort a database range and search the data for specific characteristics, such as

maximum or minimum values.

In addition, a sheet in Calc can serve as a data source for creating form letters and reports

with OpenOffice.org Writer.

Arranging Data

Data can be organized in easy-to-read lists. With just a few mouse-clicks, the view can be

reorganized to show or hide certain data ranges, format ranges according to special

conditions, or calculate subtotals and totals.

Examining and Extrapolating Data

The data in Calc tables can be examined in detail in many different ways. Calc is useful for

creating term papers because it supports many statistical functions such as regression

analysis. And for daily calculations at work, the integrated financial functions are helpful,

because they can be used to print detailed tables of current credits and loans and other data.

What-If Calculations

Results of changes made to one factor of calculations composed of several factors can be

views immediately. For example, see how changing the period in a loan calculation affects

the interest rates or repayment amounts. Furthermore, larger tables are made manageable by

using different predefined scenarios.

OpenOffice.org User Guide for 2.x 202

1 2 ... 231 232 233 234 235 236 237 238 239 240 241 ... 507 508

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 236