OpenOffice.org OpenOffice - 3.3 Grundlegende Anleitung PDF herunterladen (Seite 172)

100

101

Calculations linking sheets

Another powerful feature of Calc is the ability to link data through several

worksheets. The naming of worksheets can be helpful to identify where specific data

may be found. A name such as Payroll or Boise Sales is much more meaningful than

Sheet1. The function named SHEET() returns the sheet number in the collection of

spreadsheets. There are several worksheets in each book and they are numbered

from the left: Sheet1, Sheet2, and so forth. If you drag the worksheets around to

different locations among the tabs, the function returns the number referring to the

current position of this worksheet.

An example of calculations obtaining data from other work can be seen in a business

setting where a business combines revenues and costs of each of its branch

operations into a single combined worksheet.

Sheet containing data

for Branch 1.

Sheet containing data

for Branch 2.

172 OpenOffice.org 3.3 Calc Guide

1 2 ... 167 168 169 170 171 172 173 174 175 176 177 ... 433 434

Kommentare zu diesen Handbüchern

Keine Kommentare

OpenOffice.org OpenOffice - 3.3 Grundlegende Anleitung Seite 172

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software OpenOffice.org OpenOffice - 3.3