. S Word, Excel
..
, 2011 .
- . Microsoft Excel
() 2011
..
1. : . S Word, Excel.
2. : 3 .
3. (): , , .
4. :
.
5. : Microsoft Excel.
6. : Microsoft Excel.
7. :
- Microsoft Excel ,
- ,
- .
8. :
) :
1. Microsoft Excel.
2. () .
) :
1. Microsoft Excel .
2. , .
3. . .
4. .
5. .
6.
7. .
8. .
9. Microsoft Word
:
1. .. ., , , 1997, . 80-89.
2. .. ., , , 2005, 256 274.
:
1. ., ., . , 1-, , , 1998, . 452-477.
2. ., ., . , 2-, , , 1998, . 291-309.
3. .., , , 2000, . 374-381.
4. ., ., , , 2000, . 366-403.
- (, )
Microsoft Excel .
, Microsoft Excel, . .
, +, -, *, /, ^ Excel ( ), , . , : , , . , , ( ) ..
|
|
, .
, . :
. , . Excel =. , =, Excel . =!. , (), . , G9 =7+5*8, , G9 7, 8, 5. =7+5*8 , , .
. , (=).
, , .
, . .
3. . .
Microsoft Excel:
ü Microsoft Word → , Ctrl+C, Ctrl+Insert, , → , Ctrl+V, Shift+Insert, .
ü (.1):
- , (. 1, );
- , (. 1, );
- , (. 1, );.
- (. 1, );
|
|
, , , . :
- () () , .
- () () , .
3 () :
, , .
, 1 =1/1.
2 =2/2,
3 =3/3,
4 =4/4,
5 =5/5, .. ( ).
D1 =B1/C1,
E1 =C1/D1,
F1 =D1/E1,
G1 =E1/F1, .. ( ).
, , $. .
, 1 =$$1/$$1.
2 =$$1/$$1,
3 =$$1/$$1,
4 =$$1/$$1,
5 =$$1/$$1, .. .
D1 =$$1/$$1,
E1 =$$1/$$1,
F1 =$$1/$$1,
G1 =$$1/$$1, .. .
, , $. $ , .. , $ .
, 1 =$1/$1.
2 =$2/$1,
3 =$3/$1,
4 =$4/$1,
5 =$5/$1.
( ) $ , ( ) $ ( ) $ ( ).
D1 =$1/C$1,
E1 =$1/D$1,
F1 =$1/E$1,
G1 =$1/F$1.
( ) $ , ( ) $ ( ) $ ( ).
.
:
1. . . Enter.
2. , . . . Enter.
$ .
, $ $ Shift;
F4, =1 =$$1, F4 =$1, =$1, F4 =1. , F4 , .
|
|