5 1 5 (1) (2) (3) 1 Excel (Course Power (enq text.xlsx( )
5 2 2 Web PDF ) 44 GoogleDrive (),,,,,, 1, 1 1,,, ) 1,,, 1 1
5 3 3 1 1GoogleDrive 3
5 4 3.1 NO (1) allata (2)NO1 44 (3)enq= B2: =enq!b2 C2: =enq!c2 B2:C2 B3:C45 :: 3.2 Vlookup convt (1) vlookup ( 2) (2) D2: =VLOOKUP(enq!D3,convT!$B$2:$C$3,2,FALSE) D2 D2:D45 :
5 5 D2 convt!$b$2:$c$3 F4 ($) e µ µ µ µj µµ µj e µ µµµµ µµ µµµµµµ µµµµ µµ µµµµµ µµ µµµµµµ µµ µ µµ e m m mµµi µ i µ mµµµµµµµ µµ e z µµµµµµ µ µµµlµµµ 2 (convt) : E 2 3 F M
5 6 3.3 enq 0= 0 IF 2 N2: =IF(enq!N2=,,enq!N2) N2 N3:N45 3 3 ( alt + enter )
5 7 4 (1 ) 2 1 (A) (B) 4.1 31 A1:N45 allata B2 A1:N45 allata :
5 8 4.2 (1) allata ( A1:N45 ) (2) (3) OK (4) :
5 9 5 5.1 1 (1) alata ( A1:N45 ) (2) (3) OK (4) (5) 4 4 ::
5 10 (:) l l l el el l i Œ j l l el l µ el el el eel µj 5 (1) (5 ) (2) (5 ) B15: =B5 B15 B15:D18 B21: =B15/$D15 B21 B21:C24 B21 $ D D15 15 15 B22 B16/D16 15 16 1 $ (3) (5 )
5 11 5.2 5 15 (:) (1) allata ( A1:N45 ) (2) (3) 6
5 12 µµ µµ µ µ µ µ 7 3D (6) 2 3 2,3 67 0 3D 7 : () 7 7 4 51 2 4,5 1,2 2
6 6.1 5 13 : 8 8
5 14 9 89#DIV0 #DIV00 0 0 (1) 8 (2) (3) 88 :
5 15 10 6.2 9 21.6 1 100 Excel R2 O (10) O2: =IF(M2=$R$5,N2, ) O2 O3:O45
R2 R3 R6 R7 5 16 R2: =AVERAGE(N2:N45) R3: =MEDIAN(N2:N45) R6: =AVERAGE(O2:O45) R7: =MEDIAN(O2:O45) 6.3 6.4 (N ) Excel (1) allata N2:N45 (2) ( (3) () (4) A1:A44 (5) (6) OK A
5 17 6.5 100 10 25 4 25 025 2.5 10 0 2.5 2.5 5 2...22.5 25 10 25 11 ) (1) (A1:A37) (2) (3) (4) A6) 0 250000 25000 (5)
5 18 (6) (7) 0% :: 11 0 117.5 10 12.5 15 17.5 20 0 11 0 12 ( 12)
5 19 12 :: ()