( ) MS-Excel 1
MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2
MS-Excel : [Ctrl+s] [Office ] [ ] : [F12] [Office ] [ ] : 3
Word Excel (User Interface) 4
CSV, Comma Separated Values (CSV) ( ) Excel ( ) 1 1 (item) 1 ( ) 1 5
( ) ( ) [ ] [ ][ ] ( ) 6
( ) http://pweb.cc.sophia.ac.jp /tsunogai/kougi/09/jolite.html kendata.csv [ ] [Save Link As...] O: 7
(Excel ) kendata.csv Excel (.xlsx) MS-Excel kendata.csv [ ] [Excel ] : A0nxxyyy-1130(.xlsx) ( - ) ([ ] [Ctrl+s]) 8
( ) 17 [ ] [ ] [ ][ ] ( ) ( ) 9
: [ ] [ ] : [Shift+ ] [ ] : [Shift+ ] : [Ctrl+ ] : (1,2, ) : (A,B, ) : [Ctrl+a] 10
( ) C2 C3 C49 C2 =SUM(C3:C49) SUM (function) 11
( ) : C2 =SUM(C3:C49) 12 D2 =SUM(D3:D49) C2 D2 OK ( ): [Ctrl+c] ( ): [Ctrl+v]? 12
( ) C2 =SUM(C3:C49) 1 47 D2 D2 1 47 =SUM(D3:D49) (D3 D49 ) 17 13
( ) 12 17 F2 =E2-D2 ( ) 17 14
( ) G (!!) G [ ][ ] [ ][ ][ ] ( [ ] ) 15
( ) G [ ][ ] [ ][ ][ ] ( [ ] ) 3, 16
!! 17
( ) ( ) 18
( )!! 19
? ( ) 20
( ) H3 =C3/C2!!? 21
H3 =C3/C2 H4 =C4/C2 H5 =C5/C2 C2!! H3 =C3/$C$2 ( ) 22
( % ) H3 =C3/$C$2 % G [ ][ ][ ] [ ][ ] ( [ ] ) 17 23
( ) G 1 G [ ] [ ] 17 5000( ) A B IF G3 =IF(E3>=5000,"A","B") ( " " ) 24
( ) IF : IF( P,xxx,yyy) P xxx yyy ( ) 25
(TRUE) (FALSE) (TRUE) = <> > < >= <= 26
( (TRUE) (FALSE)) (TRUE) (FALSE) ( ) AND(P 1,P 2,...) OR(P 1,P 2,...) NOT(P ) TRUE() FALSE() P i 1 P i P ( ) ( ) 27
( ) IF IF( 1,xxx,IF( 2,yyy,zzz)) 1 xxx 1 2 yyy 2 zzz (LOOKUP VLOOKUP ) 28
( ) G 17 5000( ) A 1000( ) 5000( ) B C G3 =IF(E3>=5000,"A", ) 29
( ) G 17 5000( ) A 1000( ) B C G3 =IF(E3>=5000,"A", ) 30
( ) 17 5000( ) G2 COUNTIF : COUNTIF(, ) G2 =COUNTIF(G3:G49,"A") ( ) 31
( ) ( C) 1 VLOOKUP : VLOOKUP(,,, ) 32
( ) Excel [ ] kendata.xlsx [ ] C3 =VLOOKUP(A3,,n,FALSE) : ( ) 1 n FALSE 33
: 1130 (!!) 1 MS-Excel A0nxxyyy-1130.xlsx ( - ) (!!) 34