i I Excel iii Excel Excel Excel

Size: px
Start display at page:

Download "i I Excel iii Excel Excel Excel"

Transcription

1 Excel

2 i I Excel iii Excel Excel Excel Excel

3 (SUM ) (AVERAGE ) (RANK ) (IF ) (VLOOKUP ) (VLOOKUP ) (MATCH ) (IFERROR ) (RANDBETWEEN ) (COUNTIF ) (COUNTIFS ) ii

4 I Excel

5 1 1 Excel 1 2 ([Ctrl]) [Ctrl] windowsos : Esc F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 [Ctrl] + c [Ctrl] + a [Ctrl] + x [Ctrl] + v [Ctrl] + z [Ctrl] + s [Ctrl] + p Excel Excel ( ) ) F8 ) Excel Excel Word ( )

6 2 2 Excel Excel Microsoft Office Microsoft Office Excel Excel Microsoft Office Excel 2010 ( ) 2.1: Windows 7 2.2: 2.3: 2.2 Excel Excel 2.4 Excel Sheet( ) Book( ) Sheet A,B,C,... 1,2,3,... A1 Book1.xlsx 1 (Sheet1,Sheet2,Sheet3) 1 Excel2010.xslx

7 2.4: Excel ➀ ➁ / ➂ / ➃ ➄ ➃ ➄ ➅ A,...,Z,AA,...,AZ,BA,...,BZ,CA,...,XFA,...,XFD 16, ,048,576 Ctrl A1 ➆ Book Sheet

8 ➇ ➈ ➉ 2.3 Excel Excel 2.5 Excel 2.5: Excel ( ) 2.4 Excel USB Excel :

9 ˆ 2.6 ˆ ˆ Excel xlsx PDF Excel2003 Excel xls 2.7: 2.1: ( )? : < >

10 6 3 Excel Excel 3.1 Excel 3.1 OK : 3.2 Excel sheet1 sheet2 sheet3 1. sheet1 3.4 Sheet1 ( ) Sheet4 2.

11 3.2: 3.3: 3.4: 3.5:

12 Sheet2 3.6: Sheet : OK OK 3.8 Sheet2 Sheet4 3.3 Sheet1 Sheet2 3.9 Sheet BackSpace Delete

13 3.8: Sheet2 Sheet4 3.9: Sheet2 3.10:

14 3.4 Excel 1. Shift 3.11 A1 C3 3.11: (A1 C3 ) 2. Ctrl 3.12:

15 3.5 Excel A1 A Enter Tab 3.13: Tab 3.14:

16 / : /12/14 15:53 Excel ( 1 24 ) ( ) 3.15: : Enter Shift + Enter Tab Shift + Tab Excel 13.5 (18 ) 8.38 (72 ) mm mm 8.38 MS P

17 3.16: 3.16 A1 abcdefghijklmnopqrst A1 B2 A 3.17 A B ) 3.17: J J1

18 ➀ : ➁ ➂ 3.19: J

19 % % :

20 3.7.4 Delete ( ) :

21 Excel Excel 2,4,6,8 A1 A11 1,2,3,,10,11 1 ( ) 1. (a) 1 (a) A1 A2 2 (b) A1 A2 (c) A2 ( ) (d) A11 (e) : A1 1 A11 (a) A1 (b) A1 (c) A11 (d) 1 (e) (f) : 1 11

22 2. 1 A : 3.25: 3.26: A1 1 A2 2 A1 A OK A A ( 2/21) ) A1 1 3/ A

23 3.27: 3.9 A B C D E 1 10 Excel 3.28: A B C D E 1 10 Ctrl + z )

24 3.29: Excel A B B : C 3.32

25 3.31: C C 3.32: C5 C

26 3.33:

27 C Excel 1. ) - / ˆ 2. = >= > <= < <> 3. 2 ( ) =A1& ABC A1 ABC

28 4. :, A1:C3 A1,A2,A3,B1,B2,B3,C1,C2,C3 A1:C2,E1:F2 A1,A2,B1,B2,C1,C2,E1,E2,F1,F = () ) 3.34 A1 =1+(6-3)*2 Enter : A A1 2 B1 5 ( ) C1 C1 =A1*B : C1 =A1 B A1 B1

