1. Excel (C) Hiroshi Pen Fujimori 1 2. (Excel)
2.1 Excel : 2.2Excel Excel (C) Hiroshi Pen Fujimori 2
256 (IV) :C (C 65536 B4 :2 (2 A3 Excel (C) Hiroshi Pen Fujimori 3
Tips: (1) B3 (2) (*1) (3) (4)Word [Enter] * Excel (C) Hiroshi Pen Fujimori 4
3. (Excel) Excel (C) Hiroshi Pen Fujimori 5
2 (1) B C (2) (3) A 3 Excel (C) Hiroshi Pen Fujimori 6
Tips: 4 5 Excel (C) Hiroshi Pen Fujimori 7
6 Excel (C) Hiroshi Pen Fujimori 8
Excel (C) Hiroshi Pen Fujimori 9
l (C) Hiroshi Pen Fujimori 10 Exce
8 Excel (C) Hiroshi Pen Fujimori 11
9:Excel A Excel (C) Hiroshi Pen Fujimori 12
B C : Excel (C) Hiroshi Pen Fujimori 13
4. Excel (C) Hiroshi Pen Fujimori 14
=A3*4+B5 Excel (C) Hiroshi Pen Fujimori 15
!: 5. Excel (C) Hiroshi Pen Fujimori 16
4 5 D Excel (C) Hiroshi Pen Fujimori 17
E F 6. ( Excel (C) Hiroshi Pen Fujimori 18
6-1 ( G Excel (C) Hiroshi Pen Fujimori 19
H 6-2 6-3 Excel (C) Hiroshi Pen Fujimori 20
(1) 1 2 3Ctrl (1a) (a) (b) (c) (d) (2) (a) 4 Excel (C) Hiroshi Pen Fujimori 21
(b) 5 (c) 6 4 5 6 (3) Excel (b) Ctrl (1) (1b) Excel (C) Hiroshi Pen Fujimori 22
(a) (b) (c) (4) (3) Excel A1 1 A2 10 A1 A2 (3) A10 A3 19, A4 28,.. 1, 10, 100 I 1, 2, 3,, 1-1, 1-2, 1-3, 2-1, 2-2, 2-3 ( ) 1, 2, 3, 4, 5 1, 3, 5, 7, 9 1, 2, 4, 8, 16 1519, 2024, 2529 7. Excel TRUE FALSE Excel Excel (C) Hiroshi Pen Fujimori 23
7-1 = ( ) = Excel A11A22 A3=A1+A2, A4A1+A2 A3 A4 7-2 A1 A B C 1 3 5 =A1+B1 2 6 4 C1 C2. A B C 1 3 5 =A1+B1 2 6 4 =A2+B2 A1 A2 B1 B2 A B 1 100 =A1/A3 2 500 =A2/A3 3 =SUM(A1:A2) B1 B2 B1 B2 B1 2 A3 B2 A4 A B 1 100 =A1/A3 2 500 =A2/A4 3 =SUM(A1:A2) A B 1 100 =A1/A$3 2 500 =A2/A$3 3 =SUM(A1:A2) Excel (C) Hiroshi Pen Fujimori 24
$ 3 OK A $A$3 2 $A$1 $ $ F4 F4 $A$1 A$1 $A1 A1 A$1 $ $ $A1 $A2, $A3,. $A1 B1, C1 J HOGO.XLS 1. 2. 3. 1 2 7-3 7 7 Excel (C) Hiroshi Pen Fujimori 25
SUM IF IF(, TRUE, FALSE ) Pascal if then TRUE else FALSE ; TRUE FALSE IF IF Pascal =IF(A1 >= 60,, ) A1 60 60 =IF(A1 >=80, A, IF(A1>=70, B, IF(A1>=60, C, D ))) A1 A, B, C, D K 1. =IF(A1 >=80, A, IF(A1>=70, B, IF(A1>=60, C, D ))) 2. HOGO.XLS average() Excel (C) Hiroshi Pen Fujimori 26