WWW.DISSERS.RU


...
    !

Pages:     || 2 | 3 | 4 | 5 |   ...   | 8 |
- - .

2001 , 65. 641 73 .., .., .. - "- . ". : - , 2001. 79 .

- Microsoft Excel, .

- "- " .

AUP.Ru. - http://www.aup.ru/books/m85/ . 25. . 30. .: 7 .

.-. .

:

.., . . , . .., - . , , 2001.

.., .., .., 2001 5 1. 1 () MICROSOFT EXCEL 6 1.1. 6 1.2. 6 1.3. EXCEL [5] 6 1.3.1. 7 1.3.1.1. 7 1.3.1.2. 13 1.3.2. 16 1.3.3. 17 1.3.4. 20 1.3.5. 1.4. 1.5. 2. 2 ( I) ߔ 2.1. 2.2. 2.3. [1,2,3,4,6,7] 2.4. 2.5. 3. 2 ( II) ߔ 3.1. 3.2. 3.3. [5,6,7] 3.3.1. 3.3.2. 3.3.3. EXCEL 3.3.3.1. 3.3.3.2. 3.4. 4. 3 . 4.1. 4.2. 4.3. [1,2,3,4,6,7] 4.3.1. () 4.3.2. 4.4. 4.6. 5. 4 . Ք 5.1. 5.2. 5.3. . [1,3,6,7] 5.4. 5.5. 4 5.4. 5.5. 6. 5 . ߔ 6.1. 6.2. 6.3. 6.4. 6.5. 6.6. 7. 6 .

ɔ 7.1. 7.2. 7.3. 7.4. 7.5. 7.4. 7.6. - , Microsoft Excel.

, .

1 :

;

MS Excel.

27 :

;

.

12 , , , .

, Microsoft Excel.

1) .

2) .

3) .

4) .

5) * .

1. 1 Microsoft Excel 1.1. () Microsoft Excel.

1.2. , , Microsoft Excel .

1.3. Microsoft Excel [5] Microsoft Excel, .

1. :

a) :

, (), , ;

b) :

, , ;

c) :

, ;

d) ( " "):

, ;

e) ( " "):

, , .

2. :

a) ( " ");

b) ( " ");

c) ( " ").

1.3.1. :

L (X )= 130,5x1 + 20x + 56x3 + 87,8x max;

2 - 1,8x1 + 2x + x3 - 4x = 756, 2 (1.1) - 6x1 + 2x 2 + 4x3 - x 4 450, 4x - 1,5x + 10,4x3 + 13x4 89, 1 x j 0; j = 1,4.

1.3.1.1. (1.1) .1.1.

. 1.1. (1.1) ( F6) . 1.1 Excel.

, , , , . , , (1.1) B3 ( x1), C3 ( x2 ), D3 ( x3), E( x4 ), B6 (c1 = 130,5), C6 (c2 =20), D6 (c3 =56), E6 (c4 = 87,8), H10 (b1 = 756), H11 (b2 =450), H12 ( b3 = 89) ..

F6, , , . (1.1) 130,5x1 + 20x2 + 56x3 + 87,8x4.

(1.2) Excel (. . 1.1), (1.2) , (B3, C3, D3, E3), , (B6, C6, D6, E6), B6 B3 + C6 C3 + D6 D3 + E6 E3.(1.3) (1.3) F6 "Enter" =(B$3:E$3;B6:E6), (1.4) $ 3 , Excel 3 ;

: , , , (, B6:E6 B6, C6, D6 E6). 0 ( ) (. 1.2).

.1.2. (1.1) ( F6) 1.1. Excel " ", "" " fx " . , , (1.4) :

F6;

" fx ", " 1 2";

"" "";

"" ;

"" " 1" B$3:E$3, " 2" B6:E6 (. 1.3);

" 1" " 2" "" (. . 1.3), F6 , , 0 ( ).

. 1.3. " " (1.1) , (B3, C3, D3, E3), , (B10, C10, D10, E10 1- ; B11, C11, D11, E11 2- B12, C12, D12, E12 3- ). , , . 1.1.

1., (1.1) Excel -1,8x1 + 2x2 + x3 - 4x4 =(B$3:E$3;B10:E10) B10 B3 + C10 C3 + D10 D3 + E10 E- 6x1 + 2x2 + 4x3 - x4 =(B$3:E$3;B11:E11) B11 B3 + C11 C3 + D11 D3 + E11 E4x1 -1,5x2 +10,4x3 +13x4 =(B$3:E$3;B12:E12) B12 B3 + C12 C3 + D12 D3 + E12 E . 1.1, , (1.1), (1.4) F . , . . :

F6 F6 ( "Ctrl-Insert");

, F10, F11 F12, ( "Shift-Insert") ( , );

F10, F11 F12 0 ( ) (.

. 1.2).

. , (. 1.4 1.5).

. 1.4. F. 1.5. F " ", "" (. 1.6):

" ";

$F$6 ;

, " ".

. 1.6. " " (1.1) " " " " $B$3:$E$3. " " .

, (. . 1.1).

"", " " (. 1.7).

" " $B$3:$E$3. , .

.

"" , $B$4:$E$4. .

. 1.7. (1.1) ,, = "" " ".

" " , $F$10. , .

Pages:     || 2 | 3 | 4 | 5 |   ...   | 8 |



2011 www.dissers.ru -

, .
, , , , 1-2 .