Excel97関数編
|
|
|
- てるえ よせ
- 9 years ago
- Views:
Transcription
1
2 Excel97 IF Microsoft Excel IF IFG4C IFG4C IF... 9 IF... 9 IF IF IF IF
3 Microsoft Excel 97 AVERAGE MIN MAX SUM IF 2 RANK TODAY ROUND COUNT INT VLOOKUP 1/26
4 Excel A B C ABC SUMA1B1C1 A1B1C1 SUM A1 B1 C1 A1 B1 C1 SUMA1A5 A1A5 SUM A1 A5 A1 A5 SUMA1A10B1B10 A1A10B1B10 TODAY 2/26
5 IF IF IF 0 IF 2 ABA B IF D2 IF C2>=B2 IF IF C2B2 C2B2 C2B2 C2B2 3/26
6 IF IF /26
7 23 4 IF G C4 IFG4 C4 5/26
8 OK 6/26
9 13IF IFG4 C4 14 H4 15 H5 H /26
10 17 OK H4 H10 8/26
11 IF IFC4 350 C4350 IFF F IFSUMC3C8 0 SUMC3C8 IF C3C800 IF 0 1 F4 2 IF 9/26
12 3 IF 4 IF 5 6 SUM 7 SUM IF SUM IFSUMC5E5 10/26
13 SUM IF 11 IF /26
14 IF 12/26
15 18 IF OK 19 IF IFSUMC5E5 0 SUMC5E5 =IF SUMC5:E5= 0,, SUMC5:E5 =IF SUMC5:E5= 0,, SUMC5:E5 SUMC5:E5= 0 =IF SUMC5:E5= 0,, SUMC5:E5 SUMC5:E5= 0 C5E5 =IF SUMC5:E5= 0,, SUMC5:E5 IF =IF SUMC5:E5 0, SUMC5:E5, =IF SUMC5:E5 0, SUMC5:E5, SUMC5:E5 0 C5E5 =IF SUMC5:E5 0, SUMC5:E5, SUMC5:E5 0 13/26
16 IF IF IF IF 10 A 9 B 8 C 7 D I 3 14/26
17 4 IF 5 IF 6 7 F /26
18 A OK 16/26
19 14 I IFF4>=10 A I5 I6 I7 IF I5=IF(F4=9, B,98) I6=IF(F4=8, C,97) I7=IF(F4<=7, D,96) IF 16 I IFF49 B 98 IF 17/26
20 18b I /26
21 IF IF 19/26
22 IF IF IF I4 =IF(F4>=10,"A",99) I5 =IF(F4=9,"B",98) I6 =IF(F4=8,"C",97) I7 =IF(F4<=7,"D",96) IF IF =IF(F4>=10,"A", IF(F4=9,"B", IF(F4=8,"C", IF(F4<=7,"D",96)))) IF(F4<=7,"B",96) =IF(F4>=10,"A",99) 10 IF(F4=9,"B",98) 9 IF(F4=8,"C",97) I6IF(F4=8,"C",97)97"D" =IF(F4>=10,"A", IF(F4=9,"B", IF(F4=8,"C", "D"))) IF =IF(F4>=10,"A", IF(F4>=9,"B", IF(F4>=8,"C", "D"))) =IF(F4>=10,"A", IF(F4>=9,"B", IF(F4>=8,"C", "D"))) F4 10 A IF IF =IF(F4>=10,"A", IF(F4>=9,"B", IF(F4>=8,"C", "D"))) F B IF IF =IF(F4>=10,"A", IF(F4>=9,"B", IF(F4>=8,"C", "D"))) F4 8 9 C IF D IF 20/26
23 H4H10 Operation 211 Operation 12 OK OK H4H10 21/26
24 IF OK 22/26
25 23/26
26 2 TRUE FALSE A1B1 A1B1 A1B1 A1B1 A1B1 A1B1 G4C4 G4C4 "G4C4" TRUE 24/26
27 " " TAB " " 25/26
28 5 26/26
29 MicrosoftWindows Microsoft Corporation TM 27/26
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
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
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
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
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
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..............................................
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
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](/thumbs/39/20160569.jpg "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
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](/thumbs/39/20103155.jpg "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
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
橡Taro9-生徒の活動.PDF
3 1 4 1 20 30 2 2 3-1- 1 2-2- -3- 18 1200 1 4-4- -5- 15 5 25 5-6- 1 4 2 1 10 20 2 3-7- 1 2 3 150 431 338-8- 2 3 100 4 5 6 7 1-9- 1291-10 - -11 - 10 1 35 2 3 1866 68 4 1871 1873 5 6-12 - 1 2 3 4 1 4-13
関 数
/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
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
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
(2) ( 61129) 117, ,678 10,000 10,000 6 ( 7530) 149, ,218 10,000 10,000 7 ( 71129) 173, ,100 10,000 10,000 8 ( 8530) 14
16 8 26 MMF 23 25 5 16 7 16 16 8 1 7 16 8 2 16 8 26 16 8 26 P19 (1) 16630 16,999,809,767 55.69 4,499,723,571 14.74 9,024,172,452 29.56 30,523,705,790 100.00 1 (2) 16 6 30 1 1 5 ( 61129) 117,671 117,678
-----------------------------------------------------------------------------------------1 --------------------------------------------------------------------------------------1 -------------------------------------------------------------------------------------1
1 2 3 4 1 2 3 4 1 2 3 4 12 3 4
1 2 3 4 5 6 1 2 3 4 5 6 1 2 1 2 1 2 1 2 1 2 3 4 12 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 12 3 4 1 2 3 4 5 6 7 8 1 2 3 46 7 1 2 3 4 5 6 7 1 2 3 4 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 16 7 8 92 3 46 7 :
S1460...........\1.E4
3 4 3 4 5 3 4 5 3 4 3 4 3 3 3 3 4 3 4 3 3 4 4 3 3 3 3 4 3 4 3 3 3 3 3 3 4 3 4 3 4 5 4 3 5 4 3 3 4 5 3 4 5 4 3 4 3 3 4 3 4 3 3 3 3 3 4 3 3 4! "! " " 0 6 ! " 3 4 3 3 4 3 ! " 3 3 4 5 4 5 6 3 3
22 25 34 44 10 12 14 15 11 12 16 18 19 20 21 11 12 22 10 23 24 12 25 11 12 2611 27 11 28 10 12 29 10 30 10 31 32 10 11 12 33 10 11 12 34
22 25 34 44 10 12 14 15 11 12 16 18 19 20 21 11 12 22 10 23 24 12 25 11 12 2611 27 11 28 10 12 29 10 30 10 31 32 10 11 12 33 10 11 12 34 35 10 12 36 10 12 37 10 38 10 11 12 39 10 11 12 40 11 12 41 10 11
2 2 1 (LOOKUP ) VLOOKUP(HLOOKUP) JR ( ) 1 2 (S101.xlsx() 1 3 (1) C2) (2) (C3) (3) 2 (C4,C5) (4) (C6,C7) 1.1 (C6) C5 4 C6 C
2 1 2 (lookup ) (1) LOOKUP (2) (ROUNDUP,ABS (3) (4) (5) 2 2 1 (LOOKUP ) VLOOKUP(HLOOKUP) JR ( ) 1 2 (S101.xlsx() 1 3 (1) C2) (2) (C3) (3) 2 (C4,C5) (4) (C6,C7) 1.1 (C6) C5 4 C6 C5 4 4 4 154 154 µ µ Ž ƒ
26 2 3 4 5 8 9 6 7 2 3 4 5 2 6 7 3 8 9 3 0 4 2 4 3 4 4 5 6 5 7 6 2 2 A B C ABC 8 9 6 3 3 4 4 20 2 6 2 2 3 3 4 4 5 5 22 6 6 7 7 23 6 2 2 3 3 4 4 24 2 2 3 3 4 4 25 6 2 2 3 3 4 4 26 2 2 3 3 27 6 4 4 5 5
パソコン基本操作講習会テキスト
Microsoft Excel - 関数編 - 講習会テキスト 明治大学教育の情報化推進本部 2019 年 4 月 1 日 目次 1. 関数の入力... 2 1.1. 関数とは... 2 1.2. 関数の基本構造... 3 1.3. 関数の入力方法... 4 2. よく使う関数... 6 2.1. SUM 関数... 6 2.2. AVERAGE 関数... 8 2.3. RANK 関数... 9
ネットショップ・オーナー２ ユーザーマニュアル
1 1-1 1-2 1-3 1-4 1 1-5 2 2-1 A C 2-2 A 2 C D E F G H I 2-3 2-4 2 C D E E A 3 3-1 A 3 A A 3 3 3 3-2 3-3 3-4 3 C 4 4-1 A A 4 B B C D C D E F G 4 H I J K L 4-2 4 C D E B D C A C B D 4 E F B E C 4-3 4
EPSON エプソンプリンタ共通 取扱説明書 ネットワーク編
K L N K N N N N N N N N N N N N L A B C N N N A AB B C L D N N N N N L N N N A L B N N A B C N L N N N N L N A B C D N N A L N A L B C D N L N A L N B C N N D E F N K G H N A B C A L N N N N D D
ありがとうございました
- 1 - - 2 - - 3 - - 4 - - 5 - 1 2 AB C A B C - 6 - - 7 - - 8 - 10 1 3 1 10 400 8 9-9 - 2600 1 119 26.44 63 50 15 325.37 131.99 457.36-10 - 5 977 1688 1805 200 7 80-11 - - 12 - - 13 - - 14 - 2-1 - 15 -
EPSON エプソンプリンタ共通 取扱説明書 ネットワーク編
K L N K N N N N N N N N N N N N L A B C N N N A AB B C L D N N N N N L N N N A L B N N A B C N L N N N N L N A B C D N N A L N A L B C D N L N A L N B C N N D E F N K G H N A B C A L N N N N D D
公務員人件費のシミュレーション分析
47 50 (a) (b) (c) (7) 11 10 2018 20 2028 16 17 18 19 20 21 22 20 90.1 9.9 20 87.2 12.8 2018 10 17 6.916.0 7.87.4 40.511.6 23 0.0% 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2.0% 4.0% 6.0% 8.0%
198
197 198 199 200 201 202 A B C D E F G H I J K L 203 204 205 A B 206 A B C D E F 207 208 209 210 211 212 213 214 215 A B 216 217 218 219 220 221 222 223 224 225 226 227 228 229 A B C D 230 231 232 233 A
/9/ ) 1) 1 2 2) 4) ) ) 2x + y 42x + y + 1) 4) : 6 = x 5) : x 2) x ) x 2 8x + 10 = 0
1. 2018/9/ ) 1) 8 9) 2) 6 14) + 14 ) 1 4 8a 8b) 2 a + b) 4) 2 : 7 = x 8) : x ) x ) + 1 2 ) + 2 6) x + 1)x + ) 15 2. 2018/9/ ) 1) 1 2 2) 4) 2 + 6 5) ) 2x + y 42x + y + 1) 4) : 6 = x 5) : x 2) x 2 15 12