2
Microsoft Excel
1 -22
, 2012
.
Excel.
Excel , . (=), Excel , , . , . - , . , ( ). , Excel.
.
1. .xls > .
2. 10 =(-)/*100.
Excel, . . , , +, -, *, / , .
3. 10 , 10 F10.
, 100, , .
4. 3 7.
5. .
6. 2 . .
, , .
, , , (').
.
1. 8 . Tab.
2. . , . 10.2. , : , . Excel :
|
|
|
o , , , ;
o . .1
| (DATE) | Excel |
| (DATEVALUE) | Excel |
| (DAY) | |
| 360 (DAYS360) | 60- |
| (HOUR) | , |
| . (MINUTE) | , |
| (MONTH) | |
| J- (NOW) | |
| (SECOND) | , |
| (TIME) | 0 1 |
| (TIMEVALUE) | |
| (TODAY) | |
| (WEEKDAY) | |
| (YEAR) |
1.
, .2;
2.
| COS, SIN, TAN, | |
| ACOS, ASIN, ATAN, ATAN2 | |
| COSH, SINH, TANH | |
| ACOSH, ASINH, ATANH | |
| LN, LOG, LOG10 | , 2 10 |
| EXP | |
| (EVEN), OKPyiTI(ROUND), (ROUNDUP), (ROUNDDOWN), 4ETH(ODD) | |
| ABS | ( )' |
| (DEGREES), | |
| (RADIANS) |
| (INT) | |
| (MOD) | |
| (1) | |
| (POWER) | |
| (PRODUCT) | |
| (RAND) | |
| (ROMAN) | |
| (SQRT) | |
| (SUM) | |
| (SUMSQ) | |
| (TRUNC) |
10.3.
| (AVEDEV) | |
| (AVERAGE), (AVERAGEA) | |
| (COUNT), (COUNTA), (COUNT-BLANK), (COUNTIF) | |
| (DEVSQ.) | |
| CFFEOM (GEOMEAN) | |
| (), () | |
| (M1N), (MINA) | |
| (STDEV), (STDEVA), | |
| (STDEVP), (STDEVPA) - (VAR), (VARA), (VARP), (VARPA) |
o , , . . 10.3;
|
|
|
o , , , Excel;
o , ;
o . .-10.4
10.4.
| (CHAR) | |
| (CLEAN) | |
| (CODE) | |
| (CONCATENATE) | |
| (EXACT) | |
| (LEFT) | |
| (LEN) | |
| (LOWER) | |
| (PROPER) | , |
| (REPT) | |
| (RIGHT) | |
| , (TEXT), (FIXED) | |
| (TRIM) | () |
| (UPPER) | |
| (VALUE) |
o , , . . 10.5;
o , , .
| (AND) | |
| (FALSE) | |
| (IF) | , , , |
| (NOT) | |
| (OR) | |
| (TRUE) |
10.5.
3. (. . 10.2) .
4. .
5. .
, SIN, , . , , . 30 , .
, .
6. 1.
7. .
8. .
9. 2.
10. B4:G4 .
11. 3, B6:G6. .
12. .
| Excel, , , . |
.
Excel , ( , 26) . , .
1. 9 . Tab.
2. = () (=SUM ()). , .
|
|
|
3. .
4. : .
5. .
6. .
7. B3:G3.
8. Ctrl B5:G5.
10.6.
| F3 | F -3 |
| 10:20 | 10- 20- |
| 15:15 | 15 |
| 5:5 | 5 |
| 5:10 | 5- 10- |
| : | |
| B:J | c B no J |
| 10:20 | 10- 20- |
10. , . 10.8.
11. Enter.
12. 19, =() (=SU()) Enter. 19 5.
13. .
14. . .
. .
. , Excel . 10 , . , .
1. 10.
2. B10:F10.
3. Ctrl+C .
4. 11, .
5. 12 Ctrl+V, .
, .
6. 13 14.
7. 2:6 10:14.
. , , Excel .
8. 12:16.
9. .
10. II
.
5. B11:F11 (AVERAGE B11:F11).
6. Enter. #, \ . , , .. . 10.7 , .
7. , 111 .
10.7.
| ##### | , |
| # (#VALUE!) | . , , |
| #/0(#01/0!) | 0 |
| # (#NAME!) | Excel , , |
| #/ (#N/A) | |
| *# (#REF!) | |
| #(#!) | , |
| # (#NULL!) | , |
|
|
|
5. , ( 11:F11) (AVERAGE(B11:F11)).
.
1 Bl:Gl.
2 .
3 1 .
4 A3 =(1;3) (=LEFT(A1; 3)). 1.
5 , A3:F3. .
6 =(;D3) (CONCATENATE (; D3)). .
7 8 = () (=NOW ()) Enter. .
8 8 13 = (8) (=YEAR(A8)), =(8) (=MONTH (8)),=(8)(=DAY(8)),=(8)(=HOUR(A8)),=(8) (=MINUTE(A8)) =(8) (=SECOND (A8)). .
9 8, .
10 , .
11 4 =(=""; ""; "") (=IF(=""; " "; " ")).
12 4 , A4:F4
, Excel , . 10.8.
, , . , , , .
10.8.
| = | |
| > | |
| < | |
| >= | |
| <= | |
| <> |
:
Excel. :
;
;
;
;
;
.