29 3.36: C1 = A :

30 3.12 Excel Ctrl + c Ctrl + v A1 Ctrl + c A2 Ctrl + v 2 A A1 B1 Ctrl + c A3 Ctrl + v A3 B : A1 B1 B A1 B1 Ctrl + c A5 D8 Ctrl + v ( 2 4 ) 3.39: A1 B1 A5 D C1 C2 C C2 [ ] C1 Ctrl + c C3 Ctrl + v

31 3.40: C1 C C3 [ ] C1 C3 Ctrl + v C1 Ctrl + c C : C1 C C2 C3 [ ] C1 Ctrl + c 3.42 C2 C3 Ctrl + v 3.42: C1 C2 C3 4. C2 C3 [ ] C1 C3 C1 C2 C3 C1 10 =A1*B1

32 3.43: C1 C C2 C3 C2 C2 A2 B2 =A2*B2 0 ( B2 0 ) Excel C1 C1 [ESC] D3 =A1 B : A1 D C

33 3.45: C1 D3

34 3.13 5%(0.05) 3.46: =B2*C2 D2 D D3 D : D2 D3 D4 D2 D3 D D4 D4 2 (3) (90) =B4+C E2 5% 5% F2 5% 0.05

35 =D2*(1+F2)...( =D2 + D2*F E2 E3 E4 3.48: E2 E3 E4 E2 1 E3 E3 1 (280) (0) 280[=280*(1+0)] E3 F2 $ 1 F2 E2 =D2*(1+$F$2) E3 E4 3.49: E E2

36 E2 ( ) 3 4 F4 3.2: F4 F4 ( ) 1 $A$1 2 A$1 ( ) 3 $A1 ( ) 4 A Excel 3.50 = = ( ) 3.50: f x

37 3.51: 3.52:

38 : 3.54 E2 E4 E7 E9 3.54: E2 E4 E7 E E7 E9 E7 =D2*(1+F2) E2 3.55: E2 E4 E7 E F2 G3 E2

39 =D2*(1+G3) Excel 3.56: F2 G3 E : A1 E4 ( ) 3.58

40 . 3.58: A1 E4

41 37 4 Excel Sheet1. 4.1: 1. A1 A1 L1 ( ) 2. A A2 L2 ( ) A A A xlsx.xlsx Excel Sheet1

42 4.2: 4.2 (SUM ) 7 5 ( ) H3 = =C3+D3+E3+F3 ( H3 = C3 + ) Excel ( ) SUM 1. H3 =SUM(C3:G3) Enter C3:G3 =SUM( C3 G3 2. H3 H3 =SUM(C3:G3) (3.14 ) 3. C3 G3 (➀) (➁) H3 (➂)

43 4.3: C3 G3 H3, H3 H3 5 H3 H9 H3 H10 4. H3 H9 4.4: H3 H9 H3 H9

44 4.3 (AVERAGE ) AVERAGE [ ] =AVERAGE(C3:G3) I3 =AVER- AGE(C3:H3) 4.6 I3 Enter C3 G3 I4 I9 I3 4.5: I3 C3 H3 4.6: I3 C3 H3 C3 G3 [ ] 1 C10 =AVERAGE(C3:C9) 4.7

45 4.7: I3 I9 Ctrl C10 G : 4.9: :

46 4.5 (RANK ) RANK 4.11 J3 f x 4.11: J3 f x 4.12 RANK OK 4.12: RANK RANK =RANK (,, )

47 0 0 ( 1 ) 4.13: RANK 4.13 J3 =RANK(I3,I3:I9,0) J4 J9 J6 [ ] [ ] J6 ) [ ] I3:I9 J3 =RANK(I3,$I$3:$I$9,0) J3 4.15

48 4.14: J3 J4 J9 J6 4.15: J3

49 4.6 (IF ) K3 60 K3 K9 IF =IF (,, ) [TRUE] [FALSE] 4.17 K3 =IF(I3>=60,, ) ( I3 60 K3 ) : IF K4 K9 4.17

50 4.17: K3 K9 4.7 (VLOOKUP ) $ $ A E 5 L 0 60 E D C B 90 A VLOOKUP VLOOKUP =VLOOKUP (,,, [ ] ) [ ] 2 TRUE(1, ) FALSE(0) Excel 4.18 N2 O7 L3 =VLOOKUP(I3, $N$3:$O$7, 2, 1) I3 N3:O7 N 1 I O6 B L3

51 VLOOKUP 1. (N ) : N2 O7 RANK N3:O K4 K : K3 K9 4.20: L3 L9 5

52 : C3 G :

53 4.23: (VLOOKUP ) Sheet1 Sheet2 Sheet : B3 A5 K5 Sheet1 VLOOKUP A5 VLOOKUP 1. B3 ) 2. Sheet1!A3:L A5 =VLOOKUP(B3, Sheet1!A2:L9, 2, 0) (1) 4.26 #N/A A5

