2012/10/09 A/B -- Excel --
!! B video Note-PC Network skype Login Windows Update Web CST Portal
Excel Excel ( / ( / /? ( ( [ / /etc..], = ( Excel : (Excel : ( $ [ 1] Excel [ 2] [ 3]
Lookup [ 1] [ 2] Excel.. tool Excel
(2012/10/09 (2012/10/02 excel CST Portal : 20121009-QQQQ.xlsx (QQQQ : Excel sample-20121009.xlsx (2012/10/09 excel CST Portal : 20121009-QQQQ.xlsx (QQQQ : Excel sample-20121009.xlsx
( $ vs : : : ( ( cf. ( ( (Excel
/ / Excel B2,C2,D2 B1,C1,D1 Excel A B C D 1 111 111 111 111 2 222 111 222 111 Excel B1 111 111 111 ( B2 111 111 111 ( C1 111 =A1 :-2/ :0 C2 222 =A2 :-2/ :0 D1 111 =$A$1 A1
[ 1.1] : C3 F8 +3, +5 : D6 G11
[ 1.2] $ : C3 $F$8 F8 : D6 $F$8
[ 1.3] ( $ : C3 $F8 F 5 $ : D6 $F11 B4( B$4( $B4( $B$4(
[ 1.4] : B2:B8 : B2,B3,B4,B5,B6,B7,B8 ( B 2 8 F4:I4 : F4,G4,H4,I4 ( 2 F I C3:F5 : C3,D3,E3,F3,C4,D4,E4,F4,C5,D5,E5,F5! sheet1!c3 : sheet1 C3 sheet2!$f$7 : sheet2 $F$7
[ 2] Excel : SIN/COS/TAN, EXP/LOG, ABS, SQRT, PI, etc.. : SUM, AVERAGE, MEDIAN, MODE, etc..,,, : COUNT, COUNTIF, : LOOKUP, VLOOKUP : IF, AND, OR, NOT
[ 3] lookup lookup : VLOOKUP(, : ( HLOOKUP(, : ( lookup ( (x: y: =hlookup(4,$b$2:$i$3,2 16 ( 4 A B C D E F G H I 1 2 (x 1 2 3 4 5 6 7 8 3 (y 1 4 9 16 25 36 49 64 x y ( :.. (.. ( cf.
[ 4] : 2 x 2 4
[ 5] Excel Excel? Excel ( [Enter] ( i.e C6:E8 ( = { 1,2,3; 4,5,6; 7,8,9 } [Ctrl] + [Shift] + [Enter] ( [CSE] : [CSE] : =C6:E8+G6:I8 : MMULT =MMULT(C13:E15,G13:I15 : =$D$21*G20:I22 : MINVERSE =MINVERSE(C13:E15,G13:I15
[ 6] sample-20121009.xlsx 20121009-QQQQ.xlsx ( CST Portal [ ] sample (2012/10/02 (sample-20121009.xlsx
[ 7] Excel excel COUNTIF : HLOOKUP/VLOOKUP : SUM : SQRT : T i ([ ] wikipedia: T i = 10(x i µ x σ x +50 σ x 0 µ x = 1 N N x i, σ x = i=1 1 N N (x i µ x 2 i=1