Excel . , Office (New). (New Workbook), (New Document), Word.
Excel ( (Blank Workbook)), . , , , . - Microsoft Office .
, Word. Excel 2007 , . Excel , Excel 97-2003 (Excel 97-2003 Workbook).
(, , ), . , Enter ( ) . , .
: | : | ||
( ) | 1.0 | ( ) | |
(, ) | 1,0 | ( ) | |
1e0 | ( ) | 1.e0 | ( ) |
1,e0 | ( ) | =sin(1) | (= , sin , 1 ) |
=sin(1.) | ( ) | =sin(1,) | (= , sin , 1, ) |
:
. . , ;
, , .
, Delete.
. ; , .
.
, , . , .
, Ctrl. , , , .
|
|
, Shift, . , , , , .
. .
Ctrl+A. . , .
. , . . Excel , ( ) ( ). , . , , , .
, Word. (Font), Word. , .
. , .
(Orientation) . , . , .
, . , , , , . , . (Wrap Text), (Alignment). .
( ) () . - , .
, - , . , . , , .
, . , , . (Number) . , , , .
|
|
:
(General). , ;
(Number). ( ). ( ) , . (Use 1000 Separator) (, , ) ;
(Currency). . , , (Symbol);
(Accounting). , ;
(Date). . ();
(Time). , ;
(Percentage).
%;
(Fraction). ;
(Scientific). . n, X10n, , (); n ; , . , 45670000 4,57+07. , ;
(Text). ;
(Special). , , . .
? -, . -, , , , , , - , . . , ( ), , .
Excel. , . . Excel, , .
1. . R1C1:R3C1. R4C1 , .
1. R4C1.
2. .
3. R1C1.
4. . = R[-3]C+.
5. R2C1 . =R[-3]C+R[-2]C+.
6. R3C1 Enter. R4C1 , =R[-3]C+R[-2]C+R[-1]C.
, R4C1 =R[-3]C+R[-2]C+R[-1]C. , , . , . . , . , R[-3]C , ( ). R[-2]C[6] , . ( ) ( ). Excel, , .
|
|
2. Excel, , . , R4C1 R5C5.
1. , R4C1 .
2. , .
3. , R5C5, . , R5C5.
. =R[-4]C[-4]+R[-3]C[-4]+R[-2]C[-4]. . , R[-4]C[-4] . , R1C1.
. , F4. .
. . . R1C1:R3C1, .
3. R1C1 R2C1, R3C1 1000. R6C5.
.
1. R6C5.
2. .
3. R1C1.
4. .
5. R2C1.
6. (*).
7. R3C1.
8. (/).
9. 1000 Enter. =R[-5]C[-4]+R[-4]C[-4]*R[-3]C[-4]/1000.
, , . , Excel , . , , =(R[-5]C[-4]+R[-4] C[-4])*R[-3]C[-4]/1000. , , , .
, :
+ () ;
- () ;
* () ;
/ () ;
^ ( Shift+6) . 2^3 ( ).
|
|
(= , <> , < > ).
, , . -, . , R7C5 =R[-2]C+R[-1]C. To R7C5 R5C5 R6C5. , . , R1C1:R3C1, R7C5 , R5C5 R6C5. , , . -, . -, . .
Excel . R7C5 (R1C1:R1C3, R5C5 R6C6) , R7C5. R7C5 (Trace Precedents) , , R7C5 R5C5 R6C5. , R1C1, R2C1 R3C1.
, . R1C1:R1C3 (Trace Dependents), , R5C5 R6C5, R1C1:R1C3. , (Remove Arrows).
: , . , . , , .
, , :
##### . , . ;
#/0! . , , ;
#! ;
#? ;
#! , .
, . .
- , . ( ), - .
Excel . . . . ?
. (SUM). , . , . ? . .
4. R1C1:R3C1 R8C5.
1. R8C5. .
2. (Formulas) .
3. (AutoSum).
4. R1C1.
5. , , R3C1, . R1C1:R3C1 .
6. Enter. R8C5 R1C1:R3C1.
|
|
R5C5 R8C5 : R1C1, R2C1 R3C1. R8C5. =CM(R[-7]C[-4]:R[-5]C[-4]). , , : . . . , ( , ).
. , . , . , R2C2:R7C7 .
: ( ). .
. (Function Library) , . (Math & Trig) . (Financial) . (Text) . . . , Excel.
5. , - . , . , . , .
1. .
2. R1C2. .
3. (Insert Function) . .
4. (Or select a category) (Logical).
5. , , (IF).
6. . (Function Arguments). ( , ), .
7. _ (Logical_test) R1C1<0. . (, , ). (True) (False). , . . , , .
8. __ (Value_jf_true) .
9. __ (Value_if_false) .
10. , .
R1C1 , . , , . R1C1 , , , .
. . , , __ (Value_ if_false), . , .
. -, , . -, ( ). ( ) Excel.
. , . ( ) . . , , .
, . (Borders) . , , .
, (Thick Box Border), , .
(Draw Border) , . , .
(Format Cells), (More Borders) .
(Border) .
(Line) .
(Color) . , (More Colors). , RGB.
(None), (Outline) (Inside). , . . . , , , .
(Border) , ( , ) . . , , .
, . , , . (Cell Styles) .
. , , , , . , . . (Conditional Formatting) . , . , , .
6. ( ).
.. | |||||
2013 | 100,00. | SOS | |||
/ | |||||
3100,00. | 1000,00. | 2100,00. | |||
2800,00. | 1000,00. | 1800,00. | |||
3100,00. | 1000,00. | 2100,00. | |||
3000,00. | 1000,00. | 2000,00. | |||
3100,00. | 1000,00. | 2100,00. | |||
3000,00. | 1000,00. | 2000,00. | |||
3100,00. | 1000,00. | 2100,00. | |||
3100,00. | 1000,00. | 2100,00. | |||
3000,00. | 1000,00. | 2000,00. | |||
3100,00. | 1000,00. | 2100,00. | |||
3000,00. | 1000,00. | 2000,00. | |||
3100,00. | 1000,00. | 2100,00. | |||
36500,00. | 1000,00. | 35500,00. |
1. R1C1 . R1C1 R1C6.
2. R2C1 1- 2- . R2C1: R2C3. .
3. 100. .
4. 3- 3- . .
5. R2C5 . R2C5:R3C5. .
6. R2C6 SOS. R2C6:R3C6. .
7. : 1- 1; 2- ; 3- 31: 4- =RC[-1]*R2C4; 5- 1000; 6- =RC[-2]-RC[-1].
8. 4- . , 12 .
9. .
1. Excel
2. ?
3. ?
4. Excel?
5. Excel ?
6. ?
7. ?
8. ?
9. ?
10. ?
11. ?
12. ?
Excel 2007. Office, < > . [ ]. | |
. . [ ]. | |
(Name Box). | |
( ) R1C1 A1 ( ) [ ]. | |
[ ]. | |
R1C1(R1C1 reference style) | |
[ ]. | |
R7C3 =SIN(1,5) ( ) Enter [ ]. | |
R7C3. [ ] | |
[ ]. | |
Excel 97-2003(Excel 97-2003 Workbook). | |
, , [ ]. . | |
, , . , , , [ ]. . | |
3 5. , , , [ ]. . | |
. , , , [ ]. . | |
[ ]. | |
(Orientation) [ ]. | |
(Wrap Text), [ ]. | |
, , . 5 5. : , (Font),(Orientation), (Wrap Text). [ ]. . | |
: (General), (Number), (Currency), (Date), (Time), (Percentage), (Fraction), (Scientific), (Text), (Special). [ ]. . | |
1 [ ]. | |
R1C1:R1C3 [ ]. | |
2 [ ]. | |
[ ]. | |
. [ ]. R1C1. | |
3 [ ]. | |
R7C5 [ ]. . | |
R1C1 [ ]. . | |
, 4. R8C5 [ ]. | |
, 5. R1C2 [ ]. | |
R1C1 [ ]. | |
R1C1 [ ]. | |
1 [ ]. ( ) | |
. | |
. . . 5 . |