54 4.25: VLOOKUP 4.26: B3 A5

55 VLOOKUP A5 B3 Sheet1!A2:L9 2 B3 Sheet1!A2:L9 A5 =VLOOKUP($B$3, Sheet1!$A$2:$L$9, 2, 0) (2) B5 K : A5 B5 K5 (2) B5 K : A5 B5 K (MATCH ) (4.9) Sheet1!$A$2:$L$ MATCH MATCH =MATCH (,, [ ] )

56 [ ] 0 1, Sheet1!$A$2:$L$2 MATCH A7 =MATCH( A4, Sheet1!$A$2:$L$2, 0) A : A7 ( A4) Sheet1!$A$2:$L$2 A5 =VLOOKUP($B$3, Sheet1!$A$2:$L$9, MATCH( A4, Sheet1!$A$2$L$2, 0 ), 0) A5 B5 K5 4.30: A5 VLOOKUP MATCH 4.11 (IFERROR ) 4.31 #N/A IFERROR IFERROR

57 4.31: A5 VLOOKUP MATCH =IFERROR (, ) A5 =IFERROR ( VLOOKUP($B$3, Sheet1!$A$2:$L$9, MATCH( A4, Sheet1!$A$2:$L$2, 0 ), 0), ) VLOOKUP ) #N/A A5 VLOOKUP B5 =IFERROR (VLOOKUP($B$3, Sheet1!$A$2:$L$9, MATCH( B4, Sheet1!$A$2:$L$2, 0 ), 0), ) A5 ) K : A5 B5

58 Sheet1 A2 L A2 L9 4.33: A2 L9 : ( ) : =Sheet!$A$2:$L$9 A5 =IFERROR ( VLOOKUP($B$3,, MATCH( A4, Sheet1!$A$2$L$2, 0 ), 0), ) B5 ( A3 A9) 1. Sheet1 A3 A9 2. B3

59 4.34: A3 A = 4.36 B3 4.35: B3 4.36: B

60 4.37:

61 B2 G9 2-D 4.38: 4.39:

62 C D 4.40 / : 4.41:

63 ( ) 4.42: 4.43: 100

64 B2 G Ctrl B7 G D 4.44: 4.45: Ctrl 1. 2.

65 4.46: 4.47:

66 4.48: 4.49:

67 : : 1. A B3 1 F3

68 5.1 (RANDBETWEEN ) 4 1,2,3, Excel RANDBETWEEN =RANDBETWEEN (, ) 1 B4 =RANDBETWEEN( 1, B$1) $ 5.2 B4 F4 B4 F : B4 F13 B4 F B4 ( ) (COUNTIF ) 5.4 A16 F COUNTIF

69 5.3: B4 F13 5.4: A16 F24

70 =COUNTIF (, ) B18 =COUNTIF ( B4:B13, 1 ) 5.5 B18 5.5: B18 C18 B19 C18 C4:C13 1 B19 2 B5:B14 1 B4:B13 C4:C13 1 B4:B13 B5 B14 2 B$4:B$13 A18 A19 1,2,... A18 $A18 B18

71 =COUNTIF ( B$4:B$13, $A18 ) 5.6 B26 F26 5.6: B (COUNTIFS ) 4 COUNTIFS =COUNTIFS ( 1, 1, 2, 2,... ) COUNTIF :

