4 1 4 : (1) (2) 1 (spread sheet) APPLE II 1 Microsoft Excel
2 2.1 Excel 2013 Excel 2013 4 2 1
4 3 2.2 1 A,B,C,... 1,2,3... F8 F8 G3 A1 F17 A,B,... 1,2,... 2.2.1 End 1
2.2.2 Excel + 2.2.3 (1) (2) Enter (3) Enter (1) (2) (3) F2 (4) Back space Delete (5) Enter 2004, 4 4
2.3 S1(10 GDP ) 2 10 2000 2013 GDP(US 10 US 2013 ) (2006 :International Monetary Fund, World Economic Outlook Database, October 2013) (S1.xlsx) 4 5 2 10 GDP( 10 US 2.4 Microsoft Word 3
4 6 2.5 2.5.1 (1) (2) (3) ( ) 1 (1) (2) Shift (3) 1
4 7 2.5.2 (1) 1 (2) Ctrl 2 2.5.3 (1) (2) Delete 2.5.4 Cut & Paste Excel Word Cut & Paste 2.5.5 (1) (2) :Excel ( )
3 4 8 GDP 3.1 B12 B2 B11 B12 B12 =B2+B3+B4+B5+B6+B7+B8+B9+B10+B11 = B12: =B2+B3+B4+B5+B6+B7+B8+B9+B10+B11 / G3 :Excel ( )
4 9 3.2 G4 G11 : (Copy and Paste)) (1) B12 (2) Ctrl + C ( (C) ) (3) C12 O12 (4) Ctrl + V ( (P) ) : ( )) (1) B12 (2) B12 + (3) + (O12) Ctrl + D Ctrl + R : B12 : C12:O12
4 10 1 * AVERAGE( ) MAX( / ( ) MEDIAN( ) MIN( PRODUCT( INT( ) ABS( ) STDEV( ) ( ) LOG( ) VAR( ) ( ) 3.3 B12 =B2+B3+B4+B5+B6+B7+B8+B9+B10+B11 :Excel ( )) B12: =SUM(B2:B11) (1) B12 =SUM( (2) B2 B11 B2 SHIFT B11 B2 B11 (3) ) Enter C12,D12,E12,F12
4 11 3.4 SUM 1 AVERAGE B13 (1) B13 (2) (3) (4) ( AVERAGE ) OK (5) 1 B2 B11 B2 B12 OK? HELP B13 B13: =AVERAGE(B2:B11) :Excel ( )
4 12 4 S1-1 S1 (1) P2 B2 O2 (2) P2 P3 P12 (3) Q2 B2 O2 (4) Q2 Q3 Q11 (5) population GDP 3 S1-1 ( 2014/06/02
4 13 5 4 4 N3 1821.445 5000 N12,N13,P3,Q5,P12 ( ) Ctrl z, (undo) :Excel
4 14 6 S2-1 (S2.xlsx) (1) 5 (2) 5 : (2014/02/20 ) 7 7.1, % (1) (2) (3) (4)
4 15 3 (,) (,) ( ) 1 10 1.23E04 1.23 10 04 = 12300 0 % 1 100% 0.01 1% 0.58 58% :Excel ( ) 7.2 7.2.1 :Excel (, ) 7.2.2 1 13 (1) 1 13 (2) (3)
:Excel (, ) 4 16 7.2.3 : 1 1 : :Excel ( ) 7.3 (1) (2) (3) (4) (5) OK :Excel ( ) Alt + Enter
7.4 (1) (2) (3) (4) OK 4 17 :Excel ( ) 7.5 (1) (2) (3) (4) (5) OK :Excel ( 1) ESC :Excel ( 2)
4 18 7.6 5 ( ) 8 S1-2,S2-2 S1,S2
4 19 9 S3-1 S3.xlsx( (1) G * (2) H 8% = 1.08 (3) N4:P4 2 101 (4) N5:P5 2 101 (5) µ ˆ µ ˆ µ ˆ µ ˆ µ 6
4 20 10 1,3,5,7,10 5 4,2,6,8,3,2,6 4 2 3,5,4,6 (4 + 5)/2 =4.5 1,2,4,5,1000 (3+4+5+8+1000)/5 = 204 4 6 5 100 1 ( F6 3 3 median N6 N6: =MEDIAN(F2:F101) O6 P6 11 S1-3 (1) S1.xlsx GDP R 2000 2013 (2) S1.xlsx population R 2000 2013
4 21 12 S4-1 7 (Ladies Moguls Final 3, (2014 4 )) (S4.xlsx) e e Ž Ž 7 5 2 2
4 22 e 8 ( alt + Enter ) 8 ( : ) 5 (USA, FRA, RUS, AUS, CZE) 3 5 H 4 H3 5 sum I3 5 max H3 C3 G3 J3 5 min K3 (H3) (I3) (J3)
4 23 e e Ž Ž 9 9 2 2 (FIN, CAN)) 2 1 = 1 FIN 1 + 1 CAN 1 2 1 2 = 1 +2 2
4 24 10 =18 12 =18 12 30.09 30.09 {} () 30.46 30.46 = + + 3 Alt Enter
13 ( ) 4 25 q l q l 11 11 2012 1980 2010 (15 15 65 65 (S5.xlsx)
4 26 š µ µ µ q l q l q l q l 12 1980 D E 7 1 (1) B1:E1 (2) E (1980 ) 1980 1980 = 1980 + 1980 + 1980 E3: =B3+C3+D3 : E3 : E4:E23 F (1980 ) 1980 = 1980 1980
F3: =B3/E3 4 27 G H 1 1 I ( 1 ) J ( 1 ) K ( 1 ) 1 = I3: =C3/B3 1 = 1 = : E3:K3 : E3:K23 ( + )
4 28 š µ µ µ q l q l q l q l 13 2010 13 2010 1980
q l q l 4 29 14 1980 2010 14 1980 2010 V ( ) = 2010 1980 W,X,Y ( ) ( 1980 ) ( 1980 ) = = = 1980 = 1=2010 1980 1 Z Z3: =V3 / B3 AA AC
4 30 14 GDP GDP GDP = GDP GDP 10 USD GDP 10 USD 100 = 1000USD/ 1000USD (1) GDPperCapita (2) GDP (3) B2 B2: =GDP!B2/population!B2 GDP!B2! (4) B2 (5) :Excel : B2 : B2:O11
4 31 15 15.1 GDP 14 GDP(GDP per Capita) 10 GDP 10 GDP 10 GDP 10 GDP GDP = 10 GDP 10 B12 2000 10 GDP 2000 10 GDP GDP B12 2000 10 population B12 B12: =GDP!B12/population!B12 : B12 : C12:O12 : GDP
4 32 15.2 GDP GDP ( ) 1 1 B13: =AVERAGE(B2:B11) : B13 : C13:O13 B13 Average B12 14 :
4 33 16 S1-4 (1) S1.xlsx GDPperCapita P2 Australia 14 (14 ) 1 GDP 14 1 GDP 14 1 GDP = 14 GDP 14 (2) P2 (P3:P11) (3) P12,P13,P14 14 10 O12,O13 O14 P12,P13,P14 GDP 12 (14 10 (12 ) 1 1 GDP
4 34 15 GDP
17 S2-3 (s2.xlsx) (1) (2) 4 35 = (3) GDP (2) 5 4 16
4 36 18 17 S1 2000 2013 13 = = 1 2000 2013 21.17% 13 21.17% 13=1.63% 1.63% 1.0163 13 1.0163 13 =1.1239 13 1.2117 (1) 2013 = 2000 =1.2117 (2) x 13 x 1.2117 x x 13 =1.2117 x = 13 1.2117 = 1.2117 1 13 =1.0149 1.0149 13 =1.2120 (3) 1.0149 1 1.0149 1=0.0149 = 1.49%
4 37 17 2000 2013 R2: =O2/B2 S2: =R2 (1/13) ( ) ) T2: =S2-1 : R2:T2 : R3:T12
4 38 19 S1-5 (1) population U W 2008 2013 (5 ) (2) GDP S U 2008 2013 (5 ) GDP (3) GDPperCapita Q S 2008 2013 (5 ) GDP 20 S2-4 (1) I W 2009 2013 (4 ) (2) I W 2009 2013 (4 )