MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2
|
|
|
- あつひろ もちやま
- 9 years ago
- Views:
Transcription
1 ( ) MS-Excel 1
2 MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2
![[Office ] [Excel ] [ ] :](/docs-images/51/20160569/images/page_2.jpg "[Ctrl+n] [Office ] [ ] :")
3 MS-Excel : [Ctrl+s] [Office ] [ ] : [F12] [Office ] [ ] : 3
![[Office ] [ ]](/docs-images/51/20160569/images/page_3.jpg ": [F12] : 3")
4 Word Excel (User Interface) 4
5 CSV, Comma Separated Values (CSV) ( ) Excel ( ) 1 1 (item) 1 ( ) 1 5
6 ( ) ( ) [ ] [ ][ ] ( ) 6
7 ( ) /tsunogai/kougi/09/jolite.html kendata.csv [ ] [Save Link As...] O: 7
8 (Excel ) kendata.csv Excel (.xlsx) MS-Excel kendata.csv [ ] [Excel ] : A0nxxyyy-1130(.xlsx) ( - ) ([ ] [Ctrl+s]) 8
![csv [ ] [Excel ] :](/docs-images/51/20160569/images/page_8.jpg "A0nxxyyy-1130(.")
9 ( ) 17 [ ] [ ] [ ][ ] ( ) ( ) 9
![][ ] ( )](/docs-images/51/20160569/images/page_9.jpg "( ) 9")
10 : [ ] [ ] : [Shift+ ] [ ] : [Shift+ ] : [Ctrl+ ] : (1,2, ) : (A,B, ) : [Ctrl+a] 10
![[Ctrl+ ] : (1,2, ) :](/docs-images/51/20160569/images/page_10.jpg "(A,B, ) : [Ctrl+a]")
11 ( ) C2 C3 C49 C2 =SUM(C3:C49) SUM (function) 11
12 ( ) C2 C3 C49 C2 =SUM(C3:C49) SUM (function) 11
13 ( ) : C2 =SUM(C3:C49) 12 D2 =SUM(D3:D49) C2 D2 OK ( ): [Ctrl+c] ( ): [Ctrl+v]? 12
14 ( ) : C2 =SUM(C3:C49) 12 D2 =SUM(D3:D49) C2 D2 OK ( ): [Ctrl+c] ( ): [Ctrl+v]? 12
15 ( ) C2 =SUM(C3:C49) 1 47 D2 D =SUM(D3:D49) (D3 D49 ) 17 13
16 ( ) C2 =SUM(C3:C49) 1 47 D2 D =SUM(D3:D49) (D3 D49 ) 17 13
17 ( ) C2 =SUM(C3:C49) 1 47 D2 D =SUM(D3:D49) (D3 D49 ) 17 13
18 ( ) F2 =E2-D2 ( ) 17 14
19 ( ) F2 =E2-D2 ( ) 17 14
20 ( ) G (!!) G [ ][ ] [ ][ ][ ] ( [ ] ) 15
![] [ ][ ][](/docs-images/51/20160569/images/page_20.jpg "] ( [ ] )")
21 ( ) G (!!) G [ ][ ] [ ][ ][ ] ( [ ] ) 15
22 ( ) G [ ][ ] [ ][ ][ ] ( [ ] ) 3, 16
23 !! 17
24 !! 17
25 !! 17
26 ( ) ( ) 18
27 ( )!! 19
28 ( )!! 19
29 ? ( ) 20
30 ? ( ) 20
31 ? ( ) 20
32 ( ) H3 =C3/C2!!? 21
33 ( ) H3 =C3/C2!!? 21
34 H3 =C3/C2 H4 =C4/C2 H5 =C5/C2 C2!! H3 =C3/$C$2 ( ) 22
35 H3 =C3/C2 H4 =C4/C2 H5 =C5/C2 C2!! H3 =C3/$C$2 ( ) 22
36 H3 =C3/C2 H4 =C4/C2 H5 =C5/C2 C2!! H3 =C3/$C$2 ( ) 22
37 ( % ) H3 =C3/$C$2 % G [ ][ ][ ] [ ][ ] ( [ ] ) 17 23
38 ( ) G 1 G [ ] [ ] ( ) A B IF G3 =IF(E3>=5000,"A","B") ( " " ) 24
39 ( ) G 1 G [ ] [ ] ( ) A B IF G3 =IF(E3>=5000,"A","B") ( " " ) 24
40 ( ) IF : IF( P,xxx,yyy) P xxx yyy ( ) 25
41 (TRUE) (FALSE) (TRUE) = <> > < >= <= 26
42 ( (TRUE) (FALSE)) (TRUE) (FALSE) ( ) AND(P 1,P 2,...) OR(P 1,P 2,...) NOT(P) TRUE() FALSE() P i 1 P i P ( ) ( ) 27
43 ( ) IF IF( 1,xxx,IF( 2,yyy,zzz)) 1 xxx 1 2 yyy 2 zzz (LOOKUP VLOOKUP ) 28
44 ( ) G ( ) A 1000( ) 5000( ) B C G3 =IF(E3>=5000,"A", ) 29
45 ( ) G ( ) A 1000( ) B C G3 =IF(E3>=5000,"A", ) 30
46 ( ) ( ) G2 COUNTIF : COUNTIF(, ) G2 =COUNTIF(G3:G49,"A") ( ) 31
47 ( ) ( C) 1 VLOOKUP : VLOOKUP(,,, ) 32
48 ( ) ( C) 1 VLOOKUP : VLOOKUP(,,, ) 32
49 ( ) Excel [ ] kendata.xlsx [ ] C3 =VLOOKUP(A3,,n,FALSE) : ( ) 1 n FALSE 33
50 : 1130 (!!) 1 MS-Excel A0nxxyyy-1130.xlsx ( - ) (!!) 34
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
http://banso.cocolog-nifty.com/ 100 100 250 5 1 1 http://www.banso.com/ 2009 5 2 10 http://www.banso.com/ 2009 5 2 http://www.banso.com/ 2009 5 2 http://www.banso.com/ < /> < /> / http://www.banso.com/
n=360 28.6% 34.4% 36.9% n=360 2.5% 17.8% 19.2% n=64 0.8% 0.3% n=69 1.7% 3.6% 0.6% 1.4% 1.9% < > n=218 1.4% 5.6% 3.1% 60.6% 0.6% 6.9% 10.8% 6.4% 10.3% 33.1% 1.4% 3.6% 1.1% 0.0% 3.1% n=360 0% 50%
... 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
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
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..............................................
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
untitled
280 200 5 7,800 6 8,600 28 1 1 18 7 8 2 ( 31 ) 7 42 2 / / / / / / / / / / 1 3 (1) 4 5 3 1 1 1 A B C D 6 (1) -----) (2) -- ()) (3) ----(). ()() () ( )( )( )( ) ( ) ( )( )( )( ) () (). () ()() 7 () ( ) 1
●70974_100_AC009160_KAPヘ<3099>ーシス自動車約款（11.10）.indb
" # $ % & ' ( ) * +, -. / 0 1 2 3 4 5 6 7 8 9 : ; < = >? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y " # $ % & ' ( ) * + , -. / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B
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
橡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
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
untitled
...1... 3 1... 3 2... 4 3... 4 4... 5...... 6 1... 6 2... 7 3... 8 4... 9 5... 10... 12 1... 12 2... 13 3... 14 4... 16...... 19 1... 19 2... 20 3... 22 4... 24...... 25... 26 1... 26 2... 26 3... 26......
1 6-1 6-2 6-3 104
e-tax 1 6-1...89...93 6-2...96...98 6-3...100...100...101...102 1 6-1 6-2 6-3 104 6-1 102 104 101 7 1. 2. 3. 4. > 7-4 93 > 30 OK 6-2 e-tax 2-4 1. 2. 3. 30 4. OK 1. OK [OK] 2 98 16 OK OK 7 OK 1. 2. 3.
はじめての帳票作成
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
ワードプロセッシングについて
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)
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
案 内 2016 8 2 3 4 2 2 3 1 1-4 - 1 1-5 - 1 1-6 - 1 1-7 - 1 1-8 - 1 1-9 - 1 1-10 - 1 1-11 - 1 1-12 - 1 1-13 - 1 1-14 - 1 1-15 - 1 1-16 - 1 1-17 - 1 1 1,000 1,200 400 2,000-18 - 1 1-19 - 1
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
-----------------------------------------------------------------------------------------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
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 µ µ Ž ƒ
EXCEL入門
EXCEL :nishimura Excel EXCELL 1. 2. 12 1 2 3 ExcelWord EXCEL Excel (F) (E) (V) (I) (O) (T) (D) (W) (N) (A)(S) (F) (H)Office (C) (T) (V) (T)(C)(V) (T)(C) 1 (T) (O) (I) (E) (B) Word Excel [Ctrl] +[] 3
2
1 2 10 14 945 3000 2012 3 10 4 5 6 7 8 9 10 11 12 2011 11 21 12301430 (1215 ) 13 6 27 17 () ( ) ( ) (112360) 2 (1157) (119099) ((11861231) )( ) (11641205) 3 (1277) 3 4 (1558) (1639)() 12 (1699)( ) 7 (1722)
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
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
システムの概要
- i - - ii - 1 Excel BCS.CSV Excel BCS.CSV Excel A B C D Excel BCS.CSV - 1 - 2 Excel (V) (T) AB AB - 2 - 3 A B A B B C B C 1 B A - 3 - 1 C B 4 1 5 6 BCS - 4 - 4 1 Excel - 5 - 32 30 Excel Alt+Enter 1-6
橡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
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
account4-1.PDF
12 8 23 13 1 1 2 4 13 TEL 1 13 1 12 2 1 12 4 30 13 1 1 2 13 1 1 Office 13 1 1 13 1 1 1 12 2 1 12 4 30 99 3 office 3.1 4 office 426 147 85 3 6 12 2 1 13 1 31 office 5 2 3 4 5 6 7 8 12 2 1 12 4 30 11 8 1