72 K20 =COUNTIFS ( C4:C13, K19, F4:F13, J20 ) (1) C4 C13 1 ( K19) 5 F4 F13 1 ( J20) 5.8 f x 5.8: COUNTIFS (1) K21 L20 =COUNTIFS ( $C$4:$C$13, K$19, $F$4:$F$13, $J20 ) (2) : COUNTIFS

73 Excel A1 1 ˆ ˆ : 6.2:

74 6.3: :

75 6.5: ( 6.7) ( 6.10)

76 6.6: 6.7: S 6.8:

77 6.9: 6.10:

Excel97関数編

Excel97関数編 Excel97 SUM Microsoft Excel 97... 1... 1... 1... 2... 3... 3... 4... 5... 6... 6... 7 SUM... 8... 11 Microsoft Excel 97 AVERAGE MIN MAX SUM IF 2 RANK TODAY ROUND COUNT INT VLOOKUP 1/15 Excel A B C A B

More information

h16マスターセンター報告書(神奈川県支部)

h16マスターセンター報告書(神奈川県支部) ( / 36 16 /16 /16 /16 /100 [ ] % [ ] [ ] [ ] [ ][ ] 5 ➀ ➁ ➂ ➀ ➀ ➁ ➀ ➁ ➀ ➀ ➁ ➂ ➀ ➂ ➀ ➁ ➂ ➀ ➁ ➂ ➀ ➂ ➀ ➁ ➂ ➀ ➂ ➀ ➀ ➁ ➂ ➀ ➁ ➂ ➀ ➁ ➂ ➀ ➂ ➀ ➂ ➀ ➁ ➂ ➃ ➀ ➁ ➂ ➀ ➁ ➀

More information

マリモの育て方

マリモの育て方 2 3 (2011 7 ) ( ) 1.2 4 ( 2.4.4 ) (URL: http://marimo-inner.seesaa.net/) 5 ) 6 3 1 8 1.1........................ 8 1.2.............. 10 2 12 2.1.................... 12 2.2............. 13 2.3........................

More information

Excel IT-Excel2007_dl.zip IT-Excel2007_dl IT-Excel2007_koushi.zip IT- Excel 2007_koushi _ _ Windows XP IT-Excel2007_dl Windows XP IT- Excel 200

Excel IT-Excel2007_dl.zip IT-Excel2007_dl IT-Excel2007_koushi.zip IT- Excel 2007_koushi _ _ Windows XP IT-Excel2007_dl Windows XP IT- Excel 200 Excel 2007 Excel 2007 Office Professional 2007 1 90 Web http://softpress.nikkeibp.co.jp/ "BP " 6 1 Excel 2007 2 IT-Excel2007_dl.zip IT-Excel2007_dl IT-Excel2007_koushi.zip IT- Excel 2007_koushi _ _ Windows

More information

3 4 6 10 11 14 16 19

3 4 6 10 11 14 16 19 PowerPoint2007 3 4 6 10 11 14 16 19 PowerPoint PowerPoint PowerPoint 1 PowerPoint 1 1 2 3 4 5 2 [ ] 3 4 8 1 2 3 5 2 6 1 7 8 Office PowerPoint 2007 9 10 2 3 11 6 12 Ctrl 2 Shift 2 5 2 Shift 5 2 Delete 13

More information

OFISTAR S3100取扱説明書

OFISTAR S3100取扱説明書 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 1 7 2 4 3 0 6 4 1 2 5 3 24 1 2 3 1 2 3 25 1 2 3 6 7 8 9 26 27 1 2 3 4 5 28 29 ABC 30 31 32 : : 33 1 8 2 1 3 1 2 3 4 34 1 2 35 1 1 36 1 2 3a 3b

More information

dynabookガイド

dynabookガイド 1 2 3 4 5 6 7 8 9 10 11 14 15 16 17 18 19 20 21 22 23 SHIFT SHIFT 24 25 SHIFT SHIFT 26 27 28 29 D Y N A B O O K BACKSPACE DEL 30 31 32 33 34 35 36 37 ENTER SHIFT SHIFT 38 39 40 41 FN F8 FN F8 42 43 ENTER

More information

MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2

MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2 ( ) MS-Excel 1 MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2 MS-Excel : [Ctrl+s] [Office ] [ ] : [F12] [Office ] [ ] : 3

More information

MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2

MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2 ( ) MS-Excel 1 MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2 MS-Excel : [Ctrl+s] [Office ] [ ] : [F12] [Office ] [ ] : 3

More information

オンラインマニュアル

オンラインマニュアル 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 ENTER ENTER 20 F12 ENTER ENTER 21 FN F8 FN F8 22 FN F3 23 FN F4 24 25 26 27 28 FN F9 FN F9 FN F9 FN F9 FN F9 29 30 31 SHIFT SHIFT FN 32 33 FN FN ESC FN SPACE

More information

1981 i ii ➀ ➁ 61

1981 i ii ➀ ➁ 61 (autism) 1943 60 1981 i ii ➀ ➁ 61 DSM- 4 3 29 99 DSM- 62 1 2 3 4 4 vi 63 64 ix x xi 204 3 65 176 90 3 79 66 DSM- 82 67 68 ➀ ➁ ➂ 69 34 5 70 JR 71 i 1944 ii iii 28 72 iv 48 v ➀ vi PHP 39 vii 176 viii ➄ 77

More information

2 Excel =sum( ) =average( ) B15:D20 : $E$26 E26 $ =A26*$E$26 $ $E26 E$26 E$26 $G34 $ E26 F4

2 Excel =sum( ) =average( ) B15:D20 : $E$26 E26 $ =A26*$E$26 $ $E26 E$26 E$26 $G34 $ E26 F4 1234567 0.1234567 = 2 3 =2+3 =2-3 =2*3 =2/3 =2^3 1:^, 2:*/, 3:+- () =2+3*4 =(2+3)*4 =3*2^2 =(3*2)^2 =(3+6)^0.5 A12 =A12+B12 ( ) ( )0.4 ( 100)0.9 % 1 2 Excel =sum( ) =average( ) B15:D20 : $E$26 E26 $ =A26*$E$26

More information

1 Microsoft Office Power Point

1 Microsoft Office Power Point \n Title 情 報 教 育 におけるグループ 課 題 の 試 み Author(s) 五 月 女, 仁 子, Soutome, Hiroko Citation 商 経 論 叢, 48(3): 1-12 Date 2013-03-20 Type Departmental Bulletin Paper Rights publisher KANAGAWA University Repository

More information

(3) はがきの種類を選びます はがきの種類 を選択し 次へ (N) をク リックします (4) 縦書き / 横書き を指定 宛名を 縦書き にするか 横書き にする かを指定し 次へ (N) をクリックします (5) 書式を設定 宛名/ 差出人 のフォント 住所 の数字を漢数字で表示するかどうかを

(3) はがきの種類を選びます はがきの種類 を選択し 次へ (N) をク リックします (4) 縦書き / 横書き を指定 宛名を 縦書き にするか 横書き にする かを指定し 次へ (N) をクリックします (5) 書式を設定 宛名/ 差出人 のフォント 住所 の数字を漢数字で表示するかどうかを Microsoft Office を使って はがき宛名面 を印刷するには Word で はがき宛 名面印刷ウィザード を使って 住所録用のファイル (Excel 使用 ) を作成し 宛名 面のフォーマット (Word 使用 ) を作成し Word で印刷するのが便利です 注 : マウスでのクリック操作は ポイントして選択し シングルクリックで開く 方法を採用して記述しています ファイルが開かない方は

More information

FileMaker Pro Tutorial

FileMaker Pro Tutorial FileMaker Pro 11 2007-2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. FileMaker, Inc. FileMaker FileMaker, Inc.

More information

Excel 2007 Excel 2007 Excel 2007

Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel Excel Excel Book1 Sheet1 Excel Excel Excel 2002OSWindows XP Excel Excel Excel Excel Office Excel Excel Excel Excel Excel A A5 CtrlC B3 B3 B3 B3 Excel A1

More information

1 2 3 1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 % 23 24 25 26 27 28 29 30 31 32 33 34 35 4 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68

More information

Excel97関数編

Excel97関数編 Excel97 IF Microsoft Excel 97... 1... 1... 1... 2 IF... 3... 4... 4... 4... 4... 4... 5... 5... 5 IFG4C4... 5... 6 10... 6 11... 6 12... 6 13IFG4C4... 7 14... 7 15... 7 16... 7 17... 8 18... 8 19... 8

More information

dynabookガイド

dynabookガイド 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 20 21 22 23 24 25 26 SHIFT SHIFT 27 28 SHIFT SHIFT 29 30 31 32 D Y N A B O O K BACKSPACE DEL 33 34 35 36 37 38 39 40 ENTER SHIFT SHIFT 41 42 43 44 FN F8 FN

More information

Excel ではじめる数値解析 サンプルページ この本の定価 判型などは, 以下の URL からご覧いただけます. このサンプルページの内容は, 初版 1 刷発行時のものです.

Excel ではじめる数値解析 サンプルページ この本の定価 判型などは, 以下の URL からご覧いただけます.   このサンプルページの内容は, 初版 1 刷発行時のものです. Excel ではじめる数値解析 サンプルページ この本の定価 判型などは, 以下の URL からご覧いただけます. http://www.morikita.co.jp/books/mid/009631 このサンプルページの内容は, 初版 1 刷発行時のものです. Excel URL http://www.morikita.co.jp/books/mid/009631 i Microsoft Windows

More information

20090419-03t-a-PPT

20090419-03t-a-PPT 5 5.1 PowerPoint MagicPoint PowerPoint 5.2 5W1H 7 8 1 15 25 PowerPoint PowerPoint PowerPoint PowerPoint PowerPoint PowerPoint 5.3 (1) PowerPoint PowerPoint PowerPoint PowerPoint PowerPoint 5-1 5-1 command

More information

FileMaker Pro 8.5 Tutorial

FileMaker Pro 8.5 Tutorial 2004 2006 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker

More information

Excel基礎講座演習-表紙とはじめにv1.3.doc

Excel基礎講座演習-表紙とはじめにv1.3.doc Future Lifestyle Inc. IT Microsoft Excel 2000 Microsoft Microsoft Corporation B4 11 14 1999 1 C4 E7 C4 E7 2 =C4+D4+E4 SUM MAX MIN B3 F7 Sheet2 1999 2000 3 B3 F7 C4 F7 Delete C4 F7 SUM SUM() C4 SUM 4 B3

More information

1 3 4 4 6 7 8 9 11 11 12 CD 13 CD 14 15 18

1 3 4 4 6 7 8 9 11 11 12 CD 13 CD 14 15 18 Power Point 2007 1 3 4 4 6 7 8 9 11 11 12 CD 13 CD 14 15 18 8 15 1 bon_odori OK 2 3 4 OK 5 1 Windows Media Windows Video Microsoft Recorded TV Show Windows Media.asf.avi.mpg mpeg dvr-ms wmv 6 Word Excel

More information

43 IME Microsoft Office PowerPoint Microsoft Office Word Microsoft Office Excel

43 IME Microsoft Office PowerPoint Microsoft Office Word Microsoft Office Excel \n Title 情 報 教 育 の 受 講 生 における 入 力 の 調 査 Author(s) 五 月 女, 仁 子 ; Soutome, Hiroko Citation 商 経 論 叢, 48(2): 43-53 Date 2012-12-25 Type Departmental Bulletin Paper Rights publisher KANAGAWA University Repository

More information

... 4... 5 (FA )... 6... 6 A FA... 7... 7. FA... 8.... 9.... 10. FA... 11 B. FA... 12 C 3 ()... 13 FA... 13 FA... 14... 14 FA... 14 ()... 15... 16...

... 4... 5 (FA )... 6... 6 A FA... 7... 7. FA... 8.... 9.... 10. FA... 11 B. FA... 12 C 3 ()... 13 FA... 13 FA... 14... 14 FA... 14 ()... 15... 16... ... 4... 5 (FA )... 6... 6 A FA... 7... 7. FA... 8.... 9.... 10. FA... 11 B. FA... 12 C 3 ()... 13 FA... 13 FA... 14... 14 FA... 14 ()... 15... 16... 17 ()... 20... 20... 21... 22 D... 23 E ()... 23...

More information

untitled

untitled (N) FAX 256 20 10 20 10 Access X [ (N)] [OK] [ (A)] : ABC [ ] [ ] : [OK] (D) (V) / (H) [] : [Delete] Aa Ctrl CCtrl C (P) ... 0.423cm 0.423cm 0.423cm Ctrl C 0.423cm 0.556cm 0.423cm Ctrl V 0.556cm 0.423cm

More information

Plano-POS Ver1

Plano-POS Ver1 1 Quick Version2.0.0 Chapter1 Chapter1-1 Chapter2 Chapter2-1 Quick--------------------------------------------------------------P.7 -----------------------------------------------------------------------P.11

More information

はじめての帳票作成

はじめての帳票作成 ucosminexus EUR 3020-7-532 OS Windows Vista Windows XP P-26D2-5684 ucosminexus EUR Designer 08-00 P-26D2-5784 ucosminexus EUR Developer 08-00 ISO9001 TickIT Microsoft Microsoft Corp. Microsoft Excel Microsoft

More information

140 120 100 80 60 40 20 0 115 107 102 99 95 97 95 97 98 100 64 72 37 60 50 53 50 36 32 18 H18 H19 H20 H21 H22 H23 H24 H25 H26 H27 1 100 () 80 60 40 20 0 1 19 16 10 11 6 8 9 5 10 35 76 83 73 68 46 44 H11

More information

untitled

untitled Mail de ECO Professional ...1 EXCEL...2...3...4 EXCEL...6...7...8 EXCEL...9...10...11 EXCEL...12...13...14 EXCEL...16...21...23...25...33...34...37...38...40...44 EXCEL OK 1 EXCEL EXCEL MailDeEco No 1

More information

ワードプロセッシングについて

ワードプロセッシングについて Word Word ONOFF (U)(P) ******** 1 OS Windows2000 Windows2000 (U) OK 2 Windows 3 Word 1) 2) (F)(O) A() FD(A) Word 4 1) / > < *.? " : ; 2) SAMPLE2 A SAMPLE2 5 .doc 6 Alt f6f9 7 + 8 ) 2) 9 1) 2) 1) 10 2)

