ΒΑΣΙΚΕΣ ΑΡΧΕΣ ΤΟΥ EXCEL
date post
11-Mar-2016Category
Documents
view
223download
6
Embed Size (px)
description
Transcript of ΒΑΣΙΚΕΣ ΑΡΧΕΣ ΤΟΥ EXCEL
: Excel
Excel
....
&
: &
:
EXCEL: Dr.
:
..: 172/10
2010-2011
, 2011
. Excel. 3
. . 6. . 8. . 9
1. . 10
2. . 10
3. . 12
4. . 14. . 15. . 17
1. . 17
2. . 20
3. . 21
4. . 22
5. . 23. Excel
EXCEL . . Windows. , . . . . ( ) . , . Excel.
. . . . 1. . . .
. Excel . , . Excel . , , . . CAPS LOCK CAPS NUM LOCK NUM, .
. Excel, , , . . . , Excel. Excel. . , , C, D, E ., 256 65.536 . . 1 1. 1 . . 16.777.216 (256 ) (65.536 ). . Windows. . . Excel (03). . , . . . . . Excel . End , , , , , , . Home. Control , , , ,, End. PageUp PageDown . Control+Home ( 1) Control+End . End Home. Control+PageUp Control+Page Down . :
Ctrl+
Ctrl+
Ctrl+
Ctrl+
Home
End
PageUp
PageDown
Ctrl+Home
Ctrl+End
Ctrl+PageUp
Ctrl+PageDown . . . . . . . , . . .
. , Excel . . . Excel Enter Tab . . . , , Excel N. . Esc- Escape . . . . . Enter . . .
DELETE. .1. Excel . . , . , . . . . Excel . Excel. . . . . . , . . .. . . . 2. Excel . . , . Excel . , Excel . , Enter . . . Excel. . Excel . , . . , , .
3.
Excel . Excel . Excel .
. C . C , . Excel - , -100. Excel (%), , .A) , . Excel (20) Excel . : + - $ / () , % e . : 100, 1 , 12,345, 1+09. 1+09 1000000000 , . .
B)
, Excel .. 15/11/01. Excel . . Excel , . ) . Shift 5 . Excel . 10 % Excel 0,1. Excel . Excel . Excel . 1 3/5, Excel . 1,6. Excel 1 3/5 1,6. : 1 , 3, 5. 3/5 Excel . Excel . 3/5 (0) 3/5. )
Excel Excel. Excel . #########. . 4.
Excel. . . Excel (=). Excel . Excel . Excel. (=2+3) (5) . 1 2 (=1+2) 1 2 , . . 1 (=2+3), 1 (=1+2), ... #####. Excel.
.
. Excel . . Excel . . . . . . . . Excel . , . , DELETE. . . . . .
.
Excel . , -. Excel . 1. Excel . . . . , , , , . .
. . . . . . Excel. , ( : ), 3:10.
SHIFT , , . SHIFT . . . , . CTRL. CTRL . CTRL .
Excel . . . , . . SHIFT, . CTRL. CTRL . , . , .
. . , .
Excel ENTER SHIFT-ENTER SHIFT-TAB. . ENTER SHIFT-ENTER . TAB SHIFT-TAB . , , , . 1, 2 3 1:C10, 1 1 1 1 2 1 3 . (3) Excel , .
2. Excel . . , . Excel CTRL. CTRL . . , CTRL. CTRL . CTRL CTRL. , . . . 3. (-) . Excel . Excel .
, 1 18/04/2011. , 2:8. . Excel . Excel . . . Excel . . , , , , , Excel . . . Excel , . , , , . 18/04/2011, 18/05/2011, 18/06/2011 . Excel . .
4. . , , , (fill handle). , . (AutoFill) , , . Excel . , , , . , , . 1/5/97 1/6/97 , , 1/7/97, 1/8/97 .
1 2, , 3, 4, 5 . , , 1 3 , 5, 7, 9 . 1 , 1. , , Control , 2, 3, 4 . 1 , 2, 3 . , , , , .. , , , , Control . , , .
5. Excel , , , . , Excel . . . , ... . . , , . . : :. , .
Excel . : . Excel , . . , .
.
.
.
-19-