Spreadsheet 150
Entering Formulas
You begin a formula by typing
=
(an equal sign). Next, you use
references, values, operators, and built-in functions to describe the
calculation you want to perform. The illustration at the left shows how
you might use a formula to add the expenses for an evening on the town.
Cell B4 contains the following formula:
=B1+B2+B3
This formula tells Spreadsheet to add the values in cells B1, B2, and B3
and to show the result in cell B4. Here are the elements of this formula:
S
The equal sign (=) tells Spreadsheet it is a formula. All formulas must
start with an equal sign.
S
B1, B2, and B3 are references.
S
The plus signs (+) are operators.
The example above does not include a built-in function. For more
information about built-in functions, see Using Built-in Functions in
Formulas" on page 153.
"
To enter a formula using the keyboard alone:
1. Select the cell in which you want to enter the formula.
2. Type = to begin the formula.
The equal sign appears in the Edit Area.
3. Type the reference for the first cell you want to use in the calculation.
4. Type the operator you want to use. For example, type
+
for addition.
5. Type the reference for the next cell you want to use.
6. Continue typing operators and cell addresses until the formula in the
Edit Bar appears as you want it.
7. Press the
ENTER
key
. The result of the formula appears in the cell.
"
To enter a formula using the keyboard and the mouse:
1. Select the cell in which you want to enter the formula.
2. Type
=
to begin the formula.
The equal sign appears in the Edit Area.
3. Click on the first cell you want to use in the calculation.
The cell address
appears in the Edit Area.
4. Type the mathematical operator you want to use. For example, type * for
multiplication.
5. Click on the second cell you want to use.
The cell address appears in the
Edit Area.
6. Continueclicking and typing operators until the formula in the Edit Bar
appears as you want it.
7. Click on the Enter button or press
ENTER
.
The result of the formula
appears in the cell.
Содержание Ensemble PDP-100J
Страница 11: ......
Страница 71: ...Getting Started 60 Optional Accessories Fax Modem Data Modem Scanner Cut Sheet Feeder ...
Страница 72: ......
Страница 83: ......
Страница 84: ...Word Processing 71 3 Word Processing Important Word Processing Tips ENTER ENTER TAB SPACEBAR TAB ...
Страница 152: ......
Страница 217: ...Spreadsheet 203 The following dialog box appears ...
Страница 219: ......
Страница 262: ......
Страница 269: ......
Страница 284: ......
Страница 301: ......
Страница 306: ...Calculator 287 Cut and paste Handling Error or Overflow Conditions To clear an error ...
Страница 308: ...Calculator 289 Converting Measurements S S S S S S To convert ...
Страница 312: ......
Страница 325: ......
Страница 327: ...Book Reader 306 To close a book Using Information and Text To read a book ...
Страница 329: ...Book Reader 308 Printing from Book Reader To print selected text from a book To print the current page ...
Страница 330: ......
Страница 333: ......
Страница 337: ...Text File Editor 314 ...
Страница 338: ......
Страница 345: ......
Страница 349: ...Scanner 324 What to do if an error occurs Error Condition Message Solution ...
Страница 350: ......
Страница 379: ......
Страница 387: ...Appendix 360 Color Clip Art SNOWMAN TEA TIGER TURTLECA WANDFLOW WATERLIL ...
Страница 396: ...Appendix 369 Print Functions Function Description Example ...
Страница 405: ...Appendix 378 Fonts Occidental Font Symbols keyboard International keyboard Math Symbols ...
Страница 406: ...Appendix 379 Ping Pong Font Pointer keyboard Numbers keyboard Symbols keyboard Other Symbols ...
Страница 407: ...Appendix 380 Shattuck Avenue Font Symbols keyboard International keyboard Math Symbols ...
Страница 408: ...Appendix 381 URW Mono Font Symbols keyboard International keyboard Math Symbols ...
Страница 409: ...Appendix 382 URW Roman Font Symbols keyboard International keyboard Math Symbols ...
Страница 410: ...Appendix 383 URW Sans Font Symbols keyboard International keyboard Math Symbols ...
Страница 411: ...Appendix 384 URW SymbolsPS Font Bracket keyboard Greek keyboard Symbol Math keyboard Symbol Other keyboard ...
Страница 414: ......
Страница 418: ...Glossary 390 ...
Страница 420: ...Glossary 392 0 1 1 1 ...
Страница 421: ...Glossary 393 text style sheet ...
Страница 422: ...Glossary 394 ...
Страница 423: ......
Страница 428: ...Index 399 D cont d 1 0 1 1 1 1 0 1 0 1 1 0 2 1 0 0 0 1 0 ...
Страница 430: ...Index 401 F cont d 1 1 0 0 1 0 0 0 0 0 0 0 0 0 G 1 0 1 ...
Страница 436: ...Index 407 S cont d 1 3 3 1 1 0 1 4 0 3 0 0 1 1 3 1 3 1 0 1 1 1 0 1 3 1 0 1 2 ...
Страница 440: ......