: .
- . MS Excel , . .
1.
: 1) 2) .
1. Microsoft Excel.
2. 1 .
3. , . 11.
A | B | C | |
i | i^2 | ||
. 11
4. 2-11 1 10 ( i).
5. 2 =2*2. i2, i =1.
6. 2 3-11.
7. . 12 . 12 .
8. . 13 =(2:11). . 2-11 .
2.
- (n!) n : n!=1 2 3´´n. , 3!=1 2 3=6. : 0!=1 1!=1.
n! Excel
(),
- , . , .
Excel 6!
1. . .
2. . 12.
A | B | C | |
n | |||
n! | |||
. 12
1 , .
3. 2 =(B1). 720.
3. ,
.
1. . 3.
2. . 13.
A | B | C | |
k | 1/k! | ||
. 13
3. 2 1 ( k).
4. 3 =(2<10; A2+1; "end"). k, .
|
|
5. 2 3, 4 .., end.
6. 2 , =1/(2).
7. 2 3, 4 ..
8. .
9. , .
.
!
.
. 4, . , 1, 2 3 .
4
1 | 2 | 3 | |
, | |||
, | |||
, | |||
, | |||
, | |||
, | |||
, | |||
, | |||
, | |||
, | |||
, | |||
, | |||
, |