Excel97関数編

Size: px
Start display at page:

Download "Excel97関数編"

Transcription

1

2 Excel97 SUM Microsoft Excel SUM

3 Microsoft Excel 97 AVERAGE MIN MAX SUM IF 2 RANK TODAY ROUND COUNT INT VLOOKUP 1/15

4 Excel A B C A B C SUM A1 B1 C1 A1 B1 C1 SUM A1 B1 C1 A1 B1 C1 SUM A1 A5 A1 A5 SUM A1 A5 A1 A5 SUM A1 A10 B1 B10 A1 A10 B1 B10 TODAY 2/15

5 SUM SUM SUM /15

6 C4 F4 G4 SUM =SUM C4:F G4 G9 SUM 14 3 G4 G9 SUM SUM G4 =SUM C4:F4 G9 =SUM C9:F9 4/15

7 SUM C4 C9 C10 SUM =SUM C4:C /15

8 1 C10 F10 SUM 14 3 C10 F10 SUM SUM C10 =SUM C4:C9 F10 =SUM F4:F9 C4 G10 SUM /15

9 G4 G10 C10 F10 SUM 4 6 SUM C4 F4 7/15

10 SUM SUM -D 4 6 C4 SUM C4 SUM SUM 8/15

11 4 C4 SUM 4!C4 4 C4 6 =SUM '4 :6 '!C4 9/15

12 4 5 6 C4 C4 C4 =SUM '4 :6 '!C4 10/15

13 / SUM SUM OK 11/15

14 G4 G5 G /15

15 OK 13/15

16 G9 SUM G5 G9 G5 G9 14/15

17 G5 G9 G5 G9 G5 Shift G9 15/15

18 Microsoft Windows Microsoft Corporation TM

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

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

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

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

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

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

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

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

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

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

講習案内パンフレット2000.PDF

講習案内パンフレット2000.PDF 1 OA Visio Visio 1 Visio VI2000-N Microsoft Visio2000 Web IN50-N Projcet2000 1 PR2000-O Project Outlook Outlook OL98-O Outlook Outlook OL98-M Outlook Access Excel PowerPoint PowerPoint Word Word 2 AC2000-O

More information

関 数

関 数 /0/ 12 / / + 2 3 3 2 2 * 2*3 / 2/3 23 2 3 11 11 11 11 11 11 28 2468 2648 RANK SUM COUNTA SUMIF COUNTIF AVERAGE ROUND STDEVP FREQUENCY MAX LARGE MEDIAN MIN 66 6 C6:C15,,G6:G15 SUM 66 / D17,1 SUMIF / C6:C15,,G6:G15

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

<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

VM-53PA1取扱説明書

VM-53PA1取扱説明書 VM-53PA1 VM-53PA1 VM-53 VM-53A VM-52 VM-52A VM-53PA1 VM-53PA1 VM-53A CF i ii VM-53 VM-53A VM-52 VM-52A CD-ROM iii VM-53PA1 Microsoft Windows 98SE operating system Microsoft Windows 2000 operating system

More information

Keynote 3 ユーザーズガイド

Keynote 3 ユーザーズガイド Keynote3 K AppleComputer,Inc. 2006AppleComputer,Inc.Allrightsreserved. AppleComputer,Inc. Apple Apple Computer,Inc. Apple AppleComputer,Inc. Apple 1InfiniteLoop Cupertino,CA95014-2084 U.S.A. www.apple.com

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

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

a a b a b c d e R c d e A a b e a b a b c d a b c d e f a M a b f d a M b a b a M b a M b M M M R M a M b M c a M a R b A a b b a CF a b c a b a M b a b M a M b c a A b a b M b a A b a M b C a M C a M

More information

簡単エコ印刷ナビマニュアル

簡単エコ印刷ナビマニュアル T-1076D MA1603-E ...3...4...7...7...7...9...15...15...16...17...18...19...20...21...22...23...24...28...29...30...32...33...37...37...37...38...39...39...39...40...41...41...41...42...42...43...43...44...45...46...52...53...53...53

More information

1007.\1.ai

1007.\1.ai - 1 - B - 2 - e - 3 - F O f g e f - 4 - O O N N N N N N N N N N N N N N N N N N N N N N N F C - 5 - N N N N N N N N N N N N N N N N N N N N N N N F - 6 - D - 7 - - 8 - - 9 - - 10 - - 11 - - 12 - - 13 -

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 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

EpsonNet Config

EpsonNet Config EpsonNet Config EpsonNet Config EpsonNet Config PDF EpsonNet Config K EpsonNet Config Adobe Reader Mac OS X PDF EpsonNet Config EpsonNet Config - EpsonNet Config L Windows Windows 7 Microsoft Windows 7

More information

Vodafone Connect Card Utility for VC701SI - -

Vodafone Connect Card Utility for VC701SI - - Vodafone Connect Card Utility for VC701SI - - VC701SI for VC701SI Pocket PC 2002 for VC701SI Pocket PC 2002 for VC701SI Pocket PC 2002 Microsoft Pocket PC 2002 Software Pocket PC 2002 PDA VC701SI Compact

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

Vodafone Connect Card Utility for VC701SI - Windows Mobile

Vodafone Connect Card Utility for VC701SI - Windows Mobile Vodafone Connect Card Utility for VC701SI - Windows Mobile 2003- VC701SI for VC701SI Windows Mobile 2003 for VC701SI Windows Mobile 2003 for VC701SI Windows Mobile 2003 Microsoft Windows Mobile 2003 Software

More information

Word 基礎 1. Wordとは 2. 文字入力 変換 3. 文書の入力 4. 文書の作成 5. 文書の編集 1 6. 文書の編集 2 7. 表の作成 8. 文書を飾る 9. 文書の印刷 Wordを起動 終了させる ファイルを開く日本語入力 文字入力の流れ ファンクションキーでの変換文章の入力方法

Word 基礎 1. Wordとは 2. 文字入力 変換 3. 文書の入力 4. 文書の作成 5. 文書の編集 1 6. 文書の編集 2 7. 表の作成 8. 文書を飾る 9. 文書の印刷 Wordを起動 終了させる ファイルを開く日本語入力 文字入力の流れ ファンクションキーでの変換文章の入力方法 パソコン教室案内 は じ め る ひ ろ が る 資格学校アテナ 小田原校 250-0011 小田原市栄町2-13-9 ハザマビル2F TEL:0465-21-5586 FAX:0465-21-5587 本部 株式会社 エフアンドエム 事業開発本部 大阪府吹田市江坂町1-23-38 F Mビル TEL 06 6339-9065 Word 基礎 1. Wordとは 2. 文字入力 変換 3. 文書の入力

More information

PDF CD-ROM CD-ROM Manual PDF Adobe Reader Adobe Web

PDF CD-ROM CD-ROM Manual PDF Adobe Reader Adobe Web PDF CD-ROM CD-ROM Manual PDF Adobe Reader Adobe Web [ ] [OK] [OK] 40 () () [ ][ ] [OK] [ ] [ ][ ] ] [ [ ][ ] [ ] 3 20 [OK] - CONFORMat CONFORMat Dual 2 2 X Y 3 [ ][ ] 13 [ ][2 ] [2 ] [ ][2 ] [2 ] [ ]

More information