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

Size: px
Start display at page:

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

Transcription

1 Future Lifestyle Inc. IT

2 Microsoft Excel 2000 Microsoft Microsoft Corporation

3 B

4 C4 E7 C4 E7 2

5 =C4+D4+E4 SUM MAX MIN B3 F7 Sheet

6 B3 F7 C4 F7 Delete C4 F7 SUM SUM() C4 SUM 4

7 B3 F7 / / 5

8 10 6

9

10

11 18 A1 B1 C1 D1 E1 F1 G1 A1 G20 18 A2 A D2 F

12 19 F3 =F2+D3-E3 F3 F3 F4 F20 F4 F

13 F F

14 F F3 F

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

B B 10 7 581 10 8 582 10 9 583 B B 10 11 585 10 12 586 B 10 10 584 B

B B 10 7 581 10 8 582 10 9 583 B B 10 11 585 10 12 586 B 10 10 584 B 10 1 575 10 12 586 B B 10 1 575 10 2 576 B B 10 4 578 10 5 579 10 3 577 B 10 6 580 B B B 10 7 581 10 8 582 10 9 583 B B 10 11 585 10 12 586 B 10 10 584 B 11 1 587 11 12 598 B B 11 1 587 11 2 588 11 3 589

More information

(資料2)第7回資料その1(ヒアリング概要)

(資料2)第7回資料その1(ヒアリング概要) 2 3 4 5 6 7 8 9 10 11 12 13 1 1 1 1 5 1 6 533 4 505 722 13 3325 475 1 2 3 13 10 31 1 1 1 (1) 1 (2) 2 (3) 3 (4) 4 5 5 6 7 8 8 8 9 11 11 12 13 14 15 16 19 (1) (2) (3) (1) (5 ) 1 (10 ) ( ) (2) 2 4 (3) 3 3,100

More information

-------------------------- ----------------------------------------------------- -------------------------------------------------------------- ----------------------------------------------------- --------------------------------------------------------------

More information

<4D F736F F D DEC8BC A95BD90AC E A982BA81698AB A B B4790DF90AB8EBE8AB FC89408A4F816A82CC93AE8CFC82C98AD682B782E9838C837C815B D

<4D F736F F D DEC8BC A95BD90AC E A982BA81698AB A B B4790DF90AB8EBE8AB FC89408A4F816A82CC93AE8CFC82C98AD682B782E9838C837C815B D 27 29 2 IT 1,234 1,447 2,130 1,200 3,043 4 3 75 75 70-74 -10 J00 J101 J110 J111 J118 J300 J302-304 J301 26,475,118 155,290,311 1,234 14,472,130 75,784,748 12,003,043 79,505,563 1 1.00% 0.62% 1.31% 9 12

More information

, , ,210 9, ,

, , ,210 9, , 2006 5 642 7 2,671 35 732 1,727 602 489 386 74 373 533 305 1,210 9,786 2004 1,024 43.7 16.4 2004 978.6 40.2 2003 1 2006 5 1997 1998 1999 774 3,492 11 2,603 35 843 5,118 1,686 476 358 2000 738 3,534 11

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

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

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

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

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

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

,255 7, ,355 4,452 3,420 3,736 8,206 4, , ,992 6, ,646 4,

,255 7, ,355 4,452 3,420 3,736 8,206 4, , ,992 6, ,646 4, 30 8 IT 28 1,260 3 1 11. 1101. 1102. 1103. 1 3 1,368.3 3 1,109.8 p.5,p.7 2 9,646 4,291 14.5% 10,p.11 3 3,521 8 p.13 45-49 40-44 50-54 019 5 3 1 2,891 3 6 1 3 95 1 1101 1102 1103 1101 1102 1103 1 6,255

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

5 10 10-1 - 5 20-2 - - 3 - - 4 - 22 6 30 10 12 22 7 8 1 30 4 30 1 22 7 14 10 12 20 22 7 21 1 30 3 30-5 - - 6 - - 7 - 11 9 9 14 10 9 15 7 9 10 NPO - 8 - - 15 - - 16 - - 17 - - 19 - - 20 - - 21 - - 22

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

