1
BASIC (Beginner s All-purpose Symbolic Instruction Code) EXCEL BASIC EXCEL EXCEL VBA (Visual Basic for Applications) 2
3
1.1 Excel Excel Excel Check Point 1. 2. 1.1.1 Sheet1 A Sheet2 Sheet A A10 4
1 10 A1 : A10 Excel 10R1C Row Column 1 2 A D A2 : D2 B B : B 5
2 2 : 2 1.1.2 A1 $A$1 R1C1 R1C1 A1 R1C1 R[-2]C R[2]C[2] R2C2 R[-1] R 2 2 2 2 2 1 1. 2. 6
1.2 Check Point 1. 1.2.1 100 1 1 1.2.1 1.2.1 1.2.2 1. 1 10 2. 1.2.3 7
1.2.2 1 1.2.4 1.2.4 1.2.5 1.2.6 1. 8
1.2.7 1.2.8 1.2.9 1. 1 100 2. 0, 10, 20,, 360 9
1.3 Excel Check Point 1. 2. 1.3.1 + () 2 + 3 - () 1-5-20 * () 23 / () 1 / 10 ^ () 10 5 mod. 1 + 3. sin( 1.0 ). 10 ^ 5. - 2.5. 1 * 32 / 3. 5 3 Basic. 7 mod 2 Basic. 5 * 31 / 3 1 3 1 * 3 / 5 / 9 1 * 3 / (5*9) 5 9 1. 10^2*2/3 - (3+4)/2/3 10
A1 A4 1.3.1 1.3.1 B1 = A1*1.05 1.3.2 1.3.2 B1 1.3.3 1.3.3 1.3.4 A1 2000 1.3.5 1.3.4 1.3.5 1. 512 2 11
d dx e x = e x 1 1 0.1 1. 3.6 f(x) = e x B f(x) 1.3.7 B4 = EXP(A4) f(x) df ( x) f (x + dx) f (x) f (x + dx) f (x) = lim dx dx dx dx dx 1.3.7 C1 dx dx $C$1f(x) EXP(A4)f(x+dx)EXP(A4+$C$1) 1.3.6 C4 = ( EXP(A4+$C$1) - EXP(A4) ) / $C$1 1.3.8 dx C1 1.3.8 f(x) f(x) 1.3.7 1.3.8 12
1.3.2 y = sin(x) 1.3.9 1.3.10 pi( ) 72 72 180 x = π 72 180 ( ) pi( ) 3.14159 13
1.3.11 1. sin(x)sin(x) sin(x)sin(3x) 2. sin(x)cos(x) 14
1.3.3 A1 =rand() 1.3.12 Enter 0 A1 1 1.3.13 1.3.14 A1 1.3.15 1.3.12 1.3.13 1.3.14 1.3.15 1. INT( ) 15
10 SUM( ) 1.3.16 10 A11 = SUM(A1:A10) AVERAGE( ) = AVERAGE(A1:A10) STDEV( ) =STDEV(A1:A10) 1.3.16 1. 0.5 EXCEL 16
1.3.18 17
1.4 EXCEL Check Point 1. 1.4.1 1.4.1 1.4.2 1.4.3 I H 1.4.3 18
1.4.4 19
1.4.6 x360 1.4.7 X 20
1.4.2 1.4.9 21
1.4.11 1. 1.3.1 e x e x dx e x 2. sin(m) sin(n)m n 02 0 m = n 0 22
1.5 EXCEL Check Point 1. 2. 1.5.1 23
1.5.2 ln( y) ax E η e RT E x η e R ln( η) E x R 24
25
1.5.3 ln( y) a ln(x) 1. X 1.5.4 X t [cm] I [cps] I e µ t X 1.5.4 26