1. Excel ̶
data ǥ óϱ software̴.
2. Program Ư¡
1) ڵ α̴
2) data chart ȭ ִ.
3) macro ̿Ͽ ڵ ۼ ϴ
4) Ģ + - / * Ѵ.
3. Excel
1) չ: ۾ չ
Ѵ. չ sheet Ǿְ sheet cell
еȴ. 1 sheet 256* 65536 cell ȴ.
1 չ(book) page sheet ̰ų ִ.
/ɼ/Ϲ/չ sheet scroll bar ̰ų ̸
ȴ.
2)
ʿ ִ
콺 콺 ư Ѵ.
* ̳ ԷµǾִ Ϸ ̳ Ͽ
Del Ű .
3) ̳
̳ 콺 ϰ
/, Ǵ / Ѵ.
4) cell
A B C D ڰ輱
콺 pointer 콺 ڷ Ѵ. ⼭
콺 , 巡 ϸ 콺 ȴ. 쿡 1 2
3 4 鿡 콺 pointer 콺 ڷ
Ѵ. ⼭ 콺 , Ϸ drag ϸ 콺 ȴ
5) ¥ Է
ڴ '4/1' Էϸ ȭ
'41'̶ Ÿ. ̹ αȭ Ǿ־ ڵȯ
̷ ̴.
6) κμ
콺 κ μ κ dragϿ
/μ⿵/μ⿵ μ κ ѷ
Ѵ. ⼭ ٷ μϸ ȴ.
7)Macro Program ̿
Ʒ 1, 2, 3, 4
ʹٸ 1, 2 1 2 ִ cell 콺
ϴܿ ڰ ǥð 콺 ̵ ؼ ڼ
Ʒ ڰ ڵϵȴ. 絵 Ѵ.
1 cell 2, 3, 4 Ǵ
̶ 2, 3, 4 ִ.
4. ۼ
: cell 콺 Ѵ. հ谡
cell Ѵ. Լ icon Ѵ. ̷ ϸ
ϴ cell =SUM(A1:E1) ǥõǰ κп =SUM(A1:E1)
ǥõȴ. (A1 C1 ̷ ) * Ǵ հ谡 ۵Ǵ
ù ° cell հױ Լ icon + ϸ
ִ.
sheet : 1 sheet cell a10
2 sheet a10 3 sheet cell a1 Ÿ ϴ
ġ Ÿ ϴ 3 sheet cell a1 cursor =sum(sheet1!a10+sheet2!a10)
ȴ.
: հ谡 ߵǴ cell '=' 콺 ̷
Ǵ cell '*" ǥø ذ ȴ. հ谡
; cell "=A1*B1*C1" . (
cell A1*B1*C1 )
sheet ϱ 1 sheet a20 + 2
sheet a20 3 sheet a1 ǥϰ 3 sheet a1 cursor
ġŰ =(sheet1!a20*sheet2!a20)̶ ϸȴ.
5.
1) sheet
κ ϰ 콺 ư
縦 ϰ 콺 ư ٿֱ⸦
Ѵ. Ǵ κ κп 콺 콺
κ ȭǥ Ѵ. 콺 ä dragϿ ϴ κ
̵Űȴ.
2) 1 sheet 2 sheet 3 sheet sheet
κ 콺 ư 縦
ϸ õ κ Ѵ. ù ° sheet 2 sheet 콺
ϸ õ 2° sheet Ͼ ȴ. shift key ä 콺 2
sheet sheet 簡 ۵Ǿ ϴ κ
cursor ű 콺 ư ٿֱ⸦ ϴ Ǵ
ٿֱ⸦ Ѵ.
6. Chart
ǥ ۼ íƮ data Ѵ. ־
ӵǾ Ÿ (chart , X / Y )
ģ. chart ϴ ҷ 콺 drag Ͽ ̵Ҽ
ְ ũ Ѵ.
6. cell
cell ϴ κ
κп ġ ä Ͽ Ѵ.
7. μ
Ưκп
Ʈ ϰ Ư cell κ //θ/
Ͽ 'STYLE' Ư ٽ
ʼ, ٱ Ͽ Ȯϰ
Ʈϸ ȴ.
8. Ÿ λ
1) Cell : cell block Ѵ. menu κ
߾ӿ '' ִ κ click Ѵ.
cell Ϸ / click Ͽ / ȭ ڸ tab click Ͽ check ǥø ش.
2) ȭ : //ǥ/ȭ/ȣ ϸ ȴ.
\ Ͽ ڸ , ǥð ڵ ǥõȴ. ȭ ÿ
ռ ȭ ǥð Ÿ cell Ѵ.
3) õ κ ʺ ϰ //ʺ ؼ
ش ǥ ʺ 8.11
ʺ Ѵ.
9. filter
filter data base data Ư Ͽ data س ̸
data ̳ Ͽ ȭ鿡 Ű ǹѴ.
: data block Ѵ.
/ click Ͽ Ÿ pop-up menu
Ȯ Ȯ ư ȴ.
filter: filter ؾ /filter/ڵ
ϸ õ ߰ ܳ. ߸ click ϸ filter
box Ÿ. ̸ Ȯ Ȯ ߸ filter data ȭ鿡
display ȴ. ٽ ⺻ data ư data//ڵ check
κ ش.
)
ȫ浿 80
50
60
̶ 100
30
10
: filer combo box ŸǷ κб
ϿѴ.
10 Ǻ
Ǻ ̶ ǿ ߾ ȯϴ ǹѴ.
Ʒ database ä 80
ǥغ
: 1б
ȸ
ȫ浿 10 20 100
100
̳ 50 90 80
95
踻 10 80 95
95
50 60 75
100
60 70 70
95
̶ 50 90 100
86
100 90 90
55
۹̳ 50 60 85
95
10 70 50
70
ҳ 50 97 100
66
1) block Ѵ.
2) menu /Ǻ click Ѵ
3) Ǻ ȭ ڰ Ÿ ʿ 2° ȭ ڿ ''
box '80' Ѵ.
4) ϴܿ '' ȭ ڰ Ÿ.
5) ̰ ۲ style ϰ ϰ Ȯϰ
ϴ ȴ.
hint: Ϸ =sum(a1:d1)/4 ̿Ѵ
1
database : 1 г ̵ ǥ/ 1999 1
1г 1 ǥ
м 80
90 50 60
ö 10
20 30 40
95
55 85 100
10
5 4 50
Ź 50
60 70 80
15
26 37 49
66
78 87 55
90
50 40 60
50
60 80 80
70
90 50 89
30
50 40 70
1г 2 ǥ
30
50 20 40
20
30 50 60
50
80 90 100
30
45 20 15
Ź 20
35 25 30
45
60 57 60
45
70 80 95
60
50 70 80
ѳ 80
50 30 40
30
50 70 40
50
60 30 80
1: 1г 1 ǥ 1 sheet ǥϸ 1г 2 ǥ 2 sheet
ǥϸ 3 sheet г cell ǥѴ
2: 1 sheet 2 sheet data chart ȭ Ѵ.
2
99 ǸŽ
99
纰 Ѹ
:
:
ѳ:
1
2 3
4 5 6
7 8 9 10
11 12 Ѹ
101200 123400
25000 45000 54000 7000 8000 9000 1900
1400 2000 35000
5500
6600 9900 9000
8000 9000 1000 8000 7000 54000 15000
65000
ѳ 10000 9900
8800 3000 5000 4000
9000 10000 1000 5000 4000 5000
3
ȣ 2000 10 1 Ѽʵб տ ۰Ը ϳ ȴ.
Ǹž Ʒ . sheet 1 10 Ǹž ϰ sheet 2
11 Ǹž ϰ sheet 3 12 Ǹž ϰ sheet 4
2000 ǸѾ Ǹ Ѿ ڵ Ͽ Ÿ Ѵ.
ܰ Ǹž \ ȭ ǥÿ 3ڸ , Ÿ Ѵ.
sheet Ǹ Ѿ Ѵ.
hint: ȭ \ ǥÿ 3ڸ ǥô
\ click ϸ ȴ.
DATA
2000 10 |
2000 11 |
2000 12 |
|||||||||
¥ |
ǰ |
ܰ |
¥ |
ǰ |
ܰ |
¥ |
ǰ |
ܰ |
|||
10/1 |
300 |
4 |
11/1 |
300 |
50 |
12/1 |
300 |
1 |
|||
|
500 |
5 |
|
500 |
25 |
|
500 |
2 |
|||
|
̴ |
1000 |
3 |
|
̴ |
1000 |
44 |
|
̴ |
1000 |
3 |
10/2 |
100 |
7 |
11/2 |
100 |
33 |
12/2 |
100 |
4 |
|||
|
Ļ |
500 |
3 |
|
Ļ |
500 |
33 |
|
Ļ |
500 |
5 |
10/3 |
330 |
6 |
11/3 |
330 |
22 |
12/3 |
330 |
6 |
|||
|
330 |
4 |
|
330 |
66 |
|
330 |
7 |
|||
10/4 |
200 |
8 |
11/4 |
200 |
66 |
12/4 |
200 |
8 |
|||
|
50 |
9 |
|
50 |
3 |
|
50 |
9 |
|||
10/5 |
400 |
2 |
11/5 |
400 |
3 |
12/5 |
400 |
10 |
|||
|
찳 |
50 |
5 |
|
찳 |
50 |
5 |
|
찳 |
50 |
11 |
10/6 |
Ե |
800 |
6 |
11/6 |
Ե |
800 |
6 |
12/6 |
1500 |
12 |
|
|
1500 |
3 |
|
1500 |
67 |
|
Ե |
800 |
13 |
||
10/7 |
å |
250 |
7 |
11/7 |
å |
250 |
5 |
12/7 |
å |
250 |
14 |
|
500 |
1 |
|
500 |
6 |
|
500 |
33 |
|||
10/8 |
330 |
8 |
11/8 |
330 |
7 |
12/8 |
330 |
15 |
|||
|
dz |
100 |
3 |
|
dz |
100 |
3 |
|
dz |
100 |
13 |
10/9 |
ũ |
500 |
2 |
11/9 |
ũ |
500 |
2 |
12/9 |
ũ |
500 |
33 |
|
A4 |
18000 |
1 box |
|
A4 |
18000 |
77 |
|
A4 |
18000 |
33 |
10/10 |
500 |
1 |
11/10 |
500 |
33 |
12/10 |
500 |
22 |
|||
|
丶 |
200 |
1 |
|
丶 |
200 |
121 |
|
丶 |
200 |
55 |
10/11 |
8000 |
1 box |
11/11 |
8000 |
44 |
12/11 |
8000 |
66 |
|||
|
ġ |
4000 |
1 |
|
ġ |
4000 |
22 |
|
ġ |
4000 |
66 |
10/12 |
1000 |
5 |
11/12 |
1000 |
44 |
12/12 |
1000 |
77 |
|||
|
ڱ |
350 |
50 |
|
ڱ |
350 |
33 |
|
ڱ |
350 |
88 |
10/13 |
500 |
30 |
11/13 |
500 |
22 |
12/13 |
500 |
34 |
|||
|
400 |
50 |
|
400 |
11 |
|
400 |
33 |
|||
10/14 |
丶꽺 |
900 |
50 |
11/14 |
丶꽺 |
900 |
11 |
12/14 |
丶꽺 |
900 |
6 |
10/15 |
500 |
4 |
11/15 |
500 |
55 |
12/15 |
500 |
4 |
|||
|
ǻ |
200 |
6 |
|
ǻ |
200 |
5 |
|
ǻ |
200 |
7 |
10/16 |
¥ |
330 |
6 |
11/16 |
¥ |
330 |
3 |
12/16 |
¥ |
330 |
8 |
|
|
500 |
9 |
|
|
500 |
2 |
|
|
500 |
8 |
10/17 |
B3 |
2000 |
2 |
11/17 |
B3 |
2000 |
6 |
12/17 |
B3 |
2000 |
4 |
|
file ö |
2800 |
5 |
|
file ö |
2800 |
7 |
|
file ö |
2800 |
5 |
10/18 |
500 |
3 |
11/18 |
500 |
3 |
12/18 |
500 |
4 |
|||
|
8000 |
2 |
|
8000 |
7 |
|
8000 |
2 |
|||
10/19 |
å |
2500 |
5 |
11/19 |
å |
2500 |
4 |
12/19 |
å |
2500 |
1 |
|
Ŷ |
500 |
6 |
|
Ÿ |
500 |
66 |
|
Ŷ |
500 |
77 |
10/20 |
|
1500 |
7 |
11/20 |
|
1500 |
44 |
12/20 |
|
1500 |
57 |
|
400 |
3 |
|
ɾ |
400 |
44 |
|
400 |
46 |
||
10/21 |
̽ũ |
500 |
8 |
11/21 |
̽ũ |
500 |
44 |
12/21 |
̽ũ |
500 |
55 |
|
Ĩ |
500 |
4 |
|
Ĩ |
500 |
55 |
|
Ĩ |
500 |
33 |
10/22 |
1500 |
5 |
11/22 |
1500 |
4 |
12/22 |
1500 |
22 |
|||
|
å |
250 |
3 |
|
å |
250 |
6 |
|
å |
250 |
22 |
10/23 |
A4 |
18000 |
1 box |
11/23 |
A4 |
18000 |
6 |
12/23 |
A4 |
18000 |
33 |
|
disket |
5000 |
1 box |
|
disket |
5000 |
2 |
|
disket |
5000 |
77 |
10/24 |
1000 |
3 |
11/24 |
1000 |
1 |
12/24 |
1000 |
77 |
|||
|
|
1500 |
5 |
|
|
1500 |
5 |
|
|
1500 |
99 |
10/25 |
ġĵ |
2500 |
6 |
11/25 |
ġĵ |
2500 |
66 |
12/25 |
ġĵ |
2500 |
54 |
|
¥ |
500 |
4 |
|
¥ |
500 |
44 |
|
¥ |
500 |
34 |
10/26 |
dz |
100 |
20 |
11/26 |
dz |
100 |
55 |
12/26 |
dz |
100 |
22 |
|
å |
250 |
60 |
|
å |
250 |
22 |
|
å |
250 |
34 |
10/27 |
500 |
40 |
11/27 |
500 |
46 |
12/27 |
500 |
55 |
|||
|
찳 |
100 |
50 |
|
찳 |
100 |
56 |
|
찳 |
100 |
66 |
10/28 |
̴ |
900 |
30 |
11/28 |
̴ |
900 |
33 |
12/28 |
̴ |
900 |
66 |
|
ݶ |
600 |
40 |
|
ݶ |
600 |
3 |
|
ݶ |
600 |
77 |
10/29 |
1500 |
20 |
11/29 |
1500 |
6 |
12/29 |
1500 |
77 |
|||
|
ȯŸ |
800 |
50 |
|
ȯŸ |
800 |
7 |
|
ȯŸ |
800 |
77 |
10/30 |
500 |
20 |
11/30 |
500 |
6 |
12/30 |
500 |
88 |
|||
|
å |
2500 |
50 |
|
å |
2500 |
77 |
|
ý |
2500 |
33 |
10/31 |
ǻ |
100 |
300 |
|
ǻ |
100 |
1 |
12/31 |
ǻ |
100 |
33 |
|
ݶ |
600 |
800 |
|
ݶ |
600 |
23 |
|
ݶ |
600 |
55 |
4
ǻ ٴϴ л 輺ǥ
ǻ
뱤ȣ 50 40
μ 100 60
ΰ 60 90
翵 80 50
â 70 60
1: ϰ graph
2. Ͽ Ÿ
3. 80 ̻ ĽѶ