untitled

untitled ... 2... 1 1... 2 1... 2 2... 4 3... 5 2... 6 1... 6 2... 8... 8... 9... 9 3... 10 Q1... 10 Q5... 11 Q6... 12 Q4-1... 13 Q3... 15 -Q4-1... 17 Q2... 19 Q4-2... 22... 24 4... 26... 26... 27... 29... 31...

More information

... 3... 3... 3... 3... 4... 7... 10... 10... 11... 12... 12... 13... 14... 15... 18... 19... 20... 22... 22... 23 2

... 3... 3... 3... 3... 4... 7... 10... 10... 11... 12... 12... 13... 14... 15... 18... 19... 20... 22... 22... 23 2 1 ... 3... 3... 3... 3... 4... 7... 10... 10... 11... 12... 12... 13... 14... 15... 18... 19... 20... 22... 22... 23 2 3 4 5 6 7 8 9 Excel2007 10 Excel2007 11 12 13 - 14 15 16 17 18 19 20 21 22 Excel2007

More information

11夏特集号初校.indd

11夏特集号初校.indd 1 2 3 5 50 40 7 6 3 ABC 3 5 A 5% B C 100 3 1 2 3 A 5% 5% 5% B 10% 5% 0% C 20% 10% 15% A 15.8% 15.0% 0.8% B 15.5% 15.0% 0.5% C 12.2% 15.0% 2.8% 2,000 1,500 1,000 500 0 10% 5% 3% 1% 01 5 10 15 20 25 30

More information

1 TOKEN CORPORATION

1 TOKEN CORPORATION 31 1 TOKEN CORPORATION Q1 TOKEN CORPORATION 2 Q2 3 TOKEN CORPORATION Q3 TOKEN CORPORATION 4 123 142 2,94 23.5 42 538 74 1,44 71 1,93 1,554 75.3 5 TOKEN CORPORATION TOKEN CORPORATION 6 4 35 3 25 2 15 1

More information

平成17年度 マスターセンター補助事業

平成17年度 マスターセンター補助事業 - 1 - - 2 - - 3 - - 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 - IC IC - 29 - IT

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

環境家計簿使用マニュアル

環境家計簿使用マニュアル CD ROM CD-ROM 3.pdf.xls.xls 50 3 50Microsoft Windows XP Professional Microsoft Windows XP Home EditionWindows VISTA Mac OS X OS Microsoft Excel Microsoft Excel Microsoft Office 1 CO 21 2 2050 CO 1990 50

More information

14 10 15 14 10 15 46.7 14 8 14 3 1 14 8 31 1 14 8 80,956 454,528 2.9 3.4 14,550 2.7 14,227 2.4 13 8 78,658 439,432 14,956 14,571 14 2 153,889 860,441 24,545 23,378 1 ( ) - 1-1 14 8 7,262 6.1 84 28 13 8

More information

70 3 70 70 70 70 3 70 70 300 3 5

70 3 70 70 70 70 3 70 70 300 3 5 70 3 2611 25920 70 3 70 70 70 70 3 70 70 300 3 5 70 1 1 2 2 MAX 3 1 1 2 2 MAX 3 25 27 30 50 70 1 2 3 1 70 3 P oint 300 P oint 20 30 40 50 3 2 1 1 14 15 10 11 8 5 5 5 5 95.2 68.7 95.7 94.0 97.7 P oint

More information

2

2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 CD v.s. 19 DVD EU DVD 20 21 22 23 24 25 DNA 26 27 28 29 R 30 31 Windows Word HTML FOM HTML CSS 32 Excel PowerPoint Word Excel FOM Excel PowerPoint 33 PC ICT

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

<4D F736F F D2095BD90AC E937890B68A888F4B8AB E397C394EF82CC93AE8CFC82C98AD682B782E992B28DB895AA90CD2E646F6378>