More information

<4D6963726F736F667420576F7264202D204850835483938376838B8379815B83578B6594BB2D834A836F815B82D082C88C60202E646F63>

<4D6963726F736F667420576F7264202D204850835483938376838B8379815B83578B6594BB2D834A836F815B82D082C88C60202E646F63> 例 題 で 学 ぶ Excel 統 計 入 門 第 2 版 サンプルページ この 本 の 定 価 判 型 などは, 以 下 の URL からご 覧 いただけます. http://www.morikita.co.jp/books/mid/084302 このサンプルページの 内 容 は, 第 2 版 発 行 当 時 のものです. i 2 9 2 Web 2 Excel Excel Excel 11 Excel

More information

untitled

untitled 1 1 Excel3 2008.8.19 2 3 10 1 () 4 40596079 2 OK 1 5 341 1 1 6 3-1 A134A135 B135 COUNTIF OK 3-1 7 3 B6B132 1 B135 COUNTIF) OK B6B132 8 2 3-1 3 3-1 3 1 2A133 A134 A135 3B133 SUBTOTAL 9 2 B5B131 OK 4SUBTOTAL

More information

untitled

untitled 1. Ver1.7(Macintosh )... 1 1-1... 1 1-2 Ver1.7... 1 1-3 Ver1.7... 1 1-4... 1 1-4-1... 1 1-4-2... 1 1-4-3... 1 1-5... 1 2... 3 3... 3 3-1... 3 3-2... 3 3-3... 3 3-4 Ver1.6... 3 4 /... 4 4-1... 4 4-2...

