. , , .
, , (=), Excel 2000 . , , .
. : + (); - (); * (); / ().
, . . .
, Excel 2000 , . , Excel 2000 , .
3.1.5.1 .
Excel 2000 ( ), ( ). , (=).
, 1 100, 1 - 20. 1, 1 (=1/1) [Enter].
, . , .
3.1.5.2 .
.
B | C | D | E | |
$17.80 | $5.60 | |||
$3.80 | $5.20 | |||
$1.56 | $12.48 | |||
$63.28 | ||||
15% | $9.49 |
( ), , D - , - , . 16 . : =12+13+14. 0,15, , 17: =16*0,15.
, (, 19) , 0,15. : =(12+13+14)*0,15. , 16 17. SUM(), : =Sum(E12:E14)*0,15.
|
|
3.1.5.3 .
, . , [F2] . ( ) , , .
3.1.5.4 .
Excel 2000 , . , , .
, , . , 3 Sheet2 : =Sheet2!B3. , () . . , ( [Ctrl-C]) , . Paste Special Edit Paste Link.
3.1.5.5. .
, . , , . .
Insert Name Define. Define Name . 255 . . (1 ..). , .
, . (), , , Create Insert Name. ( ) OK.
Define Name, , Excel () .
Refers to Define Name . , , .
. , , . , .
|
|
, (. . 2) "" 11, 12 13, , : =Sum(.
"". Excel . [Enter], .