OpenOffice.org OpenOffice - 3.2 Guide de base télécharger pdf (Page 211)

A similar choice is also available if you want to raise a number by the

power of another. Instead of entering =POWER(A1;2), you can enter

=A1^2.

Moreover, they have the advantage that you enter formulas with them

in an order that more closely approximates human readable format

than the spreadsheet-readable format used by the equivalent function.

For instance, instead of entering =SUM (A1:A2), or possibly =SUM

(A1;A2), you enter =A1+A2. This almost-human readable format is

especially useful for compound operations, where writing

=A1*(A2+A3) is briefer and easier to read than

=PRODUCT(A1;SUM(A2:A3)).

The main disadvantage of using arithmetical operators is that you

cannot directly use a range of cells. In other words, to enter the

equivalent of =SUM (A1:A3), you would need to type =A1+A2+A3.

Otherwise, whether you use a function or an operator is largely up to

you—except, of course, when you are subtracting. However, if you use

spreadsheets regularly in a group setting such as a class or an office,

you might want to standardize on an entry format so that everyone

who handles a spreadsheet becomes accustomed to a standard input.

Simple statistics

Another common use for spreadsheet functions is to pull useful

information out of a list, such as a series of test scores in a class, or a

summary of earnings per quarter for a company.

You can, of course, scan a list of figures if you want basic information

such as the highest or lowest entry or the average. The only trouble is,

the longer the list, the more time you waste and the more likely you

are to miss what you’re looking for. Instead, it is usually quicker and

more efficient to enter a function. Such reasons explain the existence

of a function like COUNT, which does no more than give the total

number of entries in the designated cell range.

Similarly, to find the highest or lowest entry, you can use MIN or MAX.

For each of these formulas, all arguments are either a range of cells, or

a series of cells entered individually.

Each also has a related function, MINA or MAXA, which performs the

same function, but treats a cell formatted for text as having a value of

0 (The same treatment of text occurs in any variation of another

function that adds an "A" to the end). Either function gives the same

result, and could be useful if you used a text notation to indicate, for

example, if any student were absent when a test was written, and you

wanted to check whether you needed to schedule a makeup exam.

Chapter 7 Using Formulas and Functions 211

1 2 ... 206 207 208 209 210 211 212 213 214 215 216 ... 496 497

Pas de commentaire

OpenOffice.org OpenOffice - 3.2 Guide de base Page 211