More information

FileMaker Pro 9 Tutorial

FileMaker Pro 9 Tutorial FileMaker Pro 10 2007-2009 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento Bento FileMaker, Inc. Mac Mac Apple Inc. FileMaker

More information

活用編

活用編 1 2 3 FN F6 FN F6 FN F7 FN F7 6 7 8 9 10 11 12 13 FN F5 FN F5 FN F5 FN ENTER 14 15 FN 3 FN 4 FN 3 FN 4 FN 3 FN 4 16 17 18 19 FN 3 FN 4 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

More information

橡Microsoft Word

橡Microsoft Word Microsoft Word (F) (X) 6 Word OK OK Enter 7 CenturyComic Sans MSCourier NewTimes New Roman 8 HG 13 5 15 MS 16pt 150% HG -PRO 9 1 Alt 1 Tab Alt 11 1532 12.235 233 411.26 16489 1356.2 12 13 6 1 1. 13 1,500

More information

1 (1) vs. (2) (2) (a)(c) (a) (b) (c) 31 2 (a) (b) (c) LENCHAR

1 (1) vs. (2) (2) (a)(c) (a) (b) (c) 31 2 (a) (b) (c) LENCHAR () 601 1 () 265 OK 36.11.16 20 604 266 601 30.4.5 (1) 91621 3037 (2) 20-12.2 20-13 (3) ex. 2540-64 - LENCHAR 1 (1) vs. (2) (2) 605 50.2.13 41.4.27 10 10 40.3.17 (a)(c) 2 1 10 (a) (b) (c) 31 2 (a) (b) (c)

