untitled

Size: px
Start display at page:

Download "untitled"

Transcription

1 Microsoft Excel VBA) A IV 256

2 BMI (Body Mass Index) AVERAGE,COUNTIF

3 BMI ( kg ) = 22 ( m) 2 BMI (Body Mass Index) BMI = ( kg ( m ) ) 2 BMI BMI 20 BMI BMI BMI 26.5

4 E1 kg Del Back Space Del Back Space E F

5 Enter E2 =22 C2 100 ^2 Enter

6 E2 E16 E2 E16

7 E F C OK BMI

8 A17 C17 N AVERAGE C2 C16 C2 C16 OK C F 1

9 A1 F17 D 1 2F

10 16 17F B17 E17 F17

11 A1 F A1 Center Zemi

12 A1 B1 F F M A1 B1 A2 F17D S 2 A

13 F O D F C A OK BMI

14 A21 A22 B20 B21 COUNTIF B3 B17 OK

15 (SUM) Excel 3 Sheet Sheet Sheet [BMI] [jinko] [jinko]

16 SUM C7 SUM (C4 C C4 C7 SUM(C4:C7) C4 C7 SUM(C4,C7 B1 J1

17 4 7 [ (C)]-[ ] [ (T)]-[ ] (N) (B3 (N)

18 [(T)] 7 [x/ (C)] [Y/ (V)] (N) (F) [ ] (N): OK

19 (O) [ ]- (W) OK (O) (F) MS P (O) (S) OK

20 C4/$C$8 / C4/C8 C5/C9 C6/C10 C4/$C$8

21 3-D [ (F)] - [(V)] [ (T)] [ C)]

22

橡マニュアル1999.PDF

橡マニュアル1999.PDF 11 11 7 28 7 30 9 30 16 30 2-302 1. (hardware) Microsoft Excel Microsoft Word Windows95/98 OS Windows95/98 MS-DOS 2. 3. 1 1 2 4. Enter CTRL ALT ALT SHIFT ESC BS DEL INS TAB CAPS 5. 1 ID ID 2 ID 3-1 - 6.Windows95/98

More information

スプレッドシートについて

スプレッドシートについて スプレッドシートについて 使用するアプリケーション Microsoft Excel スプレッドシートの特徴 1. 単純な計算から関数計算まで可能 2. データからグラフ作成が可能 3. データを蓄積してデータベースとして利用可能 4. マクロ言語 (VBA) でプログラムが作成可能 本日の講座内容 データ入力および 四則演算処理 データ入力 操作の応用 関数を使った計算処理 表の作成 ( 罫線の引き方

More information

消費データ付きアンケート作成マニュアル

消費データ付きアンケート作成マニュアル ... 3... 4... 4... 5... 6... 6... 7... 8... 9... 14... 16... 17... 20... 24... 24... 25... 25... 25... 26... 27... 28... 29... 33... 34... 35... 35... 36... 37... 38... 39... 40... 41... 42... 43... 44...

More information

消費データ付きアンケート作成マニュアル

消費データ付きアンケート作成マニュアル ... 3... 4... 4... 5... 6... 6... 7... 8... 9... 11... 15... 16... 18... 19... 22... 26... 26... 27... 27... 27... 28... 29... 30... 31... 35... 36... 37... 37... 38... 39... 40...41... 42... 43... 44...

More information

Word 2000 Standard

Word 2000 Standard .1.1 [ ]-[ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [OK] [ ] 1 .1.2 [ ]-[ ] [ ] [ ] [ [ ] [ ][ ] [ ] [ ] [ / ] [OK] [ ] [ ] [ ] [ ] 2 [OK] [ ] [ ] .2.1 [ ]-[ ] [F5] [ ] [ ] [] [ ] [ ] [ ] [ ] 4 ..1 [ ]-[ ] 5 ..2

More information

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

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

PowerPoint 2002

PowerPoint 2002 5.1.1 [ ] [ ] 5 1 5.1.2 [ ] 5 2 5.1.3 [ ] [ ] 5 3 5.1.4 [ ] [ ] [ ] 5 4 5.2.1 [ ] [ ] [ ] [ ] [ ] [] [OK] 5 5 5.2.2 [ ] [ ] [ ] [ ] [ ] [] [ ] [ ] [OK] [OK] 5 6 5.2.3 3-D 3-D [ ] [3-D] 3D 5 7 5.2.4 [Ctrl]

More information

Excel基礎講座テキスト-表紙と目次v1.3.doc

Excel基礎講座テキスト-表紙と目次v1.3.doc Future Lifestyle Inc. IT Microsoft Excel 2000 Microsoft Microsoft Corporation < > Excel Excel Microsoft Excel = 11 11 1 G11 1 < > Excel Word Excel Sheet1Sheet2Sheet3 OK Sheet2 Sheet3 2 Word Excel Book1.

More information

1 Power WX-Word WordPerfect EGWORD OASYS dp/note BeatWord Microsoft Word 1 12 8 0742 00 0000 FAX 0742 00 0001 1. 8 20 18 20 2. 3. 2,000 T E L F A X 2 Word Word Word Word Web Word 2 3 Word 4 [ ] 2 5 [Microsoft

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

untitled

untitled Excel A D-2 B-2 D-2 B2 C-2 D-2 C2-23 - Enter D-2 B2(1000) C2(5) 5000 D-2 (D-2) (D-2) (D-3) (D-6) - 24 - (D-3) (D-6) D (D-2) =B2*C2 (D-3) =B3*C3 (D-4) =B4*C4 Excel - 25 - $A$1 1000 A-1 (B-1) =$A$1 (B-1)

More information

技術・家庭科(家庭分野)学習指導案

技術・家庭科(家庭分野)学習指導案 Adobe Photoshop Elements2.0 Microsoft PowerPoint Microsoft Excel Adobe Photoshop Elements2.0 Microsoft PowerPoint Microsoft Excel FD Adobe Photoshop Elements2.0 Adobe Photoshop Elements2.0 color-zibun

More information

年計グラフ作成システム

年計グラフ作成システム 2003/01/20 2.00 1/29 2003/01/20...2...3...4...5...7...9... 11...13...15...16...17...18...19...20...21...23...24...26...27 FAQ...29 2/29 2003/01/20 Microsoft Access 2000 Microsoft Excel 3/29 2003/01/20

More information

BSE Excel

BSE Excel 200 2 200311110 BSE Excel 1 3 11 1 21 2 20 1 26 2203 2 10 1718 485 13 2 2 6 100 371 12 3 100 679 1 12 2 9 1 29 2 10 1 1-1 2 /kg 1-2 3 1-3 2 http://www.maff.go.jp/ 3 Excel 2 15 1 26 2 2 9 16 1 30 2 10 1-4

More information

i I Excel iii Excel Excel Excel

i I Excel iii Excel Excel Excel Excel i I Excel iii 1 1 2 Excel 2 2.1..................................... 2 2.2 Excel................................................ 2 2.3 Excel................................................ 4 2.4..............................................

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

<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

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

5.3 1. 2. 3. tert-tert 4. Enter 5. Delete 6. 7. Delete 8. Delete 9. [] [] 10. 11. 12. ID 40

5.3 1. 2. 3. tert-tert 4. Enter 5. Delete 6. 7. Delete 8. Delete 9. [] [] 10. 11. 12. ID 40 5 PowerPoint PowerPoint 2003 PowerPoint 2007 5.1 - tert- 1. 2. 3. 4. 5.2 PowerPoint 2007 PowerPoint 2007 Word 2007, Excel 2007 39 5.3 1. 2. 3. tert-tert 4. Enter 5. Delete 6. 7. Delete 8. Delete 9. []

More information

9 10 14 5 15 4 19 11 21 4 23 3 2012 24 11 24 5 24 6 27 2 447 52 395 27 2 1 2 3 4 5 6 7 8 9 10 11 12 (1) (2) (3) (4) 13 14 15 16 17 18 () 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

More information

情報科学概論 第1回資料

情報科学概論 第1回資料 1. Excel (C) Hiroshi Pen Fujimori 1 2. (Excel) 2.1 Excel : 2.2Excel Excel (C) Hiroshi Pen Fujimori 2 256 (IV) :C (C 65536 B4 :2 (2 A3 Excel (C) Hiroshi Pen Fujimori 3 Tips: (1) B3 (2) (*1) (3) (4)Word

More information

橡matufw

橡matufw 3 10 25 3 18 42 1 2 6 2001 8 22 3 03 36 3 4 A 2002 2001 1 1 2014 28 26 5 9 1990 2000 2000 12 2000 12 12 12 1999 88 5 2014 60 57 1996 30 25 205 0 4 120 1,5 A 1995 3 1990 30 6 2000 2004 2000 6 7 2001 5 2002

More information

O

O 11 2 1 2 1 1 2 1 80 2 160 3 4 17 257 1 2 1 2 3 3 1 2 138 1 1 170 O 3 5 1 5 6 139 1 A 5 2.5 A 1 A 1 1 3 20 5 A 81 87 67 A 140 11 12 2 1 1 1 12 22 1 10 1 13 A 2 3 2 6 1 B 2 B B B 1 2 B 100 B 10 B 3 3 B 1

More information

VISPO /表1-4

VISPO /表1-4 7 2005 1,132 5,249 362 13,666 311,809 1,359 3,723 1,669 538 3,737 17,418 39,036 75,694 5,281 1,169 161,502 7,463 11,408,436 500,000 13,263 192,052 41,391 49,706 136,232 61,102 12,402,182 11,573,898 273,042

More information

001 No.3/12 1 1 2 3 4 5 6 4 8 13 27 33 39 001 No.3/12 4 001 No.3/12 5 001 No.3/12 6 001 No.3/12 7 001 8 No.3/12 001 No.3/12 9 001 10 No.3/12 001 No.3/12 11 Index 1 2 3 14 18 21 001 No.3/12 14 001 No.3/12

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

16 41 17 22 12 10

16 41 17 22 12 10 1914 11 1897 99 16 41 17 22 12 10 11 10 18 11 2618 12 22 28 15 1912 13 191516 2,930 1914 5,100 43 1.25 11 14 25 34364511 7.54 191420 434849 72 191536 1739 17 1918 1915 60 1913 70 10 10 10 99.5 1898 19034.17.6

More information

製品案内 価格表 2014/4/1

製品案内 価格表 2014/4/1 4 (17) 3 43 5/20370/ 231(504,150) 11 12 10 14-16 10 3 100 17 100kg 5-6 3 13 3 18 18 # # # # #$$ %&$ ' ()* +,-% ' #). +,-%'% / ' # # #$ %&&&'( %)* +'(#$ #$ %&&&'( ++,-). +'(#$ #$ /'( + /0)- +'(#$ %&&&'(

More information

3.ごみの減量方法.PDF

3.ごみの減量方法.PDF - 7 - - 8 - - 9 - - 10 - - 11 - - 12 - ( 100 ( 100 - 13-123,550,846 111,195,762 92,663,135 ( 12 25 37 49.2 16 33 49 65.6 15 30 44 59.0 2.5kg) ( 5kg) ( 7.5kg) ( k ( 123,550,846 111,195,762 92,663,135 (

More information

CD-ROM Ver.1Ver

CD-ROM Ver.1Ver 1 1 2 6 3 6 1 8 2 8 3 8 4.. 9 5 10 6.. 10 7.. 10 8 11 9 CD-ROM 11 10 11 1 13 1-1.. 13 1-2.. 15 2.. 16 2-1 Ver.1Ver.2.. 16 2-2. 18 2-3.. 34 2-4.. 35 2-5 45 1 49 1-1... 49 1-2. 51 1-2-1. 51 1-2-2. 55 1-2-3

More information

2 2.1 Excel 2013 Excel

2 2.1 Excel 2013 Excel 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

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

10.5月号410~.xls

10.5月号410~.xls 1 2 3 4 60kg 5 1 ( ) 2 65 3 30 80 31 90 1 31 1 200 9 70 69 (3 ) 56 6 1 8 3 8 10 8 11 7 17 7 30 2 1 2 2 78 1 2 5 7 1 74 1 7 20 6 77 77 72 7 8 1 1 60 7 1 10 100 21 8 PL 26 24 58 25 26 60 2 52 51 1 46 51

More information

Microsoft Office PowerPoint 2007 セミナーテキスト基礎編 講習の手引き Microsoft Office PowerPoint 2007 Office Professional 2007 PowerPoint 2007 PowerPoint 2007 PowerPoi

Microsoft Office PowerPoint 2007 セミナーテキスト基礎編 講習の手引き Microsoft Office PowerPoint 2007 Office Professional 2007 PowerPoint 2007 PowerPoint 2007 PowerPoi Microsoft Office PowerPoint 2007 セミナーテキスト基礎編 講習の手引き Microsoft Office PowerPoint 2007 Office Professional 2007 PowerPoint 2007 PowerPoint 2007 PowerPoint 2007 PowerPoint PowerPoint 2003 PowerPoint 2007

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

Excel 2007 Excel 2007 "Excel " " " " Excel 2003 Excel 2007 " "" Excel Web ""

Excel 2007 Excel 2007 Excel     Excel 2003 Excel 2007   Excel Web Microsoft Office Excel 2007 Microsoft Office Excel 2007 Microsoft Office Excel 2007 Office Excel Office Excel Office Excel Excel 2007 Excel 2007 Excel 2007 "Excel " " " " Excel 2003 Excel 2007 " "" Excel

More information

...J......1803.QX

...J......1803.QX 5 7 9 11 13 15 17 19 21 23 45-1111 48-2314 1 I II 100,000 80,000 60,000 40,000 20,000 0 272,437 80,348 82,207 81,393 82,293 83,696 84,028 82,232 248,983 80,411 4,615 4,757 248,434 248,688 76,708 6,299

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

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

untitled

untitled 1 BASIC (Beginner s All-purpose Symbolic Instruction Code) EXCEL BASIC EXCEL EXCEL VBA (Visual Basic for Applications) 2 3 1.1 Excel Excel Excel Check Point 1. 2. 1.1.1 Sheet1 A Sheet2 Sheet A A10 4 1

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

橡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

会員用_DB・DC-住所情報照会事務処理要領_H2201.PDF

会員用_DB・DC-住所情報照会事務処理要領_H2201.PDF 221 1 1 2 3 2 3 4 1 51 2 53 56-62 QA 66 DBDC 21115 2214 010412 () () (1 2 10 DBDC ) 2 34 1 1 ) ( CD-RF) 00019999 112 99990001 222 10 2 2 2 0 () 1 2 () CD FD 3 4 (CD-RFD) CD FD 3 3 STEP0 STEP1 STEP2 (HP)

More information

Microsoft PowerPoint ppt

Microsoft PowerPoint ppt 統計と情報処理第 05 回 MS-Excel の基礎 本日の内容 絶対参照と相対参照の使い分け グラフの書き方の基礎 MS-WordへのExcelの貼り付け 先週の Excel ファイル 160511.xls を引き続き使用します 1 2/36 絶対参照と相対参照 絶対参照と相対参照の使い分け Excel では セルを絶対参照と相対参照で参照することができます それぞれ 絶対参照は セルの位置を座標

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

Oracle Discoverer 3.1 チュートリアル

Oracle Discoverer 3.1 チュートリアル Oracle Discoverer 3.1 1998 8 A61498-1 Enabling the Information Age Through Network Computing Oracle DIscoverer 3.1 : A61498-1 1 : 1998 8 : Oracle Discoverer 3.1 User Tutorial : A60963-01 : Paula Peplow,

More information

3 9 3 100 2 10 30 12 1 1 2 2 4 3 9 1 250-1- 3 12 2 2 4 2 16 2-2- -3-8 2 6 10 30 11 30 11 2,500 9 2 2 10-4- 2005 2005 5 50-5- 3 30 FM 43 18 23 730 1700 17 11 3 FM 2 1800 30 3 400 1 1 28 3 4 18.1.28-6- 1

More information

Excel2000

Excel2000 Microsoft Excel 2000 Excel Excel ( )m...1...1...1 Shift...2 Shift...2...3...4...6...7...8...10...11...12...13...14...16...17...19...19...20 Excel B2 E5 E5 1/21 Shift B2 Shift E5 Shift B2 Shift Shift 2/21

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

 

  521 1 I. 1) 18 20087510.4 20552.56565 200920156 20102015 17 20092015665 5003007520 6465006500 65500 200520153.32.3 樋 100 6 20 20 20086522.17510.4 20552.56575 15641.31 2) 18 2005 UNWorld Population Prospects:

More information

- 1 - 15 2030 4 21 21-2 - 2 1 21 21 4 22 31 10 5 26 ( JA ) - 3 - 4 21 7 9 9 34 1,386 1,003 94 58 1,155 60 25 33 1 3 2-4 - 12 17 60 7 7 12 H1217 4 7 30 34 19-5 - - 6 - (BMI*18.5) 20 15.2%30 8.% 20 86.4%30

More information

ohp.mgp

ohp.mgp 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..

More information

<4D F736F F D B B83578B6594BB2D834A836F815B82D082C88C60202E646F63>

<4D F736F F D B B83578B6594BB2D834A836F815B82D082C88C60202E646F63> 新 Excel コンピュータシミュレーション サンプルページ この本の定価 判型などは, 以下の URL からご覧いただけます. http://www.morikita.co.jp/books/mid/084871 このサンプルページの内容は, 初版 1 刷発行当時のものです. Microsoft Excel Excel Visual Basic Visual Basic 2007 Excel Excel

More information

RubyWorld Conference 2011, Sep 5 2011 [6] 1 2 3 4-2SD -2SD -2SD -2SD [s] 56.9 68.8 33.7 36.6 27.1 29.1 22.5 24.0 21.8 20.5 22.9 22.3 24.3 24.0 24.4 24.2 [s] 101.9 115.1 85.2 92.8 57.1 62.9 42.5 46.3

More information

Microsoft Word MSExcel2010

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

More information

橡MAIN.PDF

橡MAIN.PDF ILOS Integrated Logistics Optimization System Ver. 1:0) MELOS MEta Logistics network Optimization System Ver. 1:0) METEO MEta Tactical Enterprise resource Optimizer Ver. 1:0) NEOOS Network-type Economic

More information

1 Excel 1. [Standard] (call [Call Standard]) Excel [ ] [E ] Excel m 1 ( ) (

1 Excel 1. [Standard] (call [Call Standard]) Excel [ ] [E ] Excel m 1 ( ) ( 1 Excel 1. [Standard] (call [Call Standard]) Excel [] [E ] Excel 2. 2 2.1 50m 1 ( ) 30 1. 2019 (http://news.fukuoka-edu.ac.jp/form/guide/navi2019.pdf), p.7 8 2. Excel 2019 4 Excel 2019 Excel 2013 [] [R]

More information

等価曲げせん断型モデルとしたときの質点の全変形とせん断変形の履歴をMicrosoft Excelで図化するための操作手順

等価曲げせん断型モデルとしたときの質点の全変形とせん断変形の履歴をMicrosoft Excelで図化するための操作手順 1 2005/09/07 Dynamic21 1. SS21/DynamicPRO CSV Microsoft Excel Microsoft Excel Microsoft Excel Excel 2003 Microsoft Excel Microsoft Corporation 2 2. DynamicPRO 2.1. CSV 3 2.2. CSV 1 4 2.3. 5 2.4. 6 2.5.

More information

dicutil1_5_2.book

dicutil1_5_2.book Kabayaki for Windows Version 1.5.2 ...1...1 1...3...3 2...5...5...5...7...7 3...9...9...9...10...10...11...12 1 2 Kabayaki ( ) Kabayaki Kabayaki ( ) Kabayaki Kabayaki Kabayaki 1 2 1 Kabayaki ( ) ( ) CSV

More information

ExcelVBA 10m (10m ) (10m ) 5 4 1 49 1974 54 1979 2 59 1984 3 1989 4 6 1994 8.3 km 839 10m 15 3km 4km 1 CD-ROM ExcelVBA Excel Excel - 2 -

ExcelVBA 10m (10m ) (10m ) 5 4 1 49 1974 54 1979 2 59 1984 3 1989 4 6 1994 8.3 km 839 10m 15 3km 4km 1 CD-ROM ExcelVBA Excel Excel - 2 - - 1 - ExcelVBA 10m (10m ) (10m ) 5 4 1 49 1974 54 1979 2 59 1984 3 1989 4 6 1994 8.3 km 839 10m 15 3km 4km 1 CD-ROM ExcelVBA Excel Excel - 2 - 1 100 100 10 1km 2-3 - Excel VBA 3 100 100-4 - 4 VBA VBA 5-5

More information

2

2 2 6 7 9 4 6 7 2 3 4 5 6 7 8-0 - G G G G G G f f 9 e f - e f 0 5 e fe e c c cc B FD F 5 2 5 D F C e e e b 3 f f 5 ff ff f f f f b b bb b b b c c c ee ee e ee ee e f f 4 e e 7 5 5 e bb 6 7 f GE 8 f 9 5 F

More information

ME’scopeVES ユーザーマニュアル

ME’scopeVES ユーザーマニュアル 1....2 2....2...4...4...5...7 3....7 4....9 1 2 3 4 5 6 . 13 7 13... (14) OK 14.2. & F&D OK.3. & OK (15). 8 15 Visual SDM 16 9 3D FE 17 4 17 17 1 Iyy J 14 10e-3 30e-6 17e-6 7e9 0.33 2.8e3 3D 3D (Y) OK

More information

) km 200 m ) ) ) ) ) ) ) kg kg ) 017 x y x 2 y 5x 5 y )

) km 200 m ) ) ) ) ) ) ) kg kg ) 017 x y x 2 y 5x 5 y ) 001 ) g 20 g 5 300 g 7 002 720 g 2 ) g 003 0.8 m 2 ) cm 2 004 12 15 1 3 1 ) 005 5 0.8 0.4 ) 6 006 5 2 3 66 ) 007 1 700 12 ) 008 0.315 ) 009 500 g ) kg 0.2 t 189 kg 17.1 kg 010 5 1 2 cm 3 cm )km 2-1 - 011

More information

Excelを使ったAHPの計算方法

Excelを使ったAHPの計算方法 Excel 入門 ( その 3) 23 24 (a) (b) (c) (d) 1 Excel 23 Excel Excel Enter 1 2 Tab 1 Enter 2 AHP n n F2 =B2*C2*D2*E2 25 2 4 30 4 4 30 4 1 30 30 4 1 Excel G2 =F2^(1/4)^Excel 26 1 3 Excel F2 G2 G2 3 1 4 3 4 3 27

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

Excelで学ぶ.indb

Excelで学ぶ.indb 18 1 1.119 1 1 sorting 2 123451234512345 111222333444555 Excel 2 Excel Excel 123451234512345 1.1 A1 A1:A15 3. 3 A Z 20 1 1.221 1.2 1 1.1 1.2 1.3 65 A2:F12 A OK 1.3 G H GH 22 1 1.3IF 23 1 IF IF =IF 1 2

More information

21 1113 127 23 21 12 TEL 0762251341 1 44 2 3 20 66 1 6 10 24 36 50 58 80 100 10 104 11 118 12 130 13 144 14 150 15 184 16 186 17 194 18 202 19 204 20 230 21 242 22 254 23 262 24 266 25 268 26 270 271

More information