Symphonymaster.ps
|
|
|
- ああす もちやま
- 7 years ago
- Views:
Transcription
1 IBM SmartCloud Docs 1.0
2 ii IBM SmartCloud Docs
3 PDF Excel PDF iii
4 PDF iv IBM SmartCloud Docs
5 1 IBM SmartCloud Docs IBM SmartCloud Docs IBM SmartCloud Docs IBM SmartCloud Docs IBM SmartCloud Docs IBM SmartCloud Docs v 3 2 v 57 3 v IBM SmartCloud for Social Business wiki IBM Corporation 2012,2013 1
6 2 IBM SmartCloud Docs
7 2 Lotus Symphony Microsoft Word IBM SmartCloud Docs IBM SmartCloud Docs v v 8 v 12 v 16 v 25 v 41 v 42 v 20 IBM SmartCloud for Social Business wiki.doc.docx.odt.txt.ott IBM Corporation 2011,2012 3
8 : 1. IBM Docs IBM Docs 2. > > > 4 IBM SmartCloud Docs
9 3. OK OK : > > :
10 : x 3. : 4. ( ) YourOrganizationName v v 3. v v : 4. 6 IBM SmartCloud Docs
11 5. :.doc.docx.txt.odt.ott IBM Docs.doc.pdf 25 () : 9 IBM Docs.doc.docx.txt.odt.ott IBM Docs 4. IBM Docs IBM Docs : IBM Docs 2 7
12 : IBM Docs.doc.pdf 25 () : 9 IBM Docs Microsoft Word IBM Docs 1. Word IBM Docs IBM Docs? 4. OK IBM Docs IBM Docs 8 IBM SmartCloud Docs
13 IBM Docs 1. IBM Docs Lotus Symphony Documents.odt.ott Microsoft Word.doc.docx.dot TXT.txt 2. IBM Docs Lotus Symphony Documents.odt Microsoft Word.doc Adobe Reader.pdf : IBM Docs Symphony OpenDocument 2 9
14 : 5 7.doc.docx.txt.odt.ott IBM Docs.doc.pdf 25 () () : 1. > : IBM Docs 2. > OK 10 IBM SmartCloud Docs
15 : IBM Docs Open Office Microsoft Microsoft Office.odt.odp.ods IBM Docs Open Office IBM Docs 1. > 2. : 3. IBM Docs.doc.pdf IBM Docs OpenDocument (.odf).odt IBM Docs Microsoft Office Word.odt (Microsoft Office PDF ) Microsoft Office PDF : 4. : PDF OK 2 11
16 : 5 7.doc.docx.txt.odt.ott () : 9 IBM Docs () IBM SmartCloud Docs
17 3. 4. a. b. c. v v : d. 5. : YourOrganizationName
18 : 17 : 5 7.doc.docx.txt.odt.ott 11 IBM Docs.doc.pdf 25 () : 9 IBM Docs IBM SmartCloud Docs
19 4. v x v v 2 15
20 : 17 : 5 7.doc.docx.txt.odt.ott IBM Docs.doc.pdf 25 () : 9 IBM Docs IBM Docs IBM Docs 16 IBM SmartCloud Docs
21 2 17
22 Linda IT Linda 5 IT IBM Docs Linda Linda IBM Docs 5 Linda : IBM Docs : IBM Docs IBM Docs? 18 IBM SmartCloud Docs
23 IBM Docs IBM Docs : 5. > 6. : OK : 17 : > : 2 19
24 : 17 : IBM Docs 20 IBM SmartCloud Docs
25 @ Tina Tina Tina Tina Tina 2 21
26 : > 3. Enter Enter IBM SmartCloud Docs
27 7. 8. > : 20 IBM Docs : >
28 : : 20 IBM Docs : > IBM SmartCloud Docs
29 4. Enter : 20 IBM Docs : () 2 25
30 : 5 7.doc.docx.txt.odt.ott IBM Docs.doc.pdf : 9 IBM Docs () v > > > > 26 IBM SmartCloud Docs
31 > > > > v v : H 2 O a
32 1. 2. > : > > 28 IBM SmartCloud Docs
33 : > : 2 29
34 : > 3. > : 30 IBM SmartCloud Docs
35 : v Enter 1 : () Enter
36 v Enter 1 : () Enter IBM SmartCloud Docs
37 > :
38 1. 2. > 3. : 4. OK 5. v v Tab Shift+Tab : : > Enter Tab Enter Enter 34 IBM SmartCloud Docs
39 Web 1. > 2. URL Web URL URL 3. OK 4. > 2 35
40 1 v 1. > : OK v 8. : 1. > 36 IBM SmartCloud Docs
41 2. 3. : OK : : : > > > 2 37
42 6. > v 1. > >. v 2. OK 1. > >. v 2. OK IBM SmartCloud Docs
43 3. : 35 IBM Docs 1. > 2. > 3. v 1 v v v 4. > 2 39
44 1. > 2. : IBM Docs 3. 2 : ( ) OK PDF PDF 1. > PDF 2. PDF PDF PDF 40 IBM SmartCloud Docs
45 3. OK OK Adobe Reader Adobe Reader 6. Adobe Reader > 7. OK 1. > OK :
46 OK : : 41 1 v > 42 IBM SmartCloud Docs
47 v OK
48 3. 1 : / > 44 IBM SmartCloud Docs 2.
49 3. OK : OK > : v > > v : > > 2 45
50 : : / 48 v > > : > v > > : > 46 IBM SmartCloud Docs
51 : / 48 v > v > v > v v v
52 : / / : : IBM SmartCloud Docs
53 v v v v > > > > : / 3. > > 2 49
54 3. () > Enter 2 > > > > > > > > > > > > > 50 IBM SmartCloud Docs
55 3. () 4. > > > > 2 51
56 4. () > > 1 > > 5. ( ) > > 6. > > > 52 IBM SmartCloud Docs
57 Windows Mac OS Ctrl Command IBM SmartCloud for Social Business wiki 7. IBM Docs 1 1 Tab 1 Ctrl+A Ctrl+B Ctrl+I Ctrl+S Ctrl+U Ctrl+Y Ctrl+Shift+Z Ctrl+Z Ctrl+Home Ctrl+End Ctrl+Shift+E Ctrl+Shift+L Ctrl+Shift+R Ctrl+Shift+J Ctrl+M Ctrl+Q Shift+Ctrl+M Page Up Page Down Esc 1 Shift+ 1 Shift+ 1 Shift+ 1 Shift+ Shift+Enter Alt+Shift+F Mac OS 2 53
58 7. IBM Docs () Mac OS Mac OS Mac OS Mac OS Mac OS Mac OS Mac OS Mac OS Alt+Shift+E Alt+Shift+V Alt+Shift+I Alt+Shift+M Alt+Shift+B Alt+Shift+A Alt+Shift+T Alt+Shift+H : IBM Docs 1 Alt+ Shift+* Alt+F10 Enter Ctrl+Alt+O Ctrl+Shift+H Ctrl+Alt+O Ctrl+Shift+F Ctrl+P Ctrl+. Ctrl+, Ctrl+Shift+0 1 Ctrl+Shift+1 2 Ctrl+Shift+2 3 Ctrl+Shift+3 4 Ctrl+Shift+4 5 Ctrl+Shift+5 6 Ctrl+Shift+6 Ctrl+K Shift+F2 Esc Shift+Tab 54 IBM SmartCloud Docs
59 7. IBM Docs () Ctrl+Shift+H Alt+F10 Ctrl+Shift+F Alt+F
60 56 IBM SmartCloud Docs
61 3 IBM SmartCloud Docs IBM SmartCloud Docs v v 67 v 71 v 76 v 83 v 100 IBM SmartCloud for Social Business wiki Web 1. IBM Docs 2. > > > 57
62 3. : ( ) 4. OK : 83 : 61 IBM Lotus Symphony Web IBM Lotus Symphony (.ods) Microsoft Excel (.xls.xlsx) IBM SmartCloud Docs
63 1. 2. : x 3. : 4. ( ) 3 59
64 YourOrganizationName v v 3. v v : IBM SmartCloud Docs
65 : : 62 Web IBM Lotus Symphony Web IBM Lotus Symphony (.ods) Microsoft Excel (.xls.xlsx) : 5, IBM Docs IBM Docs : IBM Docs 3 61
66 : IBM Docs.xls.pdf : Web Excel Microsoft Excel IBM Docs 1. Excel IBM Docs IBM Docs? 4. OK IBM Docs IBM Docs Web 62 IBM SmartCloud Docs
67 8. IBM Docs Spreadsheets IBM Lotus Symphony Spreadsheets.ods.ots Microsoft Excel.xls.xlsx.xlt 9. IBM Docs Spreadsheets IBM Lotus Symphony Spreadsheets.ods Microsoft Excel.xls Adobe Reader.pdf : IBM Docs Symphony OpenDocument 3 63
68 : IBM Lotus Symphony Web IBM Lotus Symphony (.ods) Microsoft Excel (.xls.xlsx) 66 IBM Docs.xls.pdf 65 () : 1. > : IBM Docs 2. > OK 64 IBM SmartCloud Docs
69 : > 2. :
70 : IBM Lotus Symphony Web IBM Lotus Symphony (.ods) Microsoft Excel (.xls.xlsx) IBM Docs.xls.pdf 64 () 67 : 62 Web IBM Docs.xls.pdf IBM Docs OpenDocument (.odf).ods IBM Docs Microsoft Excel.ods (Microsoft Office PDF ) Microsoft Office PDF 66 IBM SmartCloud Docs
71 : 4. : PDF OK : 61 IBM Lotus Symphony Web IBM Lotus Symphony (.ods) Microsoft Excel (.xls.xlsx) 65 : 62 Web ( )
72 a. b. c. v v : d. 5. : YourOrganizationName IBM SmartCloud Docs
73 : 72 IBM Docs 76 IBM Docs : ()
74 v x v v 70 IBM SmartCloud Docs
75 : 72 IBM Docs 76 IBM Docs :
76 IBM Docs IBM Docs IBM Docs 72 IBM SmartCloud Docs
77 USB Lotus Symphony Microsoft Office Lotus Symphony Windows Linux Mac OS IBM Docs IBM Docs IBM Docs Linda IT Linda 5 IT Linda IBM Docs Linda Linda 5 Linda 5 Linda 3 73
78 : 86 ( ) IBM Docs : : IBM Docs 74 IBM SmartCloud Docs
79 : IBM Docs IBM Docs? IBM Docs IBM Docs : 5. > 6. : OK : 72 IBM Docs :
80 > : : 72 IBM Docs : IBM Docs 76 IBM SmartCloud Docs
81 @ Tina Tina Tina Tina Tina 3 77
82 : > 3. Enter 78 IBM SmartCloud Docs
83 4. 5. : 1 1 > 6. Enter > 3 79
84 : 76 IBM Docs : > IBM SmartCloud Docs
85 :
86 : 76 IBM Docs : > Enter IBM SmartCloud Docs
87 6. : 76 IBM Docs : :
88 84 IBM SmartCloud Docs
89 : 57 : > > 3 85
90 : 83 : 57 : 193 ( ) IBM Docs $25.45 % 12:31:57 (HH:MM:SS) > : IBM Docs Microsoft Excel IBM Symphony ( ) IBM Docs 2 2 3e E IBM SmartCloud Docs
91 ,235 1, % : 100 (.08 8% ) $ E+03 : IBM Docs (.) (,) Web > > US 3 87
92 : 72 IBM Docs : 193 IBM Docs Enter 2011, ( ) 88 IBM SmartCloud Docs
93 : v v v / / : v 1. > OK v 1. >
94 6. OK Web 1 1. URL ( 2. Enter 3. URL URL 4. URL : URL URL IBM SmartCloud Docs 3.
95 : 90 Web v v v v : v v 3 91
96 v / 1. > 2. v v IBM SmartCloud Docs
97 PDF PDF 1. > PDF 2. v v v v PDFPDF PDF v 3 93
98 3. OK OK Adobe Reader Adobe Reader 6. Adobe Reader > 7. OK 1. > 94 IBM SmartCloud Docs OK 1. 2.
99 3. A1:B4 1 Unicode 1. : ( ) 2. > ( ) > 3. Alt OK Esc
100 1. a. 1 b. > 2. a. : b. > 3. : 1. v 1 > v 2. v > v : IBM SmartCloud Docs
101 2 A1 =Sheet1!A1 1 A1 2 A1 1 A : Enter Web Web () Ctrl+C Ctrl+V 2 Web Ctrl+V Web 1. : 2. Web Web 3 97
102 : > > 3. : ( ) (_) r c IBM Docs (Q2 FY98) / v v 5. OK 98 IBM SmartCloud Docs
103 1. > > v v > > 2. X 3. OK
104 IBM Docs IBM Docs 1 ( B25) =A1+A2 A4 B4 B4 =B1+B2 IBM Docs $B$25 ($) $Sheet2!$B$25 $ : 100 IBM SmartCloud Docs
105 (=) Enter (!) ( Sheet2!A1 Sheet2!A1:A4) (,) (=SUM(Sheet1!A1,5,1234) ( 1,234) 2 ("1, 234") (1234) (;) : IBM Lotus Symphony (.)! (;), 11. =A1+10 =A1*16% =A1*A2 =ROUND(A1,1) =B8-SUM(B10:B14) =SUM(B8,SUM(B10:B14)) A1 10 A1 16 A1 A2 1 A1 B10 B14 B8 B10 B14 B
106 11. () =SUM(B1:B65536) =IF(trim(A1)="","Cell should not be empty",a1) B : + - * / =SUM(A1:B1) =A1+B1 =(1+2)*3 =1+2*3 : */%^ & =<><=>=<> :, : 100 FREQUENCY FREQUENCY FREQUENCY (NumberSequenceList_data,NumberSequenceList_bins) NumberSequenceList_data NumberSequenceList_bins A B A FREQUENCY B IBM SmartCloud Docs
107 B2 10 FREQUENCY B6 > FREQUENCY A B C > FREQUENCY B 1 ( ) C1:C6 {=FREQUENCY(A1:A11,B1:B5)} C1:C5 MMULT MMULT MMULT (array1,array2) array1 1 2 array2 1 2 MMULT 1 2 Enter SUMPRODUCT SUMPRODUCT 3 103
108 SUMPRODUCT (array1,array2,...array30) array1, array2,...array =SUMPRODUCT(A1:D1,A2:D2,A3:D3) 158 A1:D1 A2:D2 A3:D3 SUMPRODUCT SUMPRODUCT A B C D $5.00 $20.00 $ $ IBM Docs { } ( ) (TRUE FALSE) (,) 15. ={1,2,3} IBM SmartCloud Docs
109 15. () =SIN({1,2,3}) SIN IF() {=IF(A1:A3>0,"yes","no")} >0 A1:A3 16. A B ( ) B () 1 1 {=IF(A1:A3>0,"yes","no")} 2 0 {=IF(A1:A3>0,"yes","no")} no 3 1 {=IF(A1:A3>0,"yes","no")} DATE DATE DATE 0 =DATE(00,12,31) 12/31/00 =DATE(00,13,31) 1/31/01 DATE( ) DATE =DATE(09,1,3) 1/3/09 3 January
110 : 118 TODAY TODAY 2000/02/2 ( ) 121 YEAR YEAR 114 NOW NOW 112 MONTH MONTH DAY DAY SECOND SECOND HOUR HOUR MINUTE MINUTE 0 59 DATEDIF 2 DATEDIF (,, ) 17. Y M D MD () YM () YD () 106 IBM SmartCloud Docs
111 =DATEDIF(" "," ","YD") 29 =DATEDIF(" "," ","YD") 28 : 108 DAYS DAYS 2 2 DAY DAY 1 31 DAY() =DAY(1) 31 =DAY(NOW()) =DAY(C4) C4 1901/12/31 31 : IBM Docs Microsoft Excel 3/1/
112 : 105 DATE DATE DATE 0 =DATE(00,12,31) 12/31/00 =DATE(00,13,31) 1/31/ TODAY TODAY 2000/02/2 ( ) 121 YEAR YEAR 114 NOW NOW 112 MONTH MONTH HOUR HOUR MINUTE MINUTE SECOND SECOND WEEKDAY WEEKDAY 1 7 DAYS DAYS 2 2 DAYS( 2 1) IBM SmartCloud Docs
113 =DAYS("1/1/2015",NOW()) =DAYS("10/10/1990","10/10/1980") 3652 : 106 DATEDIF 2 HOUR HOUR 0 23 HOUR() =HOUR(NOW()) C4 17:20:00 =HOUR(C4) 17 =HOUR(0.5) /30/ :00:
114 110 IBM SmartCloud Docs : 107 DAY DAY 1 31 MINUTE MINUTE MONTH MONTH NOW NOW 115 SECOND SECOND TODAY TODAY 2000/02/2 ( ) 119 WEEKDAY WEEKDAY YEAR YEAR 105 DATE DATE DATE 0 =DATE(00,12,31) 12/31/00 =DATE(00,13,31) 1/31/ TIME TIME MINUTE MINUTE 0 59 MINUTE()
115 =MINUTE(NOW()) C4 17:20:00 =MINUTE(C4) 20 =MINUTE(0, ) 20 =MINUTE(20/(24*60)) 12/30/ :20:
116 112 IBM SmartCloud Docs : 107 DAY DAY HOUR HOUR 0 23 MONTH MONTH NOW NOW 115 SECOND SECOND TODAY TODAY 2000/02/2 ( ) 119 WEEKDAY WEEKDAY YEAR YEAR 105 DATE DATE DATE 0 =DATE(00,12,31) 12/31/00 =DATE(00,13,31) 1/31/ TIME TIME MONTH MONTH 1 12 MONTH()
117 =MONTH(1) 1 12/31/ : IBM Docs Microsoft Excel 1/31/ /31/ /30/ : 105 DATE DATE DATE 0 =DATE(00,12,31) 12/31/00 =DATE(00,13,31) 1/31/ TODAY TODAY 2000/02/2 ( ) 121 YEAR YEAR 114 NOW NOW 107 DAY DAY HOUR HOUR MINUTE MINUTE SECOND SECOND WEEKDAY WEEKDAY 1 7 NETWORKDAYS NETWORKDAYS 3 113
118 NETWORKDAYS () C3 (12/15/2001) D3 (1/15/2002) F3 J3 : "12/24/2001" "12/25/2001" "12/26/2001" "12/ 31/2001" "1/1/2002" =NETWORKDAYS(C3,D3,F3:J3) 17 NOW NOW NOW() =NOW()-A1 A1 114 IBM SmartCloud Docs
119 : 105 DATE DATE DATE 0 =DATE(00,12,31) 12/31/00 =DATE(00,13,31) 1/31/ TODAY TODAY 2000/02/2 ( ) 121 YEAR YEAR 112 MONTH MONTH DAY DAY HOUR HOUR MINUTE MINUTE 0 59 SECOND SECOND WEEKDAY WEEKDAY TIME TIME SECOND SECOND 0 59 SECOND() 3 115
120 =SECOND(NOW()) C4 17:20:17 =SECOND(C4) 17 =SECOND( )) 17 =SECOND(17/ (24*60*60)) 12/30/ :00: IBM SmartCloud Docs
121 : 107 DAY DAY HOUR HOUR MINUTE MINUTE MONTH MONTH NOW NOW 118 TODAY TODAY 2000/02/2 ( ) 119 WEEKDAY WEEKDAY YEAR YEAR 105 DATE DATE DATE 0 =DATE(00,12,31) 12/31/00 =DATE(00,13,31) 1/31/01 TIME TIME TIME TIME TIME() 3 117
122 =TIME("0,0,0") 00:00:00 =TIME("4,20,4") 04:20:04 : 109 HOUR HOUR MINUTE MINUTE NOW NOW 115 SECOND SECOND 0 59 TODAY TODAY 2000/02/2 ( ) TODAY() TODAY =TODAY() 118 IBM SmartCloud Docs
123 : 105 DATE DATE DATE 0 =DATE(00,12,31) 12/31/00 =DATE(00,13,31) 1/31/ YEAR YEAR 114 NOW NOW 112 MONTH MONTH DAY DAY HOUR HOUR MINUTE MINUTE SECOND SECOND 0 59 WEEKDAY WEEKDAY 1 7 WEEKDAY WEEKDAY 1 7 WEEKDAY(, ) 3 119
124 ( ) () 1 ( ) 1 ( ) 7( ) 2 1 ( ) 7( ) 3 0 ( ) 6( ) 11 1 ( ) 7( ) 12 1 ( ) 7( ) 13 1 ( ) 7( ) 14 1 ( ) 7( ) 15 1 ( ) 7( ) 16 1 ( ) 7( ) 17 1 ( ) 7( ) WEEKDAY("6/14/2000") WEEKDAY("7/24/1996",1) WEEKDAY("7/24/1996",2) WEEKDAY(NOW()) A1 IF WEEKDAY : IF(WEEKDAY(A1,2)<6,"businessday","weekend") 120 IBM SmartCloud Docs
125 : 107 DAY DAY HOUR HOUR MINUTE MINUTE MONTH MONTH NOW NOW 115 SECOND SECOND TODAY TODAY 2000/02/2 ( ) YEAR YEAR WEEKNUM WEEKNUM WEEKNUM (, ) 1 =2 = ( 1) =WEEKNUM(" ",1)and =WEEKNUM(" ",2)and IBM Docs ( ) YEAR YEAR 3 121
126 YEAR() =YEAR(1) 1 12/31/ =YEAR(367) 367 1/1/ : IBM Docs Microsoft Excel 1/1/ IBM SmartCloud Docs
127 : 105 DATE DATE DATE 0 =DATE(00,12,31) 12/31/00 =DATE(00,13,31) 1/31/ TODAY TODAY 2000/02/2 ( ) 114 NOW NOW 112 MONTH MONTH DAY DAY HOUR HOUR MINUTE MINUTE SECOND SECOND WEEKDAY WEEKDAY 1 7 CONVERT CONVERT CONVERT(number,from_unit,to_unit) number 3 123
128 from_unit from-unit ""( ) to_unit to-unit ""( ) /from_unit to_unit CONVERT #N/A from_unit to_unit CONVERT #N/A 19. g sg lbm u ozm () U () () 20. m mi Nmi in ft yd ang 21. yr day hr mn sec 22. Pa atm mmhg 124 IBM SmartCloud Docs
129 23. N dyn lbf 24. J e c cal ev HPh Wh flb BTU IT BTU 25. HP W 26. T ga 27. C F K 28. tsp tbs oz cup pt qt 3 125
130 28. () gal l (" " ) CONVERT #N/A 29. E 1E+18 P 1E+15 T 1E+12 G 1E+09 M 1E+06 k 1E+03 h 1E+02 e 1E+01 d 1E-01 c 1E-02 m 1E-03 u 1E-06 n 1E-09 p 1E-12 f 1E-15 a 1E-18 CONVERT(10, "C", "F") 50 CONVERT(1,"sec","msec") C D 2 X Y IBM SmartCloud Docs
131 30. () C D ERRORTYPE ERRORTYPE ERRORTYPE() A1 :518 =ERRORTYPE(A1)
132 : 129 ISBLANK ISBLANK TRUE 135 ISEVEN ISEVEN TRUE FALSE 147 ISODD ISODD TRUE FALSE 154 TYPE TYPE 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 143 ISNONTEXT ISNONTEXT FALSE 145 ISNUMBER ISNUMBER TRUE 151 ISTEXT ISTEXT TRUE 148 ISREF ISREF FORMULA 128 IBM SmartCloud Docs
133 FORMULA ( FORMULA ) #N/A FORMULA() A8 23 A1 FORMULA A8 ISBLANK ISBLANK TRUE ISBLANK( ) =ISBLANK(D2) FALSE 3 129
134 : 127 ERRORTYPE ERRORTYPE 135 ISEVEN ISEVEN TRUE FALSE 147 ISODD ISODD TRUE FALSE 154 TYPE TYPE 153 NA NA #N/A 148 ISREF ISREF 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 136 ISFORMULA ISFORMULA 143 ISNONTEXT ISNONTEXT FALSE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 151 ISTEXT ISTEXT TRUE 130 IBM SmartCloud Docs
135 145 ISNUMBER ISNUMBER TRUE ISERR ISERR #N/A TRUE ISERR( ) #N/A =ISERR(C5) FALSE 3 131
136 : 127 ERRORTYPE ERRORTYPE 135 ISEVEN ISEVEN TRUE FALSE 147 ISODD ISODD TRUE FALSE 154 TYPE TYPE 153 NA NA #N/A 148 ISREF ISREF 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 136 ISFORMULA ISFORMULA 143 ISNONTEXT ISNONTEXT FALSE 129 ISBLANK ISBLANK TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 151 ISTEXT ISTEXT TRUE 132 IBM SmartCloud Docs
137 145 ISNUMBER ISNUMBER TRUE ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE ISERROR( ) =ISERROR(C8) FALSE 3 133
138 : 127 ERRORTYPE ERRORTYPE 135 ISEVEN ISEVEN TRUE FALSE 147 ISODD ISODD TRUE FALSE 154 TYPE TYPE 153 NA NA #N/A 148 ISREF ISREF 131 ISERR ISERR #N/A TRUE 136 ISFORMULA ISFORMULA 143 ISNONTEXT ISNONTEXT FALSE 129 ISBLANK ISBLANK TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 151 ISTEXT ISTEXT TRUE 134 IBM SmartCloud Docs
139 145 ISNUMBER ISNUMBER TRUE ISEVEN ISEVEN TRUE FALSE ISEVEN( ) =ISEVEN(48) TRUE =ISEVEN(33) FALSE =ISEVEN(0) TRUE =ISEVEN(-2.1) TRUE =ISEVEN(3.999) FALSE 3 135
140 136 IBM SmartCloud Docs : 129 ISBLANK ISBLANK TRUE 127 ERRORTYPE ERRORTYPE 147 ISODD ISODD TRUE FALSE 154 TYPE TYPE 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 143 ISNONTEXT ISNONTEXT FALSE 145 ISNUMBER ISNUMBER TRUE 151 ISTEXT ISTEXT TRUE 148 ISREF ISREF ISFORMULA
141 ISFORMULA ISFORMULA() =ISFORMULA(C4) FALSE 3 137
142 138 IBM SmartCloud Docs : 153 NA NA #N/A 148 ISREF ISREF 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 143 ISNONTEXT ISNONTEXT FALSE 129 ISBLANK ISBLANK TRUE ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 151 ISTEXT ISTEXT TRUE 145 ISNUMBER ISNUMBER TRUE ISLOGICAL ISLOGICAL TRUE TRUE FALSE ISLOGICAL( )
143 =ISLOGICAL(D5) FALSE 3 139
144 : 127 ERRORTYPE ERRORTYPE 135 ISEVEN ISEVEN TRUE FALSE 147 ISODD ISODD TRUE FALSE 154 TYPE TYPE 153 NA NA #N/A 148 ISREF ISREF 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 136 ISFORMULA ISFORMULA 143 ISNONTEXT ISNONTEXT FALSE 129 ISBLANK ISBLANK TRUE 141 ISNA ISNA #N/A ( ) TRUE 151 ISTEXT ISTEXT TRUE 140 IBM SmartCloud Docs
145 145 ISNUMBER ISNUMBER TRUE ISNA ISNA #N/A ( ) TRUE ISNA( ) =ISNA(D3) FALSE 3 141
146 : 127 ERRORTYPE ERRORTYPE 135 ISEVEN ISEVEN TRUE FALSE 147 ISODD ISODD TRUE FALSE 154 TYPE TYPE 153 NA NA #N/A 148 ISREF ISREF 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 136 ISFORMULA ISFORMULA 143 ISNONTEXT ISNONTEXT FALSE 129 ISBLANK ISBLANK TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 151 ISTEXT ISTEXT TRUE 142 IBM SmartCloud Docs
147 145 ISNUMBER ISNUMBER TRUE ISNONTEXT ISNONTEXT FALSE ISNONTEXT( ) ( ) =ISNONTEXT(D2) FALSE =ISNONTEXT(D9) TRUE 3 143
148 : 127 ERRORTYPE ERRORTYPE 135 ISEVEN ISEVEN TRUE FALSE 147 ISODD ISODD TRUE FALSE 154 TYPE TYPE 153 NA NA #N/A 148 ISREF ISREF 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 136 ISFORMULA ISFORMULA 129 ISBLANK ISBLANK TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 151 ISTEXT ISTEXT TRUE 144 IBM SmartCloud Docs
149 ISNUMBER ISNUMBER TRUE ISNUMBER ISNUMBER TRUE ISNUMBER( ) =ISNUMBER(C3) TRUE =ISNUMBER(C2) FALSE 3 145
150 : 127 ERRORTYPE ERRORTYPE 135 ISEVEN ISEVEN TRUE FALSE 147 ISODD ISODD TRUE FALSE 154 TYPE TYPE 153 NA NA #N/A 148 ISREF ISREF 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 136 ISFORMULA ISFORMULA 143 ISNONTEXT ISNONTEXT FALSE 129 ISBLANK ISBLANK TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 146 IBM SmartCloud Docs
151 151 ISTEXT ISTEXT TRUE ISODD ISODD TRUE FALSE ISODD( ) =ISODD(33) TRUE =ISODD(48) FALSE =ISODD(3.999) TRUE =ISODD(-3.1) TRUE 3 147
152 148 IBM SmartCloud Docs : 129 ISBLANK ISBLANK TRUE 127 ERRORTYPE ERRORTYPE 135 ISEVEN ISEVEN TRUE FALSE 154 TYPE TYPE 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 143 ISNONTEXT ISNONTEXT FALSE 145 ISNUMBER ISNUMBER TRUE 151 ISTEXT ISTEXT TRUE ISREF ISREF ISREF
153 ISREF ISREF( ) =ISREF(C5) TRUE 3 149
154 : 127 ERRORTYPE ERRORTYPE 135 ISEVEN ISEVEN TRUE FALSE 147 ISODD ISODD TRUE FALSE 154 TYPE TYPE 153 NA NA #N/A 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 136 ISFORMULA ISFORMULA 143 ISNONTEXT ISNONTEXT FALSE 129 ISBLANK ISBLANK TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 151 ISTEXT ISTEXT TRUE 150 IBM SmartCloud Docs
155 145 ISNUMBER ISNUMBER TRUE ISTEXT ISTEXT TRUE ISTEXT( ) =ISTEXT(D9) TRUE =ISTEXT(C3) FALSE 3 151
156 : 127 ERRORTYPE ERRORTYPE 135 ISEVEN ISEVEN TRUE FALSE 147 ISODD ISODD TRUE FALSE 154 TYPE TYPE 153 NA NA #N/A 148 ISREF ISREF 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 136 ISFORMULA ISFORMULA 143 ISNONTEXT ISNONTEXT FALSE 129 ISBLANK ISBLANK TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 152 IBM SmartCloud Docs
157 145 ISNUMBER ISNUMBER TRUE N N TRUE 1 N N 0 N( ) =N(TRUE) 1 =N(FALSE) 0 =N(100) 100 =N("abc") 0 NA NA #N/A NA() =NA() #N/A 3 153
158 : 148 ISREF ISREF 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 136 ISFORMULA ISFORMULA 143 ISNONTEXT ISNONTEXT FALSE 129 ISBLANK ISBLANK TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 151 ISTEXT ISTEXT TRUE 145 ISNUMBER ISNUMBER TRUE TYPE TYPE TYPE( ) 154 IBM SmartCloud Docs
159 1 = 2 = 4 = 8 = 16 = =TYPE(C2) 2 =TYPE(D9)
160 : 129 ISBLANK ISBLANK TRUE 127 ERRORTYPE ERRORTYPE 135 ISEVEN ISEVEN TRUE FALSE 147 ISODD ISODD TRUE FALSE 131 ISERR ISERR #N/A TRUE 133 ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A #DIV/0 #Err 522 TRUE 138 ISLOGICAL ISLOGICAL TRUE TRUE FALSE 141 ISNA ISNA #N/A ( ) TRUE 143 ISNONTEXT ISNONTEXT FALSE 145 ISNUMBER ISNUMBER TRUE 151 ISTEXT ISTEXT TRUE 148 ISREF ISREF 156 IBM SmartCloud Docs
161 AND AND TRUE TRUE 1 FALSE FALSE AND (TRUE 1<5 2+3=7 B8<10 ) (A1:C3) : #VALUE! AND( ) TRUE FALSE TRUE AND TRUE 12<13 14>12 7<6 =AND(12<13,14>12,7<6) FALSE =AND(FALSE,TRUE) FALSE FALSE FALSE FALSE FALSE() FALSE FALSE() =FALSE() FALSE =NOT(FALSE()) TRUE IF IF IF(TRUE FALSE ) TRUE FALSE 3 157
162 TRUE ( ) TRUE FALSE ( ) FALSE IBM Docs =IF(A1>5,100,"") A () NOT NOT NOT( ) =NOT(A) A=TRUE A=FALSE OR OR 1 TRUE TRUE FALSE FALSE OR (TRUE 1<5 2+3=7 B8<10 ) (A1:C3) : #VALUE! OR( ) TRUE FALSE 158 IBM SmartCloud Docs
163 12<11 13>22 45=45 =OR(12<11,13>22,45=45) TRUE =OR(FALSE,TRUE) TRUE TRUE TRUE TRUE TRUE() TRUE TRUE() A=TRUE B=FALSE =AND(A,B) FALSE =OR(A,B) TRUE =NOT(AND(A,B)) TRUE ABS ABS ABS() +/- =ABS(-56) 56 =ABS(12) 12 =ABS(0) 0 ACOS ACOS ACOS () 3 159
164 () 0 PI =ACOS(-1) (PI ) =DEGREES(ACOS(0.5)) ASIN ASIN ASIN () () -PI/2 +PI/2 =ASIN(0) 0 =ASIN(1) (PI/2 ) =DEGREES(ASIN(0.5)) ATAN ATAN ATAN () () -PI/2 PI/2 160 IBM SmartCloud Docs =ATAN(1) (PI/4 ) =DEGREES(ATAN(1)) CEILING CEILING CEILING(,, )
165 Microsoft Excel Microsoft Excel 3 : IBM Docs Microsoft Excel Excel IBM Docs Excel =1 =CEILING(-11,-2) -10 =CEILING(-11,-2,0) -10 =CEILING(-11,-2,1) -12 COUNTBLANK COUNTBLANK COUNTBLANK() =COUNTBLANK(A1:B2) A1 A2 B1 B2 4 COUNTIF COUNTIF COUNTIF( )?( ) * () B* B B??? B 3? * ~( ) A1:A B B
166 =COUNTIF(A1:A10,2006) 1 =COUNTIF(A1:A10,B1) 1 =COUNTIF(A1:A10,">=2006") 4( ) =COUNTIF(A1:A10,"<"&B1) B =COUNTIF(A1:A10,C2) C2 >2006 A1:A10 >2006 =COUNTIF(A1:A10,"<0") EVEN EVEN EVEN() 0 =EVEN(2.3) 4 =EVEN(2) 2 =EVEN(0) 0 =EVEN(-0.5) -2 EXP EXP e e EXP () e =EXP(1) e FACT FACT 1*2*3*4*... * 162 IBM SmartCloud Docs
167 FACT() FACT number! (number ) =FACT(0) 1 =FACT(3) 6 =FACT(0) 1 FLOOR FLOOR FLOOR() Microsoft Excel Microsoft Excel 3 : IBM Docs Microsoft Excel Excel IBM Docs Excel =1 =FLOOR( -11;-2) -12 =FLOOR( -11;-2;0) -12 =FLOOR( -11;-2;1) -10 INT INT () 3 163
168 =INT(5.7) 5 =INT(-1.3) -2 LN LN e e LN () =LN(3) 3 ( ) =LN(EXP(321)) 321 LOG LOG LOG (, ) ( ) =LOG(10,3) 3 10 ( ) =LOG(7^4,7) 4 MOD MOD 1 MOD (,) * INT( /) 164 IBM SmartCloud Docs
169 =MOD(22,3) =MOD(11.25,2.5) 1.25 ODD ODD ODD() 0 =ODD(1.2) 3 =ODD(1) 1 =ODD(0) 1 =ODD(-3.1) -5 PI PI ( PI 14 ) PI() =PI() POWER POWER POWER( ) POWER (^) ^ 3 165
170 =POWER(4,3) =4^3 4 3 PRODUCT PRODUCT PRODUCT( ) PRODUCT number1 * number2 * number3 *... =PRODUCT(2,3,4) 24 RAND RAND 0 1 RAND() =RAND() 0 1 RANDBETWEEN RANDBETWEEN RANDBETWEEN( ) IBM Docs IBM Docs Shift+Ctrl+F9 =RANDBETWEEN(20,30) ROUND ROUND ROUNDDOWN ROUNDUP 166 IBM SmartCloud Docs
171 ROUND( ) =ROUND(2.348,2) 2.35 =ROUND( ,3) =ROUND(2.348,0) 2 =ROUND(2.5) 3 =ROUND(987.65,-2) 1000 ROUNDDOWN ROUNDDOWN ROUNDUP ROUND ROUNDDOWN ( ) count =ROUNDDOWN(1.234,2) 1.23 =ROUNDDOWN(45.67,0) 45 =ROUNDDOWN(-45.67) -45 =ROUNDDOWN(987.65,-2) 900 ROUNDUP ROUNDUP ROUNDDOWN ROUND ROUNDUP ( ) count 3 167
172 =ROUNDUP(1.1111,2) 1.12 =ROUNDUP(1.2345,1) 1.3 =ROUNDUP(45.67,0) 46 =ROUNDUP(-45.67) 46 =ROUNDUP(987.65,-2) 1000 SQRT SQRT SQRT () =SQRT(16) 4 =SQRT(-16) SUBTOTAL SUBTOTAL SUBTOTAL (, ) AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 168 IBM SmartCloud Docs
173 31. () 11 VARP SUM SUM SUM(number1, number2,...number30) =SUM(A1,A3,B5) 3 =SUM (A1:E10) A1 E10 SUN() : A B A1:A40 B1:B40 C C =SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40) Enter Shift+Ctrl+Enter () {=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)} 1 0 SUMIF SUMIF 3 169
174 SUMIF(,, )?( ) * () B* B B??? B 3? * ~( ) : =SUMIF(A1:A10,"<0") =SUMIF(A1:A10,">0",B1:10) A1:A10 >0 B1:B10 SUMIF() COUNTIF() TRUNC TRUNC TRUNC( ) TRUNC(Number; 0) INT(Number) =TRUNC(1.239,2) =TRUNC( ,3) ADDRESS ADDRESS () 170 IBM SmartCloud Docs
175 ( $A$1) (A1) (A$1 $A1) ADDRESS INDIRECT A1 R1C1 ADDRESS 4 5 INDIRECT 2 0 R1C1 0 A1 R1C1 ADDRESS (!) INDIRECT A1 (.) ADDRESS (,,, A1, ) () 1 ($A$1) 2 (A$1) 3 ($A1) 4 (A1) A1 0 R1C1 0 A1 ADDRESS(1, 1, 2, "Sheet2") Sheet2!A$1 2 A1-6 B2 =ABS(INDIRECT(B2)) =ABS(INDIRECT(B2)) B2 ( 6) : COLUMN COLUMN 177 ROW ROW COLUMN COLUMN 3 171
176 1 COLUMN COLUMN() reference 1 =COLUMN(A1) 1 A 1 =COLUMN(C3:E3) 3 C 3 =COLUMN(D3:G10) 4 COLUMN {=COLUMN(B2:B7)} =COLUMN(B2:B7) 2 2 (B) 1 1 =COLUMN() C 3 (C1:D3) Rabbit {=COLUMN(Rabbit)} 1 (3, 4) : 170 ADDRESS ADDRESS () ( $A$1) (A1) (A$1 $A1) 177 ROW ROW COLUMNS COLUMNS 178 ROWS ROWS COLUMNS COLUMNS 172 IBM SmartCloud Docs
177 COLUMNS() 1 =COLUMNS(B5) =COLUMNS(A1:C5) 3 3 : 171 COLUMN COLUMN 177 ROW ROW 178 ROWS ROWS HLOOKUP HLOOKUP HLOOKUP(search_criteria, array, index, sorted) search_criteria?( ) * () B* B B??? B 3? * ~( ) array 1 FALSE #N/A 3 173
178 A1 B1 A4:AZ5 : AZ 52 A4 52 A5 52 B1 =HLOOKUP(A1, A4:AZ5, 2) A1 B1 A4:AZ5 2 1 FALSE : 175 INDEX INDEX 179 VLOOKUP VLOOKUP HYPERLINK HYPERLINK celltext URL celltext URL : F2 Shift+F10 HYPERLINK(url,celltext) url celltext ( ) celltext URL =HYPERLINK(" IBM SmartCloud Docs
179 =HYPERLINK(" ") =HYPERLINK(" =HYPERLINK($B4) B4 URL =HYPERLINK(" & "example.org" example.org =HYPERLINK("#Sheet1!A1","") Sheet1!A1 =HYPERLINK("file:///C:/writer.odt#Specification"," ") Specification INDEX INDEX INDEX( ) ( ) ( ) ( ) =INDEX(A1:B6,1,1) A1:B
180 : 179 VLOOKUP VLOOKUP 173 HLOOKUP HLOOKUP INDIRECT INDIRECT ( A1) (A1) INDIRECT(ref,ref_style) ref ref_style ( ) ref A1 ( ) R1C1 ( ) ref_style True ref A1 =INDIRECT(A1) A1 C108 C =SUM(INDIRECT("a1:" & ADDRESS(1,3))) A1 1 3 A1:C1 : OFFSET OFFSET OFFSET OFFSET OFFSET(reference,rows,cols,height, width) reference rows 176 IBM SmartCloud Docs
181 cols height ( ) width ( ) =OFFSET(A1,2,2) A1 2 2 C3 C =SUM(OFFSET(A1,2,2,5,6)) C3 5 6 (area=c3:h7) : 176 INDIRECT INDIRECT ( A1) (A1) ROW ROW ROW ROW ROW() =ROW(B3) 3 B3 3 {=ROW(D5:D8)} (5,6,7,8) 5 8 =ROW(D5:D8) 5 {=ROW(A1:E1)} =ROW(A1:E1) 1 =ROW()
182 : 170 ADDRESS ADDRESS () ( $A$1) (A1) (A$1 $A1) 171 COLUMN COLUMN 172 COLUMNS COLUMNS ROWS ROWS ROWS ROWS ROWS(array) 1 =Rows(B5) =ROWS(A10:B12) 3 (C1:D3) Rabbit =ROWS(Rabbit) 2 : 172 COLUMNS COLUMNS 171 COLUMN COLUMN 177 ROW ROW SHEET SHEET SHEET() ( ) 178 IBM SmartCloud Docs
183 2 2 =SHEET( 2!A1) 2 VLOOKUP VLOOKUP VLOOKUP VLOOKUP(, array,, )?( ) * () B* B B??? B 3? * ~( ) array 1 FALSE #N/A A1 B1 D1:E100 D1 100 E1 100 D B1 =VLOOKUP(A1, D1:E100, 2) A1 B1 D1:E FALSE 3 179
184 : 175 INDEX INDEX 173 HLOOKUP HLOOKUP AVERAGE AVERAGE AVERAGE( ) =AVERAGE(A1:A50) AVERAGEA AVERAGEA 0 AVERAGEA (number 1, number 2,... number 30) number 1, number 2,...number 30 0 =AVERAGEA(A1:A50) COUNT COUNT COUNT( ) IBM SmartCloud Docs
185 =COUNT(2,4,6,"eight") =3 3 COUNTA COUNTA 0 COUNTA( ) =COUNTA(2,4,6,"eight") =4 4 LARGE LARGE n LARGE(array,nth_position) array nth_position =LARGE(A1:C50,2) A1:C50 2 MAX MAX MAX 0 MAX() MAXA() ( ) 0 MAX() (MAX("string") ) MAX( )
186 =MAX(A1,A2,A3,50,100,200) =MAX(A1:B100) MEDIAN MEDIAN MEDIAN(number 1,number 2,...number 255.) MEDIAN () MEDIAN MEDIAN 2 =MEDIAN(5,12,65,82,9) 12 =MEDIAN(5,12,65,82,9,78) MIN MIN MIN 0 MIN() MINA() ( ) 0 MIN() (MIN("string") ) MIN( ) =MIN(A1:B100) MODE MODE ( ) MODE (number 1,number 2,...number 30) number 1, number 2,...number IBM SmartCloud Docs
187 A1:A MODE A =MODE(A1:A11) 2 16 RANK RANK RANK (number, ref, order) number ref order ( ) order = 0 order = 1 =RANK(A10,A1:A50) A1:A50 A10 SMALL SMALL n SMALL(array,nth_position) array 3 183
188 nth_position =SMALL(A1:C50,2) A1:C50 2 STDEV STDEV STDEV( ) number1,number1,...number30 =STDEV(A1:A50) STDEVP STDEVP STDEVP(number1,number2,...number30) number1,number1,...number30 =STDEVP(A1:A50) A1:A50 BASE BASE 0 9 A Z BASE (,, ) ( ) IBM SmartCloud Docs
189 BASE(17,10,4) BASE(17,2) BASE(255,16,4) 16 00FF CONCATENATE CONCATENATE 1 CONCATENATE( ) CONCATENATE(" ","","") EXACT EXACT 2 TRUE EXACT( 1 2) =EXACT("IBM lab5" "IBM Lab5") FALSE : 186 LEN LEN 190 SEARCH SEARCH LEFT LEFT (1 ) LEFT (, ) 3 185
190 () LEFT("output",3) out : 187 MID 189 RIGHT RIGHT () 190 SEARCH SEARCH LEN LEN LEN ( ) =LEN(" ") 14 LEN( ) 8 : 185 EXACT EXACT 2 TRUE 190 SEARCH SEARCH LOWER LOWER LOWER( ) 186 IBM SmartCloud Docs
191 =LOWER("EXAMPLE") example : 188 PROPER PROPER 193 UPPER UPPER MID : MID( Text T,Integer Start,Integer Length) : : Text: Start: Length: Start Length T Start=INT(Start) Length=INT(Length) Start Length Start Start > LEN(T) ("") Start < 0 Error Start >=0 Length=0 : MID(T,1,Length) LEFT(T,Length) =MID("output",4,3) put 3 187
192 : 185 LEFT LEFT (1 ) 189 RIGHT RIGHT () 190 SEARCH SEARCH REPLACE REPLACE 191 SUBSTITUTE SUBSTITUTE 192 TRIM TRIM PROPER PROPER PROPER ( ) PROPER("ibm software lab") Ibm Software Lab : 186 LOWER LOWER 193 UPPER UPPER REPLACE REPLACE 188 IBM SmartCloud Docs
193 REPLACE() =REPLACE(" ",1,1,"444") " " : 187 MID 190 SEARCH SEARCH 191 SUBSTITUTE SUBSTITUTE 192 TRIM TRIM REPT REPT 255 REPT () REPT("", 2) RIGHT RIGHT () RIGHT () ( ) 3 189
194 RIGHT("Hui",2) ui : 185 LEFT LEFT (1 ) 187 MID SEARCH SEARCH RIGHTB 2 RIGHTB RIGHTB (, ) number ( ) () RIGHTB 2 RIGHTB 190 IBM SmartCloud Docs RIGHTB("Single byte",4) byte SEARCH SEARCH SEARCH(,, ) (?) (*) B* B B??? B 3? * (~)
195 ( ) =SEARCH(54, ) 10 : 185 EXACT EXACT 2 TRUE 186 LEN LEN 187 MID 185 LEFT LEFT (1 ) 189 RIGHT RIGHT () 188 REPLACE REPLACE SUBSTITUTE SUBSTITUTE 192 TRIM TRIM SUBSTITUTE SUBSTITUTE SUBSTITUTE (text,old,new,which) text old ( ) new which SUBSTITUTE(" ","3","abc") 12abc12abc12abc SUBSTITUTE(" ","3","abc",2) 12312abc
196 : 188 REPLACE REPLACE 187 MID 190 SEARCH SEARCH TRIM TRIM TEXT TEXT TEXT (, ) TRIM TRIM TRIM ( ) ( ) TRIM(" hello") "hello" 192 IBM SmartCloud Docs
197 : 188 REPLACE REPLACE 187 MID 190 SEARCH SEARCH 191 SUBSTITUTE SUBSTITUTE UPPER UPPER UPPER( ) =UPPER("Good Morning") GOOD MORNING : 186 LOWER LOWER 188 PROPER PROPER > 3 193
198 33. () URL ( > > > > 34. > > > (') (=) : SUM AVERAGE > 194 IBM SmartCloud Docs
199 34. () Enter > > > Enter > > 35. > > 36. > > > 3 195
200 : ( ) IBM Docs 72 IBM Docs : 85 Windows Mac Ctrl Command Microsoft Windows Macintosh IBM SmartCloud for Social Business wiki 37. Enter Enter Enter Shift+Enter 196 IBM SmartCloud Docs
201 37. () F2 Enter Ctrl+A.pdf ( ) Ctrl+B Ctrl+I Ctrl+U Ctrl+C Ctrl+V Ctrl+X Ctrl+P Ctrl+Y Ctrl+Z Ctrl+F Alt+Enter Ctrl+Enter Esc Delete Backspace Ctrl+S Shift+Tab Ctrl+ ( ) Shift+ ( ) Home 3 197
202 37. () End Ctrl+Home Ctrl+End Shift+ Ctrl+Shift+ Alt Alt Alt Esc Alt+Shift+F Alt+F10 Shift+F2 Shift+F2 ( ) Esc Ctrl+Page Up Ctrl+Page Down Ctrl+Tab 198 IBM SmartCloud Docs
203 4 IBM SmartCloud Docs IBM SmartCloud Docs IBM SmartCloud Docs v v 206 v 209 v 213 v 219 IBM SmartCloud for Social Business wiki IBM Docs 199
204 : 235 IBM Docs IBM Docs.ppt.pdf : 203 IBM Docs.odp.ppt.pdf IBM Docs v v IBM Docs 1. > > 2. OK 200 IBM SmartCloud Docs
205 : IBM Docs 205 IBM Docs.ppt.pdf : 203 IBM Docs.odp.ppt.pdf : x 3. : 4 201
206 4. ( ) YourOrganizationName v v 3. v v : IBM SmartCloud Docs
207 : IBM Docs 200 IBM Docs 205 IBM Docs.ppt.pdf : IBM Docs.odp.ppt.pdf IBM Docs IBM Docs.odp.ppt.pdf 4 203
208 38. IBM Docs Lotus Symphony Presentations.odp.otp Microsoft PowerPoint.ppt.pptx.pot 39. IBM Docs Lotus Symphony Presentations.odp Microsoft PowerPoint.ppt Adobe Reader.pdf : IBM Docs Symphony OpenDocument : IBM Docs 200 IBM Docs IBM Docs.ppt.pdf : 203 IBM Docs.odp.ppt.pdf () 204 IBM SmartCloud Docs
209 : 1. > : IBM Docs 2. > OK 1. > 2. : 3. IBM Docs.ppt.pdf IBM Docs OpenDocument (.odf).odt IBM Docs Microsoft Office PowerPoint.odp (Microsoft Office PDF )
210 3. Microsoft Office PDF : 4. : PDF OK : IBM Docs 200 IBM Docs 201 : 203 IBM Docs.odp.ppt.pdf ( ) 206 IBM SmartCloud Docs
211 a. b. c. v v : d. 5. : YourOrganizationName
212 : 210 IBM Docs 213 : IBM SmartCloud Docs
213 4. v x v v IBM Docs IBM Docs 4 209
214 IBM Docs 210 IBM SmartCloud Docs USB Lotus Symphony Microsoft Office Lotus Symphony Windows Linux Mac OS IBM Docs IBM Docs
215 IBM Docs Linda IT Linda 5 IT Linda IBM Docs Linda Linda 5 Linda 5 Linda :
216 2. : IBM Docs IBM Docs IBM Docs? IBM Docs IBM Docs : 5. > 6. : OK : 210 IBM Docs : 206 > 212 IBM SmartCloud Docs
217 : : 210 IBM Docs :
218 @ Tina Tina Tina Tina Tina 214 IBM SmartCloud Docs
219 : Enter 4 215
220 4. 5. : 1 6. Enter : 213 : IBM SmartCloud Docs
221 :
222 : 213 : > Enter IBM SmartCloud Docs
223 : 213 : IBM Docs 4 219
224 : : ( ) ( ) 226 IBM Docs 227 IBM Docs IBM SmartCloud Docs :
225 : v 1 v Ctrl 3. v v 4 221
226 : 225 : 219 IBM Docs 223 ( ) ( ) 226 IBM Docs 227 IBM Docs IBM Docs Presentations > 3. > 222 IBM SmartCloud Docs
227 : 225 : 219 IBM Docs 221 ( ) ( ) 226 IBM Docs 227 IBM Docs ( ) ( )
228 224 IBM SmartCloud Docs 3.
229 : 222 : 219 IBM Docs IBM Docs 227 IBM Docs 4 225
230 : 222 : 219 IBM Docs ( ) ( ) IBM Docs 227 IBM Docs IBM Docs v v v IBM SmartCloud Docs
231 : : 219 IBM Docs ( ) ( ) IBM Docs IBM Docs 4 227
232 1. 2. > IBM SmartCloud Docs
233 : : 219 IBM Docs ( ) ( ) 226 IBM Docs 4 229
234 : IBM Docs Presentations : IBM Docs Presentations IBM SmartCloud Docs
235 :
236 : 230 IBM Docs Presentations : v v 232 IBM SmartCloud Docs
237 : 230 IBM Docs Presentations : v v 1 v 4 233
238 : 230 IBM Docs Presentations : > 234 IBM SmartCloud Docs
239 : 230 IBM Docs Presentations : IBM Docs 1. () > 2. > 3. 1 : 4. > 4 235
240 1. > OK : 199 IBM Docs 200 IBM Docs IBM Docs.ppt.pdf : 203 IBM Docs.odp.ppt.pdf PDF PDF 1. > PDF IBM SmartCloud Docs
241 PDF PDF PDF 3. OK OK Adobe Reader Adobe Reader 6. Adobe Reader > 7. OK 4 237
242 : 220 : v v 4. OK 238 IBM SmartCloud Docs
243 : 220 : : 240 :
244 1. v v 2. : : IBM SmartCloud Docs
245 : :
246 : : > OK 242 IBM SmartCloud Docs
247 : v > > v : > > > : > 4 243
248 : v > v : > : 244 IBM SmartCloud Docs
249 : : > > > 4 245
250 : IBM SmartCloud Docs
251 v v v > > > v > :
252 40. > > > > / / 41. > > > > > 248 IBM SmartCloud Docs
253 41. () > > > > 42. > > > 43. Enter 4 249
254 43. () > > > Windows Mac OS Ctrl Command IBM SmartCloud for Social Business wiki Ctrl+A Ctrl+B Ctrl+I Ctrl+U Ctrl+C Ctrl+V Ctrl+X Ctrl+M Ctrl+Y Ctrl+Z Esc Enter Delete 250 IBM SmartCloud Docs
255 Home End Page Up Page Down Ctrl+Tab ( ) Alt+Shift+F : Alt+F10 Shift+F2 Shift+ Shift+Home End Shift+Tab Shift+F10 Esc 4 251
256 252 IBM SmartCloud Docs
257 ,,,, (') background , 213, , 76, , 127, 129, 131, 133, 135, 137, 138, 141, 143, 145, 147, 149, 151, 153, , 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, , 171, 172, 173, 174, 175, 176, 177, 178, , 185, 186, 187, 188, 189, 190, 191, 192, , 181, 182, 183, , 103, , 108, 109, 110, 114, 115, 117, 118, , 112, 114, , 158, YEAR , , , 70 12, 67, , 80, tables , , 65,
258 () , 70 83, viewing , IBM SmartCloud Docs , indenting , finding Microsoft Excel 62 Microsoft Word , , 48, , , 220 effects , ,
259 viewing viewing , , A ABS 159 ACOS 159 ADDRESS 171 AND 157 ASIN 160 ATAN 160 autofill 91 AVERAGE 180 AVERAGEA 180 B BASE 184 C CEILING 160 COLUMN 172 COLUMNS 173 CONCATENATE 185 CONVERT 123 COUNT 180 COUNTA 181 COUNTBLANK 161 COUNTIF 161 CSV ( ) 63 D DATE 105 DATEDIF 106 DAYS 108 E Enter 193 ERRORTYPE 127 EVEN 162 EXACT 185 Excel 63 EXP 162 F FACT 163 FALSE 157 FLOOR 163 FORMULA 129 FREQUENCY 102 H HLOOKUP 173 HOUR 109 HYPERLINK 174 hyperlinks I INDEX 175 INDIRECT 176 INT 163 ISBLANK 129 ISERR 131 ISERROR 133 ISEVEN 135 ISFORMULA 137 ISLOGICAL 138 ISNA 141 ISNONTEXT 143 ISNUMBER 145 ISODD 147 ISREF 149 ISTEXT 151 L LARGE 181 LEFT 185 LEN 186 LN 164 LOG 164 LOWER
260 M MAX 181 MEDIAN 182 Microsoft Word 9 MID 187 MIN 182 MINUTE 110 MMULT 103 MOD 164 MODE 182 MONTH 112 N N 153 NA 153 NETWORKDAYS 114 NOT 158 NOW 114 O ODD 165 ODS (Lotus Symphony Spreadsheets) 63 OFFSET 176 OpenOffice 7 OR 158 P PDF (Portable Document Format) 63 PDF 63 PI 165 POWER 165 PRODUCT 166 PROPER 188 R RAND 166 RANDBETWEEN 166 RANK 183 REPT 189 RIGHT 189 RIGHTB 190 ROUND 167 ROUNDDOWN 167 ROUNDUP 167 ROW 177 ROWS 178 S SEARCH 190 SECOND 115 SHEET 178 SMALL 183 SQRT 168 STDEV 184 STDEVP 184 styles 34 SUBSTITUTE 191 SUBTOTAL 168 SUM 169 SUMIF 170 SUMPRODUCT 104 T tables 43 tables () TEXT 192 TIME 117 TODAY 118 TRIM 192 TRUE 159 TRUNC 170 TYPE 154 U UPPER 193 URL 90 V VLOOKUP 179 W Web 35 WEEKDAY 119 WEEKNUM 121 X XSL (Excel) 63 XSLX (Excel) 63 '( ) IBM SmartCloud Docs
IBMDocs_Help.ps
Docs 1.0.5 ii Docs ....... 3 IBM SmartCloud Docs............... 5............... 7 A.................. 7 B.................. 8 C.................. 8 D.................. 10 E.................. 10 F..................
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
関 数
/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
橡統計担当者のためのエクセル表紙.PDF
Num Lock(Pad Lock) ( Num Lock) [ ][ ] [ ][ ] Alt Alt 4 + ( ) 3+3 - ( ) 3-1 -1 * ( ) 3*3 / ( ) 3/3 % ( ) 20% ^ ( ) 3^2 (3*3 ) 2 TRUE FALSE = ( ) A1=B1 > ( ) A1>B1 < ( ) A1= ( ) A1>=B1
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
資料 4 試験業務課 2015/10/23 CS 技能評価試験に係るアンケート調査結果 (OS とアプリケーションソフトウエアについて ) 結果報告 調査時期 : 平成 27 年 7 月下旬 ~8 月下旬 調査内容 1 認定施設のシステム環境 (OS と Office) 2 Office2013 へ
資料 4 試験業務課 05/0/ CS 技能評価試験に係るアンケート調査結果 (OS とアプリケーションソフトウエアについて ) 結果報告 調査時期 : 平成 7 年 7 月下旬 ~8 月下旬 調査内容 認定施設のシステム環境 (OS と Office) Office0 への移行予定 (Office007 と 00 利用施設対象 ) 表計算 関数 の実態と要望 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
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
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 " " " " 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
index.dvi
1 1 7 1.1 EXTRA for Windows Version 4............... 7 1.1.1 OS................................. 7 1.1.2 MSAA............................... 8 1.1.3........................... 8 1.2 EXTRA for Windows Version
(Nov/2009) 2 / = (,,, ) 1 4 3 3 2/8
(Nov/2009) 1 sun open-office calc 2 1 2 3 3 1 3 1 2 3 1 2 3 1/8 (Nov/2009) 2 / = (,,, ) 1 4 3 3 2/8 (Nov/2009) 1 (true) false 1 2 2 A1:A10 A 1 2 150 3 200 4 250 5 320 6 330 7 360 8 380 9 420 10 480 (1)
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.
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)
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
http://www1.iwate-ed.jp/ WindowsXP - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Microsoft Word - mbv25990325.doc
MEDIASITE MEDIASITEMEDIASITE MB MEDIASITE MEDIASITEMB MEDIASITE Page 1 MBWindows 95/98 Windows WindowsWindows Microsoft, Windows, MS-DOSMicrosoft Corporation Cyber-SIGN 1998 Handwriting Recognition Kernel:
Numbers '08 ユーザーズガイド
Numbers 08 KAppleInc. 2008AppleInc.Allrightsreserved. Apple Apple AppleInc. Apple Apple Apple 1InfiniteLoop Cupertino,CA95014-2084 U.S.A. www.apple.com 163-1480 3 20 2 www.apple.com/jp AppleApple AppleWorksColorSynciMovie
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
桁区切りスタイルの表示形式 2O2 参照 0 円 #,##0" 円 " 関数の基本 項 目 ど ん な 場 合 使 用 関 数 スペース 不要なスペースを削除する TRIM( トリム ) 関数 2A2 参照 文字 ( 英字 数字 カナ文字 ) 半角文字から全角文字に変換する JIS( ジス ) 関数
< 関数関連 > 月日 曜日 の入力方法 < 見本 > < 入力方法 > 9/1 金 9/1 6 金金 9/2 土 9/1 と入力 9/2 7 土土 9/3 日 9/3 1 日日 9/4 月 関数 =weekday(f4,1) と 9/4 2 月 月 9/5 火 入力 9/5 3 火 火 9/6 水 9/6 4 水水 9/7 木 9/7 5 木木 9/8 金 9/9 土 9/10 日 関数 =text(f4,"aa")
橡J_ptvr_common.PDF
PARTNER VR/MIPS Copyright (C) 1999 / ( ) PARTNER http://www.midas.co.jp/products/download/program/partner.htm PARTNER( ) PARTNER 1 MS-Windows Windows MS MS-DOS CPU Y / M / D Rev 1998.07.15 1.00 1999.05.14
countif Excel E4:E10E4:E10 OK 2/25
1....................... 1 2............................... 2 2.1 -countif(2 ) 2.2 (7 ) 2.3 frequency(7 ) 3 []............ 8 4................................. 8 4.1 (8 ) 4.2 (11 ) 4.3 (12 ) 4.4 (13 )
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..
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
ワードプロセッシングについて
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)
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](/thumbs/42/22799507.jpg "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. []
<4D6963726F736F667420576F7264202D204850835483938376838B8379815B83578B6594BB2D834A836F815B82D082C88C60202E646F63>
例 題 で 学 ぶ Excel 統 計 入 門 第 2 版 サンプルページ この 本 の 定 価 判 型 などは, 以 下 の URL からご 覧 いただけます. http://www.morikita.co.jp/books/mid/084302 このサンプルページの 内 容 は, 第 2 版 発 行 当 時 のものです. i 2 9 2 Web 2 Excel Excel Excel 11 Excel
橡マニュアル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
リファレンス
ii iii iv v vi NEC Corporation 1998 vii C O N T E N T S PART 1 PART 2 viii ix C O N T E N T S PART 3 PART 4 x xi C O N T E N T S PART 5 xii xiii xiv P A R T 1 2 1 3 4 5 1 6 7 1 8 1 9 10 11 1 12 13 1 14
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
インターネット入門
PART 7 PART 8 ii PART 1 PART 2 PART 3 PART 4 PART 7 PART 4 PART 5 PART 6 iii iv v vi NEC Corporation 1998 vii C O N T E N T S PART 1 PART 2 viii PART 3 ix C O N T E N T S PART 4 PART 5 x PART 6 xi C O
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
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
title_PoD1
ADOBE PRELUDETM ヘルプとチュートリアル 一部のリンク先のコンテンツは英語のみで提供されます 2013 年 2 月 --> Adobe Prelude 2012 5 7 Prelude 2012 5 4 Prelude Prelude Adobe Prelude Raw Adobe Prelude Adobe Creative Suite Production Premium Master
職業訓練実践マニュアル 重度視覚障害者編Ⅰ
資料 3 訓練カリキュラムの詳細 支援機器 ソフトを利用した基本的なパソコン操作の習得 1-1 Windows の基本的な操作実施時期訓練前期 ( 習得済みの者については確認程度で終了 ) 実施内容 Windows アプリケーションの起動 終了操作の理解ダイアログボックスの理解タスクの切り替えファイル フォルダの理解拡張子の理解ショートカットの作成訓練の流れテキスト ( 電子ファイル ) に沿って
改訂履歴
EXCEL 関数の利用 2015.01.16 改訂履歴 目次 使用可能な EXCEL 関数 論理関数統計関数数学 三角関数検索 行列関数文字列操作関数 入れ子の計算式 年月日 / 時刻の計算 年月日 / 時刻の計算結果表示 計算結果データ型 旧形式と新形式の計算式クラスター 旧形式から新形式への計算式クラスターの変更 EXCEL 計算式におけるConMas i-reporterの仕様制限 EXCEL
handout-tokushima2016-Excel.indd
JaGra 徳島 DTP 表計算 Excel NumbersGoogle DTP DTP Excel 1 2 2 3 3 3 4 4 5 4 6 5 7 5 8 6 9 6 10 9 11 10 12 DTP Illustrator 10 13 DTP InDesign 13 Mac Windows Mac a o s c r Windows c l s q Mac OS 表記 command option
検 索 の 型 が FALSE 又 は 0 の 場 合 は 左 端 を 昇 順 に 並 べ 替 えておく 必 要 はありません が 該 当 する 値 がない 場 合 は エラーになります 旅 行 命 令 書 など 名 前 から 職 名 や 住 所 を VLOOKUP 関 数 で 取 得 する 場 合
VLOOKUP 関 数 VLOOKUP 関 数 は 最 もポピュラーで 使 用 頻 度 の 高 い 検 索 / 行 列 関 数 です 構 文 は 次 のとおりです =VLOOKUP( 検 索 値, 範 囲, 列 番 号,[ 検 索 の 型 ]) 範 囲 の 左 端 の 列 が 検 索 値 と 合 致 する 行 の 列 番 号 のセルの 値 を 返 します =VLOOKUP(C1,F1:I12,3)
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
Adobe Acrobat Reader のヘルプ
1 Adobe Acrobat Reader 5.1 PDF PDF Microsoft Windows Mac OS Acrobat Reader A B C Adobe Acrobat Reader A. B. C. Acrobat Reader Acrobat Reader 1 2 Acrobat Reader Acrobat Reader Windows Macintosh Acrobat
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
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
DVIOUT-index_exc
えくせるであそぶ 初版関数索引 ( 初出 関数解説ページを掲載 ) ABS...204, 205 [Ch.22] AND...60 [Ch.7] AVERAGE...16 [Ch.2] CEILING...76 [Ch.9] CHAR...218, 229 [Ch.24] CHOOSE...41, 45 [Ch.5] CODE...218, 228 [Ch.24] COMBIN...21 [Ch.3]
スライド 1
秋学期情報スキル活用 田中基彦教授, 樫村京一郎講師 ( 工学部共通教育科 ) Excelの様々な関数教科書第 13 章 1. 関数の基本と種類 2. 日時, 時刻, 和,4 捨 5 入などに関する関数 3. 条件による分岐 : IF 関数の利用,VLOOKUP 関数 4. その他の関数時系列の表示 ( ローソク図 ) 行と列の入れ替え 関数 : 表の集計計算に必須 関数 : あらかじめ定義された
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]
FileMaker Pro Tutorial
FileMaker Pro 12 2007-2012 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. Bento FileMaker, Inc. FileMaker FileMaker,
情報科学概論 第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
FileMaker Pro Tutorial
FileMaker Pro 11 2007-2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. FileMaker, Inc. FileMaker FileMaker, Inc.
Alien Skin Software, LLC
Blow Up Blow Up Alien Skin Software Alien Skin Software Alien Skin Software, LLC. Alien Skin Software, LLC ... 4... 4... 4 BLOW UP... 5... 6... 6 DPI... 7... 7... 8 A:...8 B:...8 C: ( 1 )...8 D:...9 E:...9
リファレンス
ii iii iv v vi NEC Corporation 1998 vii C O N T E N T S PART 1 viii ix C O N T E N T S x PART 2 xi C O N T E N T S PART 3 PART 4 xii PART 5 xiii C O N T E N T S xiv PART 6 xv xvi 2 3 4 5 6 7 P A R T
151021slide.dvi
: Mac I 1 ( 5 Windows (Mac Excel : Excel 2007 9 10 1 4 http://asakura.co.jp/ books/isbn/978-4-254-12172-8/ (1 1 9 1/29 (,,... (,,,... (,,, (3 3/29 (, (F7, Ctrl + i, (Shift +, Shift + Ctrl (, a i (, Enter,
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
(
2 Web http://mybook-pub-site.sakura.ne.jp/statistics Multivariate/index.html 1 2 1 2.1................................. 1 2.2 (............... 8 2.2.1................... 9 2.2.2.................. 12 2.2.3..............
Microsoft Word - ショートカット集.doc
Word Shortcut [Ctrl]+B [Ctrl]+I [Ctrl]+U [Ctrl]+L [Ctrl]+E [Ctrl]+R [Ctrl]+ [Ctrl]+ [Ctrl]+[Enter] [Ctrl]+[Shift]+Z 選 択 した 文 字 を 太 字 にする 選 択 した 文 字 を 斜 体 にする 選 択 した 文 字 に 下 線 がつく 選 択 した 文 字 を 左 揃 え 選 択
15 2004.03 194
The Statistical Processing using EXCEL MIYOSHI Yoshihiko In this paper, I summarize the method of performing statistical processing using only the basic function of EXCEL without the VBA macro, add-in
stat-excel-12.tex (2009 12 8 ) 2 -countif Excel 22 http://software.ssri.co.jp/statweb2/ 1. 111 3 2. 4 4 3 3. E4:E10 E4:E10 OK 4. E4:E10 E4:E10 5 6 2/1
stat-excel-12.tex (2009 12 8 ) 1 (Microsoft) (excel) (Sun Microsystems) = (open-office calc) 1 2 3 3 1 3 1 2 3 1 2 3 1/12 stat-excel-12.tex (2009 12 8 ) 2 -countif Excel 22 http://software.ssri.co.jp/statweb2/
2.2 Sage I 11 factor Sage Sage exit quit 1 sage : exit 2 Exiting Sage ( CPU time 0m0.06s, Wall time 2m8.71 s). 2.2 Sage Python Sage 1. Sage.sage 2. sa
I 2017 11 1 SageMath SageMath( Sage ) Sage Python Sage Python Sage Maxima Maxima Sage Sage Sage Linux, Mac, Windows *1 2 Sage Sage 4 1. ( sage CUI) 2. Sage ( sage.sage ) 3. Sage ( notebook() ) 4. Sage
改訂履歴
V4.3 ConMas i-reporter i-reporter EXCEL 関数機能概要説明書 Rev.1.0.0 2015.01.16 改訂履歴 目次 EXCEL 関数機能の強化について 使用可能なEXCEL 関数 論理関数統計関数数学 三角関数検索 行列関数文字列操作関数 入れ子の計算式 年月日 / 時刻の計算 年月日 / 時刻の計算結果表示 計算結果データ型 旧形式と新形式の計算式クラスター
１
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
untitled
1. Ver1.7(Macintosh )... 1 1-1... 1 1-2 Ver1.7... 1 1-3 Ver1.7... 1 1-4... 1 1-4-1... 1 1-4-2... 1 1-4-3... 1 1-5... 1 2... 3 3... 3 3-1... 3 3-2... 3 3-3... 3 3-4 Ver1.6... 3 4 /... 4 4-1... 4 4-2...
TraTool.book
TraTool TraTool TraTool TraTool TraTool TraTool 3 TraTool PDF WEB e-learning TraTool Web e-learning TraTool TraTool URL http://www.tratool.net TraTool Getting Started 1 TraTool TraTool TraTool PDF 2 TraTool
1,.,,,., RDBM, SQL. OSS,, SQL,,.
1,.,,,., RDBM, SQL. OSS,, SQL,,. 3 10 10 OSS RDBMS SQL 11 10.1 OSS RDBMS............................ 11 10.1.1 PostgreSQL................................. 11 10.1.2 MySQL...................................
目 次 1. 関 数 の 入 力... 3 1.1 関 数 とは... 3 1.2 関 数 の 挿 入... 4 1.3 関 数 の 入 力 方 法... 6 2 関 数 の 構 造... 8 2.1 引 数 の 種 類... 8 2.2 エラー 値... 9 2.3 算 術 演 算 子... 9
表 計 算 ソフトの 応 用 操 作 Microsoft Excel 2010 明 治 大 学 教 育 の 情 報 化 推 進 本 部 IZM20140417 目 次 1. 関 数 の 入 力... 3 1.1 関 数 とは... 3 1.2 関 数 の 挿 入... 4 1.3 関 数 の 入 力 方 法... 6 2 関 数 の 構 造... 8 2.1 引 数 の 種 類... 8 2.2 エラー
1 2 3 2 2.1 -countif Excel 22 http://software.ssri.co.jp/statweb2/ 1. 111 3 2. 4 4 3 3.E4:E10E4:E10 OK 2/27
1....................... 1 2............................... 2 2.1 -countif(2 ) 2.2 (7 ) 2.3 frequency(7 ) 3....................... 8 4 [].................... 10 5................................ 10 5.1
関数の構造
Microsoft Excel ~ 関 数 編 ~ 2008 年 5 月 更 新 明 治 大 学 目 次 1. 関 数 の 入 力 2 1.1. 関 数 とは 2 1.2. 関 数 の 基 本 構 造 2 1.3. 関 数 の 入 力 方 法 3 2. よく 使 う 関 数 4 2.1. SUM 関 数 4 2.2. AVERAGE 関 数 5 2.3. RANK 関 数 5 2.4. IF 関 数
statstcs statstcum (EBM) 2 () : ( )GDP () : () : POS STEP 1: STEP 2: STEP 3: STEP 4: 3 2
(descrptve statstcs) 2010 9 3 1 1 2 2 3 2 3.1............................................. 3 3.2............................................. 3 4 4 4.1........................................ 5 5 6 6 -pvot
Excel 2002,2003基本
Excel 2002,2003 基 本 数 式 演 算 子 関 数 数 式 の 基 本 先 頭 に =( 等 号 イコール) を 入 れる 数 式 には 関 数 セル 参 照 演 算 子 定 数 のいずれか またはすべてが 含 まれる 数 式 で 使 用 するときは 文 字 列 以 外 は 半 角 で 入 力 する 練 習 1 Excelを 起 動 させ Sheet1のセルA1に = と 入 力 し
Microsoft Word - Excel2_Excel関数_2013.docx
表 計 算 ソフト(Excel) 講 習 会 テキスト 関 数 編 明 治 大 学 教 育 の 情 報 化 推 進 本 部 目 次 1. 関 数 の 入 力... 3 1.1. 関 数 とは... 3 1.2. 関 数 の 基 本 構 造... 4 1.3. 関 数 の 入 力 方 法... 5 2. よく 使 う 関 数... 7 2.1. SUM 関 数... 7 2.2. AVERAGE 関
はじめての帳票作成
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 基礎 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 Ｆ Ｍビル TEL 06 6339-9065 Word 基礎 1. Wordとは 2. 文字入力 変換 3. 文書の入力
ii Excel Excel IF IF IF VLOOKUP HLOOKUP IF VLOOKUP HLOOKUP ExcelVBA Excel Excel Excel Web p Excel Excel Excel
Excel Excel Excel Excel Excel Excel Excel ii Excel Excel IF IF IF VLOOKUP HLOOKUP IF VLOOKUP HLOOKUP ExcelVBA Excel Excel Excel Web p Excel Excel Excel iii Excel Excel 1 Excel 3 6 11 15 18 19 24 26 28
2004/01/12 1 2004/01/23 2 I- - 10 2004/04/02 3-6 2004/04/03 4-1-5-1,-1-8-1,-2-2-1,-3-4-1,-3-5-1,-4-2-1, -5-4-2,-5-6-1,-6-2-1 4. _.doc 1
4 2004 4 3 2004/01/12 1 2004/01/23 2 I- - 10 2004/04/02 3-6 2004/04/03 4-1-5-1,-1-8-1,-2-2-1,-3-4-1,-3-5-1,-4-2-1, -5-4-2,-5-6-1,-6-2-1 4. _.doc 1 - - I. 4 I- 4 I- 4 I- 6 I- 6 I- 7 II. 8 II- 8 II- 8 II-
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
2 R 1 2.1 2.1: R R [ 1.1] [ 2.1] R R R plot() contour() 2
![2 R 1 2.1 2.1: R R [ 1.1] [ 2.1] R R R plot() contour() 2](/thumbs/39/20135249.jpg "2 R 1 2.1 2.1: R R [ 1.1] [ 2.1] R R R plot() contour() 2")
1 R for Windows R Windows Mac OS X Linux Windows 1.1 1.2 R R cat( n ) R R-00.0(00.0 ) etc Rconsole font=tt Courier New font = TT MS Gothic points = 10 points = 14 Rdevga TT Arial TT MS Gothic R demo(japanese)
communicate_task_ref.ps
Sametime Communicate ii Sametime Communicate Sametime Communicate................ 1 iii iv Sametime Communicate Sametime Communicate IBM Sametime IBM Sametime 1. IBM Sametime Sametime > [] [] [] [ ] []
CX-G6400 ユーザーズガイド
CX-G6400 CANON FINETECH INC. 2017 4Y1-8609-020 1 1 2 2 2 2 3 1. 5 / 5 6 7 8 10 11 USB 12 LAN 13 / 14 14 15 16 2. 32 35 35 36 3. 38 38 39 40 41 43 48 50 57 58 60 62 63 64 65 66 67 68 69 70 71 72 73 74 75
2/14 ) USB ( ( ) [ ( )] ) ( 3.
![2/14 ) USB ( ( ) [ ( )] ) ( 3.](/thumbs/43/23148791.jpg "2/14 ) USB ( ( ) [ ( )] ) ( 3.")
1/14 10 (SD) 2 (USB) USB USB 2/14 ) USB ( 1. 2. ( ) [ ( )] ) ( 3. 3/14 ( ) ] [ 4/14 1 [ / ] 5/14 ( ) ( ) ( ) ( ) 6/14 ( ) ( ) ( ) ] [ 7/14 Esc 3.0 Vista Home Premium Vista Ultimate ] ( ) [ 8/14 " " 20
オンラインによる 「電子申告・納税等開始（変更等）届出書」 提出方法
18 2 1 OS 2 OS WWW OS Windows 2000 Professional Windows XP (Home Edition) Windows XP (Professional Edition) WWW Microsoft Internet Explorer 6.0 Windows 98 Windows Me WindowsNT OS e-tax 3 Internet Explorer
PDF PDF Windows Vista Windows Vista Windows Windows XP Windows XP Windows Microsoft Office Excel 2007 Excel 2007 Excel Microsoft Office Excel 2003 Excel 2003 Excel Windows Internet Explorer 7 Internet
or57_4_175.dvi
c Excel Excel Excel Excel Microsoft Excel 1. OR Microsoft Excel Excel 1 Excel Excel Excel or 2007 Excel OR Excel Excel LP Excel LP Excel 112 8551 1 13 27 1 Excel Excel Excel 2010 Excel OpenOffice Calc
橡Taro13-EXCEL統計学.PDF
Excel 4.1 4.1.1 1 X n X,X, 1,Xn X=X X X /n 1 n Excel AVERAGE =AVERAGE Excel MEDIAN 3 =MEDIAN Excel MODE =MODE 4.1. 1 Excel MAX MIN =MAX MIN n X,X,,X X 4-1 1 n V X1-X + X-X + + Xn-X V= n 0 0 Excel VARP
NL-22／NL-32取扱説明書_操作編
MIC / Preamp ATT NL-32 A C ATT AMP 1 AMP 2 AMP 3 FLAT FLAT CAL.SIG. OVER LOAD DET. AMP 4 AMP 5 A/D D/A CONV. AMP 6 AMP 7 A/D CONV. Vref. AMP 8 AMP 10 DC OUT AMP 9 FILTER OUT AC DC OUT AC OUT KEY SW Start
untitled
Microsoft Excel 1. 2. 3. 4. VBA) A IV 256 BMI (Body Mass Index) AVERAGE,COUNTIF BMI ( kg ) = 22 ( m) 2 BMI (Body Mass Index) BMI = ( kg ( m ) ) 2 BMI BMI 20 BMI 20 24 BMI 24 26.5 BMI 26.5 E1 kg Del Back
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
( 28 ) ( ) ( ) 0 This note is c 2016, 2017 by Setsuo Taniguchi. It may be used for personal or classroom purposes, but not for commercial purp
( 28) ( ) ( 28 9 22 ) 0 This ote is c 2016, 2017 by Setsuo Taiguchi. It may be used for persoal or classroom purposes, but ot for commercial purposes. i (http://www.stat.go.jp/teacher/c2epi1.htm ) = statistics
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
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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 SHIFT SHIFT 44 SHIFT SHIFT 45 46 47 48 49 50 51 52 53 D Y N A B O O K 54 BACKSPACE
untitled
FutureNet Microsoft Corporation Microsoft Windows Windows 95 Windows 98 Windows NT4.0 Windows 2000, Windows XP, Microsoft Internet Exproler (1) (2) (3) COM. (4) (5) ii ... 1 1.1... 1 1.2... 3 1.3... 6...
iNotes_PDF.ps
IBM SmartCloud inotes IBM SmartCloud inotes IBM SmartCloud inotes IBM SmartCloud inotes 57 IBM SmartCloud inotes IBM SmartCloud inotes IBM SmartCloud inotes User's Guide 1 2012.5 Copyright IBM Corporation
Ruby Ruby ruby Ruby G: Ruby>ruby Ks sample1.rb G: Ruby> irb (interactive Ruby) G: Ruby>irb -Ks irb(main):001:0> print( ) 44=>
Ruby Ruby 200779 ruby Ruby G: Ruby>ruby Ks sample1.rb G: Ruby> irb (interactive Ruby) G: Ruby>irb -Ks irb(main):001:0> print( 2+3+4+5+6+7+8+9 ) 44 irb(main):002:0> irb irb(main):001:0> 1+2+3+4 => 10 irb(main):002:0>
1 1 ( ) ( 1.1 1.1.1 60% mm 100 100 60 60% 1.1.2 A B A B A 1
1 21 10 5 1 E-mail: qliu@res.otaru-uc.ac.jp 1 1 ( ) ( 1.1 1.1.1 60% mm 100 100 60 60% 1.1.2 A B A B A 1 B 1.1.3 boy W ID 1 2 3 DI DII DIII OL OL 1.1.4 2 1.1.5 1.1.6 1.1.7 1.1.8 1.2 1.2.1 1. 2. 3 1.2.2
FileMaker Pro 8.5 Tutorial
2004 2006 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker
「産業上利用することができる発明」の審査の運用指針（案）
1 1.... 2 1.1... 2 2.... 4 2.1... 4 3.... 6 4.... 6 1 1 29 1 29 1 1 1. 2 1 1.1 (1) (2) (3) 1 (4) 2 4 1 2 2 3 4 31 12 5 7 2.2 (5) ( a ) ( b ) 1 3 2 ( c ) (6) 2. 2.1 2.1 (1) 4 ( i ) ( ii ) ( iii ) ( iv)
関数とは 関数とは 結果を得るために 処理を行う仕組み です Excel2010 には あらかじめ関数が数式として組み込まれています たとえば SUM 関数 は 指定した値をすべて合計する 仕組みです 長い計算式や複雑な計算式を作成せずに 簡単に結果を求めることができます 例合計 =A1+A2+A3
エクセル Ⅱ( 中級 ) 福岡市私立幼稚園連盟 Microsoft Excel 2010 Ver,1.0 関数とは 関数とは 結果を得るために 処理を行う仕組み です Excel2010 には あらかじめ関数が数式として組み込まれています たとえば SUM 関数 は 指定した値をすべて合計する 仕組みです 長い計算式や複雑な計算式を作成せずに 簡単に結果を求めることができます 例合計 =A1+A2+A3+A4+A5+A6+A7+A8+A9
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
2 2 2 6 9 9 10 14 18 19 21 22 22 Java 23 24 25 25 26 30 31 32 39 46 53 55 58 2 2.0 2.0R Ver.2.0R Java Java 2.0 2.0R 2.0R 2.0 Ver2.0 2.0R Ver2.0R 19 Sun Sun Microsystems Java Java Sun Microsystems, Inc.
book
Bibliotheca21 Personal 3020-7-245-30 P-26D3-A114 Bibliotheca21 Personal 01-30 OS Windows 2000 Windows Server(R) 2003 Windows XP Windows Server(R) 2008 Windows Vista(R) Windows 7 Adobe Adobe Systems Incorporated
1 Excel 1. [Standard] (call [Call Standard]) Excel [ ] [E ] Excel m 1 ( ) (
![1 Excel 1. [Standard] (call [Call Standard]) Excel [ ] [E ] Excel m 1 ( ) (](/thumbs/100/146329187.jpg "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]
1
005 11 http://www.hyuki.com/girl/ http://www.hyuki.com/story/tetora.html http://www.hyuki.com/ Hiroshi Yuki c 005, All rights reserved. 1 1 3 (a + b)(a b) = a b (x + y)(x y) = x y a b x y a b x y 4 5 6
!!! 2!
2016/5/17 (Tue) SPSS (mugiyama@l.u-tokyo.ac.jp)! !!! 2! 3! 4! !!! 5! (Population)! (Sample) 6! case, observation, individual! variable!!! 1 1 4 2 5 2 1 5 3 4 3 2 3 3 1 4 2 1 4 8 7! (1) (2) (3) (4) categorical