More information

1 (1) (2)

1 (1) (2) 1 2 (1) (2) (3) 3-78 - 1 (1) (2) - 79 - i) ii) iii) (3) (4) (5) (6) - 80 - (7) (8) (9) (10) 2 (1) (2) (3) (4) i) - 81 - ii) (a) (b) 3 (1) (2) - 82 - - 83 - - 84 - - 85 - - 86 - (1) (2) (3) (4) (5) (6)

More information

- 2 -

- 2 - - 2 - - 3 - (1) (2) (3) (1) - 4 - ~ - 5 - (2) - 6 - (1) (1) - 7 - - 8 - (i) (ii) (iii) (ii) (iii) (ii) 10 - 9 - (3) - 10 - (3) - 11 - - 12 - (1) - 13 - - 14 - (2) - 15 - - 16 - (3) - 17 - - 18 - (4) -

More information

2 1980 8 4 4 4 4 4 3 4 2 4 4 2 4 6 0 0 6 4 2 4 1 2 2 1 4 4 4 2 3 3 3 4 3 4 4 4 4 2 5 5 2 4 4 4 0 3 3 0 9 10 10 9 1 1

2 1980 8 4 4 4 4 4 3 4 2 4 4 2 4 6 0 0 6 4 2 4 1 2 2 1 4 4 4 2 3 3 3 4 3 4 4 4 4 2 5 5 2 4 4 4 0 3 3 0 9 10 10 9 1 1 1 1979 6 24 3 4 4 4 4 3 4 4 2 3 4 4 6 0 0 6 2 4 4 4 3 0 0 3 3 3 4 3 2 4 3? 4 3 4 3 4 4 4 4 3 3 4 4 4 4 2 1 1 2 15 4 4 15 0 1 2 1980 8 4 4 4 4 4 3 4 2 4 4 2 4 6 0 0 6 4 2 4 1 2 2 1 4 4 4 2 3 3 3 4 3 4 4

More information

立ち読みページ

立ち読みページ 1 Word 1-1 33 1-2 45 1-3 54 1-4 Office Word 2007 66 1 1-1 1-1-1 33 Word FAX 1 1 2 1 Office Windows 7 Windows Vista Windows XP 3 4 5 6 34 2 Office Microsoft Office Online 35 1-1-2 1 2 3 4 5 6 2 1 1 36 37

More information

Microsoft Word - 204.1MSExcel2013

Microsoft Word - 204.1MSExcel2013 4.1 MS-Excel 2013 の 起 動 と 終 了 第 4 章 表 計 算 1.MS-Excel2013 の 起 動 (1)マウスの 左 ボタンでスタートボタンをクリックします (2)[すべてのプログラム] [Microsoft Office] [Microsoft Excel]の 順 にマウスをクリックすると MS-Excel 2013の 初 期 画 面 ( 図 4-1)が 開 かれます

More information

20090503-04t-Word

20090503-04t-Word Word (1) Word Word Word -1 Word Word Word Word Word -1 Word -2-2 (2) Word -3 Word 1 -3-1 2 3-1 Web Web SmartArt HTML (3) Command Z Command Word (4) Control J K L (5) USB USB USB TrueCrypt USB Word Word

More information