<4D F736F F D2095BD90AC E937890B68A888F4B8AB E397C394EF82CC93AE8CFC82C98AD682B782E992B28DB895AA90CD2E646F6378> 28 3 IT 1,124 1,414 9,986 1,205 247 2 6,663 6,802 3 4,155 ICD-10 p.2 26 3 4,155 1,124 10 3,628 10.62% 10 31.29%30.75%15.62% 36.31% 29.88%20.94% 928 692 412 205 6,127 4,971 3,246 2,291 1,968 1,658 35.77

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

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

untitled

untitled Copyright 2010 by Future Architect, Inc. Japan Copyright 2010 by Future Architect, Inc. Japan -2- Copyright 2010 by Future Architect, Inc. Japan Copyright 2010 by Future Architect, Inc. Japan Copyright

More information

1...1 1...1 2...1 2.1...1 2.2...5 2.3...6 1...6 2...6 3...7 4...7 5...7 2.4...8 2...9 1...9 2... 10 2.1... 10 1... 10 2... 11 2.2... 12 1 2... 13 3... 18 4... 22 5... 23 6... 24 2.3... 34 1... 34 2...

More information

取扱説明書

取扱説明書 L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L LOSWindows LUSB 15 8 CD-ROM CD-ROM 17 19 23 L L 1 1 2 L L L L L L 1 2 1 2 3 3 L L L L L L L L L L L L L L L L L L L L L L

More information

大学等における社会人の受け入れ状況調査

大学等における社会人の受け入れ状況調査 1 1 2 3 4 - - - - - - 6 8 6 2001 30 7 6 3 30 8 6 1 4 3,6,9,12 4 1 1 E 1 3 13 15 4 3 1 ( ) 8. 6 14 8 6 2002 8 8 3 7 60 1 4 4 32 100 12

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

<4D6963726F736F667420576F7264202D20457863656C20835C838B836F815B82C982E682E990FC8C608C7689E68252>

<4D6963726F736F667420576F7264202D20457863656C20835C838B836F815B82C982E682E990FC8C608C7689E68252> Excel ソルバーで 解 く 線 形 計 画 問 題 2011 年 度 大 阪 大 学 経 済 学 部 大 学 院 経 済 学 研 究 科 目 次 Excel 2007 Excel 1 1 1 3 Excel 2010 Excel 12 12 13 14 i 1.Excel の 準 備 Excel 2007 1.1 ソルバーの 有 効 化 Microsoft Excel データ ソルバー Office

More information

3.....ren

3.....ren 823 2011 329 20 11 20 48.3 90.5 20 40 21 12 16 22 3 23 50 50 50 1 54 2 55 3 56 57 49 330 823 2011 6 0.3 0.7 1.0 3 1 0.3 0.7 1.0 5 m 3 m 3 m 5 m 5 3 m 1 2 5001,000 3 50 52 mm 4 0.1 1 50 823 2011 331 5 10

More information

1 2 3 4 5 1 1:30 NPO 16 1 19 16 2 17-6 - 10 2008 2010 120 150 IT( ) 60 21 40-7 - - 8-10 ( ) NPO 2 10 16:40-9 - 10 ii NPO NPO ( ) ( ) 11 12 13 14 15 22 26 27 28 29 30 31 32 33 34 m3 m3

More information

... 3... 4... 5... 7 Acronis Backup & Recover 10 Deduplication... 7... 10 2

... 3... 4... 5... 7 Acronis Backup & Recover 10 Deduplication... 7... 10 2 Copyright Acronis, Inc., 2000 2009 ... 3... 4... 5... 7 Acronis Backup & Recover 10 Deduplication... 7... 10 2 50 100% 2008 IDC 3 3,000% Windows Linux 3 1 1 4KB 1 90% 9MB Microsoft PowerPoint 10 [ ] 9MB

More information

2

2 2 3 4 5 6 1 2 7 Windows Me Microsoft Office XP Personal Easy CD Creator4 8 9 DIGITAL 10 11 12 1 3 2 13 1 2 14 3 15 1 2 3 16 4 17 1 2 18 3 1 4 5 1 2 3 4 19 1 2 3 20 4 5 21 1 2 1 22 2 3 1 23 1 2 3 4 24 1

More information