IBMDocs_Help.ps
|
|
|
- ゆうりゅう じゅふく
- 5 years ago
- Views:
Transcription
1 Docs 1.0.5
2 ii Docs
3 IBM SmartCloud Docs A B C D E F G H I K L M N O P R S T U V W Word Excel CSV iii
4 PDF PDF iv Docs
5 v
6 vi Docs
7 Docs IBM SmartCloud Docs IBM SmartCloud Docs Getting Started app IBM SmartCloud Docs IBM SmartCloud Docs v v 69 v 199 IBM SmartCloud for Social Business Wiki IBM Corporation 2012,2014 1
8 2 Docs
9 IBM SmartCloud Docs Web Web IBM IBM SmartCloud System Requirements 3
10 4 Docs
11 IBM SmartCloud Docs IBM SmartCloud Docs v v v v v v v IBM SmartCloud Wiki Wiki Product Documentation IBM IBM SmartCloud Docs Wiki HTML Microsoft Windows IBM IBM IBM Human Ability and Accessibility Center : v 65 v 196 v 238 5
12 6 Docs
13 IBM SmartCloud Docs v v IBM terminology () A (access) (access level) (action) (acute accent) 1 (u) (add) (adjust) (administrator) (align) () (application) Copyright IBM Corp. 2012,2014 7
14 (area) (argument) (array) x3 (array formula) 1 (ascend) B (border) (browse) (browser) Web (button) C (cancel) Docs
15 (case) (cell range) 1 (character) (check) (clipboard) (close) (co-edit) (column) (10 ) (comma) 1. REXX 2. (comment) (community) (component) (copy) (criterion) (cursor) 9
16 D (data) (default) (descend) (dialog) 2 (display) (document) (download) ( ) (draft) (drag) E (edit) 10 Docs
17 (editor) (element) (entry) (error) (error value) (#N/A#DIV/0#Err 522 ) (event) (message) (expand) F (feature) ( ) ( ) (field) (file) (file name) (font) (9 Bodoni Modern ) (footer) (header) (format) 1. 11
18 2. (formatting) (formula) (function) G (given name) 1 1 (graphic) H (header) (footer) (heading) (hide) (highlight) (hyperlink) Web I (icon) 12 Docs
19 (image) (import) (information) (insert) (integer) K (keyword) L (language) (launch) (layout) (level) (link) (load) (lock) 13
20 M (master) (master style) (menu) (merge) (message) N (navigate) O (object) (open) (owner) P (page) (panel) 14 Docs
21 (parameter (parm)) (keyword) (parm) (parameter) (password) (press) (process) (publish) (publisher) R (range) 1 (reader) (real time) (reference) 1. IBM Docs 2. (response) (return) (row) 1 15
22 (ruler) S (save) (save as) (save) (search) (select) (server) (sheet) IBM Docs (sidebar) Web (sign) (slides panel) (sort) (specify) (split) 1 (start date) 16 Docs
23 (store) (strikethrough) (string) (style) (support) (symbol) (A Za z 0 (syntax) T (table) (team-based editing) (template) (text) (ASCII ) (toolbar) (topic) (trend arrow) 17
24 U (undo) (update) (upload) (user) V (value) (version) W (window) (word) 1 (write) 18 Docs
25 Lotus Symphony Microsoft Word v v 25 v 28 v 32 v 40 v 55 v 56 IBM SmartCloud Docs Wiki.odt.ott.doc.docx.dot.dotx.txt 19
26 : 1. IBM Docs IBM Docs 2. > > > 3. OK OK : > > : 20 Docs
27 19 IBM Docs.doc.odt 1. > OK
28 : x 3. : 4. () YourOrganizationName v v 3. v v : Docs
29 5. : IBM Lotus Symphony Web IBM Docs.doc.pdf 40 () : 25 IBM Docs IBM Lotus Symphony Web.odt.ott.doc.docx.dot.dotx.txt IBM Docs 4. IBM Docs IBM Docs 23
30 :.dot.dotx.ott, IBM Docs : IBM Docs : IBM Docs.doc.pdf 40 () : 25 IBM Docs Word Microsoft Word IBM Docs 1. Word Docs
31 3. IBM Docs IBM Docs? 4. OK IBM Docs :.doc IBM Docs IBM Docs 1. IBM Docs Lotus Symphony Documents.odt.ott Microsoft Word.doc.docx.dot.dotx TXT.txt 2. IBM Docs Lotus Symphony Documents.odt Microsoft Word.doc Adobe Reader.pdf : 25
32 21 23 IBM Lotus Symphony Web IBM Docs.doc.pdf 40 () () : 1. > : IBM Docs 2. > OK 26 Docs
33 :.doc.odt IBM Docs.docx.doc.txt > 1. > :.doc.odt IBM Docs.docx IBM Docs.doc.txt > IBM Docs.doc.pdf IBM Docs Microsoft Word.doc IBM Docs.docx.doc v v Microsoft Office > PDF PDF 27
34 v.odt > Microsoft Office PDF.doc PDF : 3. PDF OK :.txt : IBM Lotus Symphony Web () : 25 IBM Docs 28 Docs
35 a. b. c. v v : d. 5. : YourOrganizationName 6. : 32 : 21 29
36 23 IBM Lotus Symphony Web 27 IBM Docs.doc.pdf 40 () : 25 IBM Docs Docs
37 v v x v : 32 : IBM Lotus Symphony Web IBM Docs.doc.pdf 40 () : 25 IBM Docs 31
38 IBM Docs 32 Docs
39 Linda IT Linda 5 IT IBM Docs Linda Linda IBM Docs 5 Linda :
40 1. 2. IBM Docs : IBM Docs IBM Docs? IBM Docs IBM Docs 3. : > 4. : 5. > 6. : OK : 32 : Docs
41 v (Show Changes by This Editor) v : (Hide Changes by This Editor) : > : 32 :
42 @ IBM Tina Tina Tina Tina 36 Docs
43 Tina : > 3. Enter 4. 37
44 5. Enter > : 36 IBM Docs : > Docs
45 :@ : : 36 IBM Docs : 37 39
46 1. > Enter : 36 IBM Docs : () : Docs
47 23 IBM Lotus Symphony Web IBM Docs.doc.pdf : 25 IBM Docs () v > > > > > > > > 41
48 v v : H 2 O a Docs
49 2. > : > > :
50 > : : Docs
51 1. 2. > 3. > : : v 1. 45
52 2. Enter 1 : () Enter 2 3. v Enter 1 : () Enter Docs
53 > :
54 1. 2. > 3. : 4. OK 5. v Tab Shift+Tab v : : > Enter Tab Enter Enter 48 Docs
55 Web 1. > 2. URL Web URL URL 3. OK 4. > 49
56 1 v 1. > : OK v 8. : 1. > 50 Docs
57 2. 3. : OK : : : > > > 51
58 6. > v 1. > >. v 2. OK 1. > >. v 2. OK Docs
59 3. : 49 IBM Docs 1. > 2. > 3. v 1 v v v 4. > 53
60 1. > 2. : IBM Docs 3. 2 : ( ) OK PDF PDF 1. > PDF 2. PDF PDF PDF 54 Docs
61 3. OK OK Adobe Reader Adobe Reader 6. Adobe Reader > 7. OK 1. > [] : 1. 55
62 2. : OK : 55 1 v > 56 Docs
63 v OK
64 3. 1 : / > OK 58 Docs
65 : OK > : v v > > : v v 59
66 v v > > : v > v > v > v v v Docs
67 : : 57 / / : : v > v > v > 61
68 v > : / 3. > > 62 Docs
69 3. () > Enter 2 > > > > > > > > > > > > > 63
70 4. > > > > > > 1 64 Docs
71 4. () > > 5. ( ) > > 6. > > > Windows Mac OS Ctrl Command 7. IBM Docs Ctrl+A Ctrl+B Ctrl+I Ctrl+S Ctrl+U 65
72 7. IBM Docs () 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 Enter Page Up Page Down Tab : Tab Tab () Shift+Tab Shift+Tab () Esc 1 Shift+ 1 Shift+ 1 Shift+ 1 Shift+ Shift+Enter Alt+Shift+F Mac OS Mac OS Mac OS Mac OS Mac OS Alt+Shift+E Alt+Shift+V Alt+Shift+I Alt+Shift+M 66 Docs
73 7. IBM Docs () Mac OS Mac OS Mac OS Mac OS 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 Ctrl+Shift+H Alt+F10 Ctrl+Shift+F Alt+F10 67
74 68 Docs
75 IBM SmartCloud Docs IBM SmartCloud Docs v v 80 v 83 v 88 v 94 v 117 v 123 IBM SmartCloud Docs Wiki Web 1. IBM Docs 2. > > > 69
76 3. : () 4. OK : IBM Docs.xlsx : 94 : 73 IBM Lotus Symphony Web Docs
77 IBM Docs.xlsx.ods 1. > OK : x 71
78 3. : 4. () YourOrganizationName v v 3. v v : : 72 Docs
79 80 82 : 76 Web IBM Lotus Symphony Web.ods.ots.xls.xlsx.xlt.xltx.csv IBM Docs 4. IBM Docs IBM Docs : v 10,000 1,024 v.xlt.xltx.ots IBM Docs : 73
80 v IBM Docs v.jpg.jpeg.png.gif.bmp.xlsx.wmf.emf.tif.tiff.xlsx : IBM Docs (.xls.xlsx.ods.pdf ) : 76 Web.txt.csv 1. > 74 Docs
81 2. 3. ASCII 4. : Excel Microsoft Excel IBM Docs 1. Excel IBM Docs IBM Docs? 4. OK IBM Docs :.xls IBM Docs 75
82 Web 8. IBM Docs IBM Lotus Symphony Spreadsheets.ods.ots Microsoft Excel.xls.xlsx.xlt.xltx TXT.txt.csv 9. IBM Docs Spreadsheets IBM Lotus Symphony Spreadsheets.ods Microsoft Excel.xls.xlsx Adobe Reader.pdf TXT.csv : IBM Lotus Symphony Web 78 IBM Docs (.xls.xlsx.ods.pdf ) Docs
83 () : 1. > : IBM Docs 2. > OK :.xls.ods IBM Docs.xlsx.xls.csv > : > 77
84 2. 3. :.xls.xlsx.ods.els IBM Docs.csv > : IBM Lotus Symphony Web IBM Docs (.xls.xlsx.ods.pdf ) 77 () 80 : 76 Web IBM Docs (.xls.xlsx.ods.pdf ) IBM Docs.xlsx.xlsx 78 Docs
85 1. 2. v v Microsoft Office > PDF PDF v.ods > Microsoft Office PDF.xls.xlsx PDF : 3. PDF OK :.csv : 73 IBM Lotus Symphony Web 77 : 76 Web CSV.csv 1. > > CSV.csv 79
86 2. : a. b. c. v v : 80 Docs
87 d. 5. : YourOrganizationName 6. : 84 IBM Docs 88 IBM Docs :
88 77 () v x v v : 84 IBM Docs 88 IBM Docs : 82 Docs
89 IBM Docs 83
90 IBM Docs USB Lotus Symphony Microsoft Office 84 Docs
91 Lotus Symphony WindowsLinuxMac OS IBM Docs IBM Docs IBM Docs Linda IT Linda 5 IT Linda IBM Docs Linda Linda 5 Linda 5 Linda : 99 ( ) IBM Docs :
92 : IBM Docs : IBM Docs IBM Docs? IBM Docs IBM Docs 3. : > 4. : 5. > Docs
93 : OK : 84 IBM Docs : > : : 84 IBM Docs :
94 80 IBM Docs 88 Docs
95 @ Tina Tina Tina Tina Tina :
96 > 3. Enter : 11 > 6. Enter > 90 Docs
97 : 88 IBM Docs : > 2. 91
98 :@ : : 88 IBM Docs : Docs
99 1. > Enter : 88 IBM Docs :
100 : Docs
101 : : 193 IBM Docs IBM Docs v.xls.ods v.xlsx v IBM Docs v v > 95
102 v > : v > : v v Docs
103 :.xlsx IBM Docs > : 94 : 69 : a. b. 97
104 : 2. a. > b. :.ods.xls.xlsx > 3. OK > 98 Docs
105 3. OK ( ) IBM Docs $25.45 % 12:31:57 (HH:MM:SS) > : IBM Docs Microsoft Excel IBM Symphony () IBM Docs 2 2 3e E+10 99
106 ,235 1, % : 100 (.08 8% ) $ E+03 : IBM Docs (.) (,). Web > > US : 84 IBM Docs : Docs
107 IBM Docs Enter : > (Autocomplete Cell Entries) 2011, ( ) :
108 1 v v v / / : v 1. > OK v 1. > OK 102 Docs
109 Web 1 1. URL ( 2. Enter 3. URL URL 4. URL : URL URL : 103
110 103 Web v v v v : v v 104 Docs
111 v / 1 1. > 2. v v 3. PDF PDF 105
112 1. > PDF 2. v v v v PDFPDF PDF v 106 Docs
113 3. OK OK Adobe Reader Adobe Reader 6. Adobe Reader > 7. OK 1. > [] : 107
114 : 4. OK 108 Docs
115 IBM Docs 2 v 1. () 2. () 3. () v 109
116 2 v v 1 v 1 v v v Docs
117 v : 1 v : 10 v : 111
118 v : 2 1 XY 2 1 (X ) 1 (Y ) 1 v v v v v v v 112 Docs
119 v v > : 3. OK 4. : 113
120 5..png : v (.xls.xlsx.ods) IBM Docs IBM Docs v 114 Docs
121 : : v v IBM Docs Microsoft Excel 2003.xls Ctrl+X Ctrl+C Ctrl+V : IBM SmartCloud Docs
122 : : 8. OK Docs
123 : OK 3. OK A1:B4 Unicode 1. : () 2. > 117
124 () > 3. Alt OK Esc 4. v > v > v > > v > > : 1. a. 1 b. > 118 Docs
125 2. a. : b. > 3. : 1. v 1 > v 2. v > v : A1 =Sheet1!A1 1 A1 2 A1 1 A1 119
126 1. 2. : Enter () (IE ) 1. : 2. Ctrl+X Ctrl+C 3. : 50, Ctrl+V : Ctrl+A > > 3. : ( ) (_) rc IBM Docs 120 Docs
127 (Q2 FY98) / v v 5. OK 1. > >
128 v v 4. : v.xls.xlsx IBM Docs v ( ) 1. > > 2. X 3. OK 4. IBM Docs IBM Docs 1 ( B25) =A1+A2 A4 B4 B4 =B1+B2 IBM Docs 122 Docs
129 $B$25 ($) $Sheet2!$B$25 $ : : 125 (=) Enter 123
130 (!) ( 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)) =SUM(B:B) =IF(trim(A1)="","Cell should not be empty",a1) A1 10 A1 16 A1 A2 1 A1 B10 B14 B8 B10 B14 B8 B : +-*/ =SUM(A1:B1) =A1+B1 =(1+2)*3 =1+2*3 : 124 Docs
131 12. +-*/%^ & =<><=>=<> :, : 122 : : : : 152 FREQUENCY FREQUENCY 126 IBM Docs 125
132 IF() 167 MMULT MMULT SUMPRODUCT SUMPRODUCT : IBM Docs { } ( ) (TRUEFALSE) (,) 13. ={1,2,3} =SIN({1,2,3}) SIN : 152 FREQUENCY FREQUENCY MMULT MMULT SUMPRODUCT SUMPRODUCT : IF() 126 Docs
133 {=IF(A1:A3>0,"yes","no")} >0 A1:A3 14. A B () B () 1 1 {=IF(A1:A3>0,"yes","no")} 2 0 {=IF(A1:A3>0,"yes","no")} 3 1 {=IF(A1:A3>0,"yes","no")} : 152 FREQUENCY FREQUENCY MMULT MMULT SUMPRODUCT SUMPRODUCT : v 145 DATE v 146 DATEDIF v 146 DATEVALUE v 147 DAY v 147 DAYS v 148 DAYS360 v 154 HOUR v 167 MINUTE v 169 MONTH v 169 NETWORKDAYS v 170 NOW v 179 SECOND v 185 TIME v 185 TIMEVALUE v 186 TODAY v 190 WEEKDAY v 191 WEEKNUM v 192 WORKDAY v 192 YEAR 127
134 : : 140 CONVERT CONVERT : 15. C D 2 X Y v v v v v v v v v v v v v v v v v 149 ERRORTYPE 152 FORMULA 157 ISBLANK 158 ISERR 158 ISERROR 158 ISEVEN 159 ISFORMULA 159 ISLOGICAL 159 ISNA 160 ISNONTEXT 160 ISNUMBER 160 ISODD 161 ISREF 161 ISTEXT 169 N 169 NA 187 TYPE 128 Docs
135 : : 134 AND AND TRUE TRUE 1 FALSE FALSE 150 FALSE FALSE FALSE FALSE() FALSE 156 IF IF 170 NOT NOT 171 OR OR 1 TRUE TRUE FALSE FALSE 186 TRUE TRUE TRUE TRUE() TRUE : v 132 ABS v 132 ACOS v 132 ACOSH v 134 ASIN v 134 ASINH v 135 ATAN v 135 ATAN2 v 135 ATANH v 137 CEILING v 140 COMBIN v 143 COS v 143 COSH v 144 COUNTBLANK v 145 COUNTIF v 148 DEGREES v 149 EVEN v 149 EXP v 150 FACT v 152 FLOOR 129
136 v v v v v v v v v v v v v v v v v v v v v v v 157 INT 162 LN 163 LOG 163 LOG MOD 171 ODD 172 PI 172 POWER 173 PRODUCT 173 RADIANS 173 RAND 174 RANDBETWEEN 176 ROMAN 176 ROUND 177 ROUNDDOWN 177 ROUNDUP 179 SIN 180 SINH 180 SQRT 182 SUBTOTAL 182 SUM 183 SUMIF 187 TRUNC : v 133 ADDRESS v 137 CHOOSE v 139 COLUMN v 139 COLUMNS v 151 FIND v 153 HLOOKUP v 155 HYPERLINK v 156 INDEX v 157 INDIRECT v 163 LOOKUP v 164 MATCH v 171 OFFSET v 177 ROW 130 Docs
137 v v v 178 ROWS 179 SHEET 188 VLOOKUP : v 136 AVERAGE v 136 AVERAGEA v 144 COUNT v 144 COUNTA v 161 LARGE v 165 MAX v 165 MEDIAN v 166 MIN v 168 MODE v 174 RANK v 180 SMALL v 181 STDEV v 181 STDEVP v 189 VAR v 189 VARA v 189 VARP v 190 VARPA : v 136 BASE v 138 CHAR v 138 CODE v 140 CONCATENATE v 148 DOLLAR v 150 EXACT v 151 FIXED v 161 LEFT v 162 LEN v 162 LENB v 164 LOWER v 166 MID v 173 PROPER v 174 REPLACE 131
138 v v v v v v v v v v 175 REPT 175 RIGHT 175 RIGHTB 178 SEARCH 181 SUBSTITUTE 184 T 185 TEXT 186 TRIM 187 UPPER 188 VALUE ABS ABS ABS() +/- =ABS(-56) 56 =ABS(12) 12 =ABS(0) 0 ACOS ACOS ACOS () () 0 PI =ACOS(-1) (PI ) =DEGREES(ACOS(0.5)) ACOSH ACOSH ACOSH (number) 132 Docs
139 number number number 1 =ACOSH(1) 0 =ACOSH(COSH(4)) 4 ADDRESS ADDRESS () ( $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) 133
140 AND AND TRUE TRUE 1 FALSE FALSE AND (TRUE1<52+3=7B8<10 ) (A1:C3) : #VALUE! AND( ) TRUE FALSE TRUE AND TRUE 12<1314>127<6 =AND(12<13,14>12,7<6) FALSE =AND(FALSE,TRUE) FALSE : 129 ASIN ASIN ASIN () () -PI/2 +PI/2 =ASIN(0) 0 =ASIN(1) (PI/2 ) =DEGREES(ASIN(0.5)) ASINH ASINH 134 Docs
141 ASINH (number) number number =ASINH(-90) =ASINH(SINH(4)) 4 ATAN ATAN ATAN () () -PI/2 PI/2 =ATAN(1) (PI/4 ) =DEGREES(ATAN(1)) ATAN2 ATAN2 x y ATAN2 (x_num,y_num) x y x (0, 0) (x_num, y_num) -pi pi (-pi ) =ATAN2(1,1) (PI/4 ) =ATAN2(-1, -1) (-3*pi/4 ) ATANH ATANH 135
142 ATANH (number) number ( number ) number -1 1 (-1 1 ) =ATANH( ) ( 1) =ATANH(-0.1) -0.1( ) 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) BASE BASE 0 9 A Z BASE (,, ) Docs
143 () 0 BASE(17,10,4) BASE(17,2) BASE(255,16,4) 16 00FF CEILING CEILING CEILING(,,) 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 CHOOSE CHOOSE 30 1 CHOOSE(index, value 1, value 2,...) index value 1value 2... : 137
144 v v index CHOOSE #VALUE! CHOOSE =SUM(A1:CHOOSE(1, A2, A3)) #ERROR! =CHOOSE(A1, B1, B2, B3, "Today", "Yesterday", "Tomorrow") A1 2 B2 A1 4 Today =CHOOSE(A1, B1, B2, B3, "Today", "Yesterday", "Tomorrow") A1 8 #VALUE! CHAR CHAR Unicode CHAR(number) number Unicode : Unicode Windows ANSI MAC ( ) number [128, 255] IBM Docs IBM Symphony IBM Docs ( ) Symphony () =CHAR(82) R =CHAR(255) ÿ CODE CODE CODE (text) text =CODE("Hieronymus") 72 =CODE("hieroglyphic") Docs
145 : ASCII Unicode COLUMN COLUMN 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) COLUMNS COLUMNS COLUMNS() 1 139
146 =COLUMNS(B5) =COLUMNS(A1:C5) 3 3 COMBIN COMBIN COMBIN (number,number_chosen) Number Number_chosen =COMBIN(8,2) CONCATENATE CONCATENATE 1 CONCATENATE( ) CONCATENATE("","","") CONVERT CONVERT CONVERT(number,from_unit,to_unit) number from_unit from-unit ""() to_unit to-unit ""() 140 Docs
147 /from_unit to_unit CONVERT #N/A from_unit to_unit CONVERT #N/A 16. g sg lbm u ozm () U () () 17. m mi Nmi Pica in ft yd ang 18. yr day hr mn sec 19. Pa atm mmhg 20. N dyn lbf 141
148 21. J e c cal ev HPh Wh flb BTU IT BTU 22. Power HP W 23. T ga 24. C F K 25. tsp tbs oz cup pt qt gal l (" " ) CONVERT #N/A 142 Docs
149 26. 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") 1000 : 128 COS COS COS (number) =COS(1.047) () =COS(RADIANS(60)) COSH COSH 143
150 COSH (number) =COSH(4) =COSH(EXP(1)) COUNT COUNT COUNT( ) =COUNT(2,4,6,"eight") =3 3 COUNTA COUNTA 0 COUNTA( ) =COUNTA(2,4,6,"eight") =4 4 COUNTBLANK COUNTBLANK 144 Docs
151 COUNTBLANK() =COUNTBLANK(A1:B2) A1A2B1B2 4 COUNTIF COUNTIF COUNTIF()?() * () B* B B??? B 3? * ~() A1:A B B2 =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") DATE DATE DATE 0 145
152 =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 2009 DATEDIF 2 DATEDIF (,, ) 27. Y M D MD () YM () YD () =DATEDIF(" "," ","YD") 29 =DATEDIF(" "," ","YD") 28 DATEVALUE DATEVALUE IBM Docs 146 Docs
153 DATEVALUE("text") text : v v xx =DATEVALUE("7/20/54") DAY DAY 1 31 DAY() =DAY(1) 31 =DAY(NOW()) =DAY(C4) C4 1901/12/31 31 : IBM Docs Microsoft Excel 3/1/ DAYS DAYS 2 2 DAYS(date_1,date_2) 1 2 date_1 date_2 =DAYS("1/1/2010",NOW()) =DAYS("10/10/1990","10/10/2000")
154 =DAYS("1/1/2015",NOW()) 430 DAYS360 DAYS DAYS360(date_1, date_2, type) 1 2 date_2 date_1 type type = 0 (NASD (National Association of Securities Dealers)) type <> 0 =DAYS360("1/1/2000",NOW()) DEGREES DEGREES DEGREES (number) number =DEGREES(PI()) 180 DOLLAR DOLLAR DOLLAR (value, decimals) value decimals : value 148 Docs
155 =DOLLAR(255) $ =DOLLAR( ,2) $ ERRORTYPE ERRORTYPE ERRORTYPE() A1 :518 =ERRORTYPE(A1) 518 EVEN EVEN EVEN() 0 =EVEN(2.3) 4 =EVEN(2) 2 =EVEN(0) 0 =EVEN(-0.5) -2 EXP EXP e e EXP () e 149
156 =EXP(1) e EXACT EXACT 2 TRUE EXACT( 1 2) =EXACT("IBM lab5""ibm Lab5") FALSE FACT FACT 1*2*3*4*... * FACT() FACT number! (number ) =FACT(0) 1 =FACT(3) 6 =FACT(0) 1 FALSE FALSE FALSE FALSE() FALSE FALSE() =FALSE() FALSE =NOT(FALSE()) TRUE : 150 Docs
157 129 FIND FIND 2 () FIND(find text,text,position) find text position position FIND text : FIND =FIND("S","Steve Jobs") 1 =FIND("s","Steve Jobs") 10 =FIND("e","Steve Jobs",4) 5 FIXED FIXED 3 FIXED (number, decimals, no thousands separators) number decimals no thousands separators () =FIXED( ,3) 1,234, =FIXED( ,3,1) : 3 (en_us) de
158 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 FORMULA FORMULA ( FORMULA ) #N/A FORMULA() A8 23 A1 FORMULA A8 FREQUENCY FREQUENCY FREQUENCY (NumberSequenceList_data,NumberSequenceList_bins) NumberSequenceList_data NumberSequenceList_bins 152 Docs
159 A B A FREQUENCY B2 5 5 B2 10 FREQUENCY B6 > FREQUENCY A B C > FREQUENCY B 1 ( ) C1:C6 {=FREQUENCY(A1:A11,B1:B5)} C1:C5 : IBM Docs 126 IF() HLOOKUP HLOOKUP HLOOKUP(search_criteria, array, index, sorted) search_criteria 153
160 ?() * () B* B B??? B 3? * ~() array 1 FALSE #N/A A1 B1 A4:AZ5 : AZ 52 A4 52A5 52 B1 =HLOOKUP(A1, A4:AZ5, 2) A1 B1 A4:AZ5 2 1 FALSE HOUR HOUR 0 23 HOUR() =HOUR(NOW()) C4 17:20:00 =HOUR(C4) Docs
161 =HOUR(0.5) /30/ :00:00 HYPERLINK HYPERLINK celltext URL celltext URL : F2 Shift+F10 HYPERLINK(url,celltext) url celltext () celltext URL =HYPERLINK(" =HYPERLINK(" =HYPERLINK(" =HYPERLINK($B4) B4 URL =HYPERLINK(" & "example.org" example.org =HYPERLINK("#Sheet1!A1","") Sheet1!A1 =HYPERLINK("file:///C:/writer.odt#Specification"," ") 155
162 Specification IF IF IF(TRUE FALSE ) TRUE FALSE TRUE () TRUE FALSE () FALSE IBM Docs =IF(A1>5,100,"") A () : 129 INDEX INDEX INDEX() () () () =INDEX(A1:B6,1,1) A1:B Docs
163 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 INT INT () =INT(5.7) 5 =INT(-1.3) -2 ISBLANK ISBLANK TRUE ISBLANK() 157
164 =ISBLANK(D2) FALSE ISERR ISERR #N/A TRUE ISERR() #N/A =ISERR(C5) FALSE ISERROR ISERROR (#N/A ) ISERROR #N/A #N/A#DIV/0#Err 522 TRUE ISERROR() =ISERROR(C8) FALSE ISEVEN ISEVEN TRUE FALSE ISEVEN() =ISEVEN(48) TRUE =ISEVEN(33) FALSE 158 Docs
165 =ISEVEN(0) TRUE =ISEVEN(-2.1) TRUE =ISEVEN(3.999) FALSE ISFORMULA ISFORMULA ISFORMULA() =ISFORMULA(C4) FALSE ISLOGICAL ISLOGICAL TRUE TRUE FALSE ISLOGICAL() =ISLOGICAL(D5) FALSE ISNA ISNA #N/A () TRUE ISNA() =ISNA(D3) FALSE 159
166 ISNONTEXT ISNONTEXT FALSE ISNONTEXT() () =ISNONTEXT(D2) FALSE =ISNONTEXT(D9) TRUE ISNUMBER ISNUMBER TRUE ISNUMBER() =ISNUMBER(C3) TRUE =ISNUMBER(C2) FALSE ISODD ISODD TRUE FALSE ISODD() =ISODD(33) TRUE =ISODD(48) FALSE =ISODD(3.999) TRUE 160 Docs
167 =ISODD(-3.1) TRUE ISREF ISREF ISREF() =ISREF(C5) TRUE ISTEXT ISTEXT TRUE ISTEXT() =ISTEXT(D9) TRUE =ISTEXT(C3) FALSE LARGE LARGE n LARGE(array,nth_position) array nth_position =LARGE(A1:C50,2) A1:C50 2 LEFT LEFT (1 ) 161
168 LEFT (, ) () LEFT("output",3) out LEN LEN LEN () =LEN("") 14 LEN( ) 8 LENB LENB LENB(text) text LENB 2 (DBCS) DBCS LENB 2 2 LENB 1 LENB("") 4 LENB( ) 8 LN LN e e Docs
169 LN () =LN(3) 3 ( ) =LN(EXP(321)) 321 LOG LOG LOG (,) () =LOG(10,3) 3 10 ( ) =LOG(7^4,7) 4 LOG10 LOG10 10 LOG10 (number) number 10 =LOG10(10) =LOG10(86) =LOG10(1E5) 10 1E5 5 LOOKUP LOOKUP VLOOKUP HLOOKUP LOOKUP 163
170 *all* all LOOKUP(,, ) 1 1 =LOOKUP(A1,D1:D100,F1:F100) D1:D100 A LOWER LOWER LOWER() =LOWER("EXAMPLE") example MATCH MATCH MATCH(search criterion,lookup_array,type) search criterion 1 1 lookup_array 1 1 type type Docs
171 0 type 0 type 0-1 type Microsoft Excel =MATCH(200,D1:D100) D D1:D ( ) 1 MAX MAX MAX 0 MAX() MAXA() () 0 MAX() (MAX("string") ) MAX( ) =MAX(A1,A2,A3,50,100,200) =MAX(A1:B100) MEDIAN MEDIAN MEDIAN(number 1,number 2,...number 255.) MEDIAN () MEDIAN MEDIAN 2 165
172 =MEDIAN(5,12,65,82,9) 12 =MEDIAN(5,12,65,82,9,78) 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 >=0Length=0 : MID(T,1,Length) LEFT(T,Length) =MID("output",4,3) put MIN MIN MIN 0 MIN() MINA() () 0 MIN() (MIN("string") ) MIN( ) 166 Docs
173 =MIN(A1:B100) MINUTE MINUTE 0 59 MINUTE() =MINUTE(NOW()) C4 17:20:00 =MINUTE(C4) 20 =MINUTE(0, ) 20 =MINUTE(20/(24*60)) 12/30/ :20:00 MMULT MMULT MMULT (array1,array2) array1 1 2 array2 1 2 MMULT 1 2 Enter : IBM Docs 126 IF() 167
174 29. MODE MOD MOD 1 MOD (,) * INT(/) =MOD(22,3) =MOD(11.25,2.5) 1.25 MODE MODE () MODE (number 1,number 2,...number 30) number 1, number 2,...number 30 A1:A11 A =MODE(A1:A11) Docs
175 MONTH MONTH 1 12 MONTH() =MONTH(1) 1 12/31/ : IBM Docs Microsoft Excel 1/31/190012/31/189912/30/ 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 NETWORKDAYS NETWORKDAYS 169
176 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 NOT NOT NOT() =NOT(A) A=TRUE A=FALSE : 129 NOW NOW NOW() =NOW()-A1 A1 170 Docs
177 ODD ODD ODD() 0 =ODD(1.2) 3 =ODD(1) 1 =ODD(0) 1 =ODD(-3.1) -5 OFFSET OFFSET OFFSET(reference,rows,cols,height, width) reference rows 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) OR OR 1 TRUE TRUE FALSE FALSE OR (TRUE1<52+3=7B8<10 ) (A1:C3) 171
178 : #VALUE! OR( ) TRUE FALSE 12<1113>2245=45 =OR(12<11,13>22,45=45) TRUE =OR(FALSE,TRUE) TRUE : 129 PI PI ( PI 14 ) PI() =PI() POWER POWER POWER() POWER (^) ^ =POWER(4,3) =4^ Docs
179 PRODUCT PRODUCT PRODUCT( ) PRODUCT number1 * number2 * number3 *... =PRODUCT(2,3,4) 24 PROPER PROPER PROPER () PROPER("ibm software lab") Ibm Software Lab RADIANS RADIANS RADIANS (angle) angle =RADIANS(270) π/2 RAND RAND 0 1 RAND() 173
180 =RAND() 0 1 RANDBETWEEN RANDBETWEEN RANDBETWEEN() IBM Docs IBM Docs Shift+Ctrl+F9 =RANDBETWEEN(20,30) RANK RANK RANK (number, ref, order) number ref order () order = 0 order = 1 =RANK(A10,A1:A50) A1:A50 A10 REPLACE REPLACE REPLACE() 174 Docs
181 =REPLACE(" ",1,1,"444") " " REPT REPT 255 REPT () REPT("", 2) RIGHT RIGHT () RIGHT () () RIGHT("Hui",2) ui RIGHTB 2 RIGHTB RIGHTB (, ) number () () 175
182 RIGHTB 2 RIGHTB RIGHTB("Single byte",4) byte ROMAN ROMAN ROMAN (number, form) number form =ROMAN(499,0) 499 CDXCIX =ROMAN(499,1) LDVLIV =ROMAN(499,2) XDIX =ROMAN(499,3) VDIV ROUND ROUND ROUNDDOWN ROUNDUP ROUND() =ROUND(2.348,2) 2.35 =ROUND( ,3) =ROUND(2.348,0) 2 =ROUND(2.5) 3 =ROUND(987.65,-2) Docs
183 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 =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 ROW ROW ROW ROW 177
184 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() 3 3 ROWS ROWS ROWS(array) 1 =Rows(B5) =ROWS(A10:B12) 3 (C1:D3) Rabbit =ROWS(Rabbit) 2 SEARCH SEARCH SEARCH(,, ) (?) (*) B* B B??? B 178 Docs
185 3? * (~) () =SEARCH(54, ) 10 SECOND SECOND 0 59 SECOND() =SECOND(NOW()) C4 17:20:17 =SECOND(C4) 17 =SECOND( )) 17 =SECOND(17/ (24*60*60)) 12/30/ :00:17 SHEET SHEET SHEET() () 2 2 =SHEET(2!A1) 2 SIN SIN SIN (number) 179
186 =SIN(PI()) 0((pi )) =SIN(PI()/2) 1 (pi/2 ) =SIN(RADIANS(30)) 0.5 (pi/2 ) SINH SINH SINH (number) =SINH(1) =SINH(-1) =2.868*SINH(0.0342*1.03) SMALL SMALL n SMALL(array,nth_position) array nth_position =SMALL(A1:C50,2) A1:C50 2 SQRT SQRT SQRT () 180 Docs
187 =SQRT(16) 4 =SQRT(-16) STDEV STDEV STDEV( ) number1,number1,...number30 =STDEV(A1:A50) STDEVP STDEVP STDEVP(number1,number2,...number30) number1,number1,...number30 =STDEVP(A1:A50) A1:A50 SUBSTITUTE SUBSTITUTE SUBSTITUTE (text,old,new,which) text old () new which 181
188 SUBSTITUTE(" ","3","abc") 12abc12abc12abc SUBSTITUTE(" ","3","abc",2) 12312abc123 SUBTOTAL SUBTOTAL SUBTOTAL (, ) AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARP SUM SUM SUM(number1, number2,...number30) =SUM(A1,A3,B5) 3 =SUM (A1:E10) A1 E10 SUN() 182 Docs
189 : 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 SUMIF(,, )?() * () B* B B??? B 3? * ~() : =SUMIF(A1:A10,"<0") =SUMIF(A1:A10,">0",B1:10) A1:A10 >0 B1:B10 SUMIF() COUNTIF() 183
190 SUMPRODUCT SUMPRODUCT 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 126 IF() T T T(value) 184 Docs
191 value : value T =T(12345) (12345 ) "" =T("12345") TEXT TEXT TEXT (, ) TIME TIME TIME() =TIME("0,0,0") 00:00:00 =TIME("4,20,4") 04:20:04 TIMEVALUE TIMEVALUE 10 IBM Docs TIMEVALUE("text") text 185
192 =TIMEVALUE("24:00") 0 HH:MM:SS 00:00:00 TODAY TODAY 2000/02/2 ( ) TODAY() TODAY =TODAY() TRIM TRIM TRIM () ( ) TRIM(" hello") "hello" TRUE TRUE TRUE TRUE() TRUE TRUE() A=TRUE B=FALSE =AND(A,B) FALSE =OR(A,B) TRUE =NOT(AND(A,B)) TRUE : 186 Docs
193 129 TRUNC TRUNC TRUNC() TRUNC(Number; 0) INT(Number) =TRUNC(1.239,2) =TRUNC( ,3) TYPE TYPE TYPE() 1 =2 =4 = 8 =16 = =TYPE(C2) 2 =TYPE(D9) 1 UPPER UPPER UPPER() =UPPER("Good Morning") GOOD MORNING 187
194 VALUE VALUE VALUE (text) text =VALUE("4321") 4321 : VALUE #VALUE! VLOOKUP VLOOKUP VLOOKUP VLOOKUP(, array,, )?() * () B* B B??? B 3? * ~() array 1 FALSE #N/A A1 B1 D1:E100 D1 100E1 100 D 188 Docs
195 B1 =VLOOKUP(A1, D1:E100, 2) A1 B1 D1:E FALSE VAR VAR VAR (number1, number2,...number30) number 1number 2...number 30 : VARP (TRUE FALSE) VARA =VAR(A1:A50) VARA VARA (TRUEFALSE ) VARA (value 1, value 2,... value 30) value 1value 2...value 30 TRUE value 1 FALSE 0 () : VARPA VAR =VARA(A1:A50) VARP VARP 189
196 VARP (number 1, number 2,... number 30) number 1number 2...number 30 : VAR (TRUE FALSE) VARPA =VARP(A1:A50) VARPA VARPA (TRUEFALSE ) VARPA (value 1, value 2,... value 30) value 1value 2...value 30 TRUE value 1 FALSE 0 () : VARA VARP =VARPA(A1:A50) WEEKDAY WEEKDAY 1 7 WEEKDAY(, ) () () 1 () 1 () 7() 190 Docs
197 32. () () 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") WEEKNUM WEEKNUM WEEKNUM (, ) 1 =2 = ( 1)=WEEKNUM(" ",1)and =WEEKNUM(" ",2)and IBM Docs () 191
198 WORKDAY WORKDAY WORKDAY(start date, days, holidays) days holidays C3 ("12/1/2001") D3 F3 J3 : "12/24/2001""12/25/2001""12/26/2001""12/31/2001""1/1/ 2002" =WORKDAY(C3,D3,F3:J3) 12/28/2001 YEAR YEAR YEAR() =YEAR(1) 1 12/31/ =YEAR(367) 367 1/1/ : IBM Docs Microsoft Excel 1/1/ Docs
199 33. 1 > URL ( > > > > > >
200 34. > > > (') (=) : SUM AVERAGE > > > > > Ctrl+C Ctrl+V Ctrl+X Ctrl+V 35. > 194 Docs
201 35. () CSV > > CSV 36. > > 37. > > > : ( ) IBM Docs 195
202 84 IBM Docs : 97 Windows Mac OS Ctrl Command Microsoft Windows Macintosh 38..pdf Enter Shift+Enter F2 Enter Ctrl+A Ctrl+B Ctrl+I Ctrl+U Ctrl+C Ctrl+V Ctrl+X Ctrl+P Ctrl+Y Ctrl+Z 196 Docs
203 38. () Ctrl+F Alt+Enter Ctrl+Enter Esc Delete Backspace ( ) Ctrl+S Tab Tab () Shift+Tab Shift+Tab () Ctrl+ () Shift+ () Home End Ctrl+Home Ctrl+End Shift+ Ctrl+Shift+ Alt Alt Alt Esc Alt+Shift+F Alt+F10 197
204 38. () Shift+F2 Shift+F2 ( ) Esc Ctrl+Page Up Ctrl+Page Down Ctrl+Tab Alt+Page Up Alt+Page Down 198 Docs
205 IBM SmartCloud Docs v v 207 v 209 v 213 v 219 IBM SmartCloud Docs Wiki IBM Docs : IBM Docs IBM Docs.ppt.pdf : 204 IBM Docs.odp.ppt.pptx.pdf 199
206 IBM Docs v v IBM Docs 1. > > 2. OK : IBM Docs IBM Docs.ppt.pdf : 204 IBM Docs.odp.ppt.pptx.pdf IBM Docs.pptx.odp 200 Docs
207 1. > OK : x 3. :
208 () YourOrganizationName v v 3. v v : : Docs
209 199 IBM Docs 200 IBM Docs 206 IBM Docs.ppt.pdf : 204 IBM Docs.odp.ppt.pptx.pdf IBM Lotus Symphony Web.odp.otp.ppt.pptx.pot.potx IBM Docs 4. IBM Docs IBM Docs 5..pot.potx.otp IBM Docs : IBM Docs 203
210 IBM Docs IBM Docs.odp.ppt.pptx.pdf 39. IBM Docs Lotus Symphony Presentations.odp.otp Microsoft PowerPoint.ppt.pptx.pot.potx 40. IBM Docs Lotus Symphony Presentations.odp Microsoft PowerPoint.ppt.pptx Adobe Reader.pdf 204 Docs : IBM Docs 200 IBM Docs 201
211 206 IBM Docs.ppt.pdf : 204 IBM Docs.odp.ppt.pptx.pdf () : 1. > : IBM Docs 2. > OK :.ppt.odp IBM Docs.pptx.ppt 1. > 205
212 2. 3. :.ppt.odp IBM Docs.pptx IBM Docs.ppt IBM Docs.ppt.pdf IBM Docs Microsoft PowerPoint.ppt IBM Docs.pptx.ppt v v Microsoft Office > PDF PDF v.odp > Microsoft Office PDF.ppt PDF : 3. PDF OK : Docs
213 199 IBM Docs 200 IBM Docs 201 : 204 IBM Docs.odp.ppt.pptx.pdf a. b. c. 207
214 v v : d. 5. : YourOrganizationName 6. : 210 IBM Docs 214 : Docs
215 v x v v IBM Docs 209
216 IBM Docs USB Lotus Symphony Microsoft Office 210 Docs
217 Lotus Symphony WindowsLinuxMac OS IBM Docs IBM Docs IBM Docs Linda IT Linda 5 IT Linda IBM Docs Linda Linda 5 Linda 5 Linda :
218 1. 2. : IBM Docs IBM Docs IBM Docs? IBM Docs IBM Docs 3. : > 4. : 5. > 6. : OK : 210 IBM Docs : 212 Docs
219 207 > : : 210 IBM Docs :
220 @ Tina Tina Tina Tina 214 Docs
221 Tina : Enter 215
222 4. 5. : 1 6. Enter : 214 : Docs
223 :@ :
224 7. : 214 : > Enter : 218 Docs
225 214 : IBM Docs : ( ) ()
226 3. 4. : v 1 v Ctrl 3. v v : > : 219 IBM Docs 221 ( ) () Docs
227 IBM Docs Presentations > 3. > ( ) ()
228 : 219 IBM Docs v v v > 3. [] 222 Docs
229 : 219 IBM Docs ( ) () IBM Docs 1. () > 2. >
230 : 4. > 1. > OK : 199 IBM Docs 200 IBM Docs IBM Docs.ppt.pdf : 204 IBM Docs.odp.ppt.pptx.pdf 224 Docs
231 PDF PDF 1. > PDF 2. PDF PDF PDF 3. OK OK Adobe Reader Adobe Reader 6. Adobe Reader > 7. OK : 225
232 1. 2. > 3. v v 4. [] : Docs
233 OK 1 227
234 1. v > v > 2. : > : 228 Docs
235 v v > v v 1 v > : > 1 229
236 > 1 v > v OK Docs
237 3. 1 : v > v > : : 231
238 v > v > : : Docs
239 : > > >
240 3. : v > v > v > v > : 234 Docs
241 > > 41. > > 235
242 41. () > > // 42. > 236 Docs
243 42. () > > > 43. > > 237
244 44. Enter > > > Windows Mac OS Ctrl Command 45. IBM Docs Ctrl+A Ctrl+B Ctrl+I Ctrl+U Ctrl+C Ctrl+V Ctrl+X Ctrl+M Ctrl+Y Ctrl+Z Ctrl+S Ctrl+P Esc 238 Docs
245 45. IBM Docs () Enter Delete Home End Page Up Page Down Ctrl+Tab ( ) Alt+Shift+F : Alt+F10 : Mac OS Fn+option+F10 Shift+F2 : Mac OS Shift+Fn+F2 Shift+F7 Shift+ Shift+Home End Tab 239
246 45. IBM Docs () Tab : Tab Shift+Tab Shift+Tab Shift+F10 : Esc 240 Docs
247 ,,,, (') , , background , , , 226 () 108, , 108, , 87, , 149, 152, 157, 158, 159, 160, 161, 169, , 132, 134, 135, 136, 137, 140, 143, 144, 145, 148, 149, 150, 152, 157, 163, 168, 171, 172, 173, 174, 176, 177, 179, 180, 182, 183, , 133, 137, 139, 151, 153, 155, 156, 157, 163, 164, 171, 177, 178, 179, , 136, 138, 140, 148, 150, 151, 162, 164, 166, 173, 174, 175, 178, 181, 184, 185, 186, 187, , 136, 144, 161, 165, 166, 168, 174, 180, 181, 189, , 167, , 145, 147, 148, 154, 167, 170, 179, 185, 186, 190, , 147, 169, 170, , 156, 170, 171, YEAR , , , , 82 29, 80, , 91, tables
248 () , , 77, , 82 94, CSV viewing , , , , , , indenting , 71, , finding Microsoft Excel 75 Microsoft Word , , show , Docs
249 , , 219 effects , viewing , viewing , , A ABS 132 ACOS 132 ACOSH 132 ADDRESS 133 AND 134 ASIN 134 ASINH 135 ATAN 135, 140, 163, 173, 176 ATAN2 135 ATANH 136 autofill 104 AVERAGE 136 AVERAGEA 136 B BASE 136 C CEILING 137 CHAR 138 CHOOSE 137 CODE 138 COLUMN 139 COLUMNS 139 CONCATENATE 140 CONVERT 140 COS 143 COSH 144 COUNT 144 COUNTA 144 COUNTBLANK 145 COUNTIF 145 CSV () 76 D DATE 145 DATEDIF 146 DATEVALUE 147 DAY 147 DAYS 147 DAYS DEGREES 148 DOLLAR 148 E Enter 193 ERRORTYPE 149 EVEN
250 EXACT 150 Excel 76 EXP 149 F FACT 150 FALSE 150 FIND 151 FIXED 151 FLOOR 152 FORMULA 152 FREQUENCY 152 H HLOOKUP 153 HOUR 154 HYPERLINK 155 hyperlinks I IF 156 INDEX 156 INDIRECT 157 INT 157 ISBLANK 157 ISERR 158 ISERROR 158 ISEVEN 158 ISFORMULA 159 ISLOGICAL 159 ISNA 159 ISNONTEXT 160 ISNUMBER 160 ISODD 160 ISREF 161 ISTEXT 161 L LARGE 161 LEFT 162 LEN 162 LENB 162 LN 163 LOG 163 LOOKUP 163 LOWER 164 M MATCH 164 MAX 165 MEDIAN 165 Microsoft Word 25 MID 166 MIN 166 MINUTE 167 MMULT 167 MOD 168 MODE 168 MONTH 169 N N 169 NA 169 NETWORKDAYS 170 NOT 170 NOW 170 O ODD 171 ODS (Lotus Symphony Spreadsheets) 76 OFFSET 171 OpenOffice 23 OR 171 P PDF (Portable Document Format) 76 PDF 76 PI 172 POWER 172 PRODUCT 173 PROPER 173 R RAND 173 RANDBETWEEN 174 RANK 174 REPLACE 174 REPT 175 RIGHT 175 RIGHTB 175 ROUND 176 ROUNDDOWN 177 ROUNDUP 177 ROW 177 ROWS 178 S SEARCH 178 SECOND 179 SHEET 179 SIN 179 SINH 180 SMALL 180 SQRT 180 STDEV 181 STDEVP 181 styles 48 SUBSTITUTE 181 SUBTOTAL 182 SUM 182 SUMIF 183 SUMPRODUCT 184 T T 184 tables TEXT 185 TIME 185 TIMEVALUE 185 TODAY 186 TRIM 186 TRUE 186 TRUNC 187 TYPE 187 U UPPER 187 URL 103 V VALUE 188 VAR 189 VARA 189 VARP 190 VARPA 190 VLOOKUP Docs
251 W Web 49 WEEKDAY 190 WEEKNUM 191 WORKDAY 192 X XSL (Excel) 76 XSLX (Excel) 76 '()
Symphonymaster.ps
IBM SmartCloud Docs 1.0 ii IBM SmartCloud Docs 2.......... 3.......... 3.......... 3....... 4........ 5......... 7...... 8..... 8..... 9............. 10........... 11... 11.............. 12.12....... 14..
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
資料 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 意見 要望 依頼方法 調査対象都道府県協会に選択を依頼した
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 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
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
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
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
橡統計担当者のためのエクセル表紙.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
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
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..............................................
ProVisionaire Control V3.0セットアップガイド
ProVisionaire Control V3 1 Manual Development Group 2018 Yamaha Corporation JA 2 3 4 5 NOTE 6 7 8 9 q w e r t r t y u y q w u e 10 3. NOTE 1. 2. 11 4. NOTE 5. Tips 12 2. 1. 13 3. 4. Tips 14 5. 1. 2. 3.
13 Student Software TI-Nspire CX CAS TI Web TI-Nspire CX CAS Student Software ( ) 1 Student Software 37 Student Software Nspire Nspire Nspir
13 Student Software TI-Nspire CX CAS TI Web TI-Nspire CX CAS Student Software ( ) 1 Student Software 37 Student Software 37.1 37.1 Nspire Nspire Nspire 37.1: Student Software 13 2 13 Student Software esc
(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 ではじめる数値解析 サンプルページ この本の定価 判型などは, 以下の 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
0.2 Button TextBox: menu tab 2
Specview VO 2012 2012/9/27 Specview Specview STSCI(Space Telescope SCience Institute) VO Specview Web page http://www.stsci.edu/resources/software hardware/specview http://specview.stsci.edu/javahelp/main.html
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
New version (2.15.1) of Specview is now available Dismiss Windows Specview.bat set spv= Specview set jhome= JAVA (C:\Program Files\Java\jre<version>\
![New version (2.15.1) of Specview is now available Dismiss Windows Specview.bat set spv= Specview set jhome= JAVA (C:\Program Files\Java\jre<version>\](/thumbs/92/109450602.jpg "New version (2.15.1) of Specview is now available Dismiss Windows Specview.bat set spv= Specview set jhome= JAVA (C:\Program Files\Java\jre<version>\")
Specview VO 2012 2012/3/26 Specview Specview STSCI(Space Telescope SCience Institute) VO Specview Web page http://www.stsci.edu/resources/software hardware/specview http://specview.stsci.edu/javahelp/main.html
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
Specview Specview Specview STSCI(Space Telescope SCience Institute) VO Specview Web page htt
Specview Specview Specview STSCI(Space Telescope SCience Institute) VO Specview Web page http://www.stsci.edu/resources/software_hardware/specview http://specview.stsci.edu/javahelp/main.html Specview
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
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..
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
ProVAL Recent Projects, ProVAL Online 3 Recent Projects ProVAL Online Show Online Content on the Start Page Page 13
ProVAL Unit System Enable Recording Log Preferred Language Default File Type Default Project Path ProVAL : Unit SystemUse SI Units SI SI USCS Enable Recording Log Language Default File Type Default Project
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)
桁区切りスタイルの表示形式 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")
はじめての帳票作成
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
グローバル タイトル変換テーブルの編集
19 CHAPTER SGM SGM GUI Global Title Translation GTT; 800 ID GTT Signaling Connection Control Part SCCP; Service Switching Point SSP; SubSystem Number SSN; GTT GTT CSV 16 SGM 3.3 3.1 4.0 4.1 4.2 GTT GTT
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...................................
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 )
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:
橡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
ACS電子ジャーナル利用マニュアル
American Chemical Society ACS Web Edition & Journal Archives American Chemical Society ACS 4 Web Edition 2002 7 1879 Journal Archives ACS 1...2 2 2-1...3 2-2...4 2-3...5 3 3-1 Abstract...6 3-2 Full Text
1:.anchors Menubar Sequence Navigation order Plot & Color options Left sidebar ON/OFF Right sidebar ON/OFF History / Bookmark Apply sequence order / p
GMV 2009 2 1 GMV GMV 1.1 GMV Murasaki GMV (GTK+ based Murasaki Viewer) 1.1.1 GMV GMV Murasaki (http://murasaki.dna.bio.keio.ac.jp/gmv.html) 1.1.2 gmv Open Anchors File ( 1) murasaki 1.1.3 GMV 2 GMV on/off
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.
1 I EViews View Proc Freeze
EViews 2017 9 6 1 I EViews 4 1 5 2 10 3 13 4 16 4.1 View.......................................... 17 4.2 Proc.......................................... 22 4.3 Freeze & Name....................................
<4D6963726F736F667420576F7264202D204850835483938376838B8379815B83578B6594BB2D834A836F815B82D082C88C60202E646F63>
例 題 で 学 ぶ Excel 統 計 入 門 第 2 版 サンプルページ この 本 の 定 価 判 型 などは, 以 下 の URL からご 覧 いただけます. http://www.morikita.co.jp/books/mid/084302 このサンプルページの 内 容 は, 第 2 版 発 行 当 時 のものです. i 2 9 2 Web 2 Excel Excel Excel 11 Excel
ＷｉｎＰＳＫユーザーズガイド
8 ae4jy@mindspring.com - 1 - - 2 - 5 5.. 5 5 5.. 6 6 1 1 1 1 1 1 1 1-3 - Status Bar 36-4 - Peter Martinez, WinPSK MHz Pentium Windows95,98 NT4.0 DX VGA640x480 Help MB RAM CPU WinPSK CPU CPU Too Slow CPU
フリーセルプロの使い方
FreeCell Pro 011 2 FreeCell Pro 2002 FCPRO.HLP FreeCell Pro6.4 6.5 FreeCell Pro 1000 http://solitairelaboratory.com/fcpro.html FreeCell Pro 2009 2 3 FreeCell Pro Microsoft FC 0 Windows 3.1 FreeCell Pr
For_Beginners_CAPL.indd
CAPL Vector Japan Co., Ltd. 目次 1 CAPL 03 2 CAPL 03 3 CAPL 03 4 CAPL 04 4.1 CAPL 4.2 CAPL 4.3 07 5 CAPL 08 5.1 CANoe 5.2 CANalyzer 6 CAPL 10 7 CAPL 11 7.1 CAPL 7.2 CAPL 7.3 CAPL 7.4 CAPL 16 7.5 18 8 CAPL
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
MOMW_I_,II 利用ガイド.PDF
MOMW (I), II 1 The Making of the Modern World I. The Making of the Modern World... 2 II.... 3 II-1... 3 II-2 Basic Search... 4 II-3... 5 II-4 Advanced Search... 9 II-5... 13 III.... 14 III-1... 14 III-2...
JavaScript の使い方
JavaScript Release10.5 JavaScript NXJ JavaScript JavaScript JavaScript 2 JavaScript JavaScript JavaScript NXJ JavaScript 1: JavaScript 2: JavaScript 3: JavaScript 4: 1 1: JavaScript JavaScript NXJ Static
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
Microsoft Word - Live Meeting Help.docx
131011 101919 161719 19191110191914 11191417 101919 1915101919 Microsoft Office Live Meeting 2007 191714191412 1913191919 12 151019121914 19151819171912 17191012151911 17181219 1610121914 19121117 12191517
LiveCode初心者開発入門サンプル
/ About LiveCode 01:... 11 02: Create... 15 set 03:... 21 name title LiveCode 04:... 29 global local width height 05:... 37 Controls Tools Palette Script Editor message handler 06:... 52 RGB 07:... 63
http://www1.iwate-ed.jp/ WindowsXP - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Introduction Purpose This training course demonstrates the use of the High-performance Embedded Workshop (HEW), a key tool for developing software for
Introduction Purpose This training course demonstrates the use of the High-performance Embedded Workshop (HEW), a key tool for developing software for embedded systems that use microcontrollers (MCUs)
Microsoft Word - D JP.docx
Application Service Gateway Thunder/AX Series vthunder ライセンスキー インストール 手順 1 1.... 3 2. vthunder... 3 3. ACOS... 3 4. ID... 5 5.... 8 6.... 8 61... 8 62 GUI... 10 2 1. 概要 2. vthunder へのアクセス 方法 SSHHTTPSvThunder
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,
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
POWERCHR.backup.OMB
PowerChrom Software Manual PowerChrom version 2.5 for Windows and Macintosh Computers 日本語解説書 PowerChrom www.edaq.jp ( 有 )ADInstruments ジャパン 本マニュアルは現時点での可能な限り正確な情報を記載しています 但し 記載されているソフトウエア およびハードウエアに関する事柄は将来変更される可能性があります
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,
1 1.1 PC PC PC PC PC workstation PC hardsoft PC PC CPU 1 Gustavb, Wikimedia Commons.
1 PC PC 1 PC PC 1 PC PC PC PC 1 1 1 1.1 PC PC PC PC PC workstation PC 1.1.1 hardsoft 1.1.2 PC PC 1.1 1 1. 2. 3. CPU 1 Gustavb, Wikimedia Commons.http://en.wikipedia.org/wiki/Image:Personal_computer,_exploded_5.svg
PDW-75MD
3-270-633-02(1) PDW-75MD 2007 Sony Corporation m a b c 2 ... 2 6 6... 8... 8 1... 10... 10... 12... 13... 13... 19... 23 2... 25... 26... 27... 27... 28... 29... 29... 29... 30... 31... 33 3... 34... 34...
Step 1 Feature Extraction Featuer Extraction Feature Extraction Featuer Extraction Image Analysis Start>Programs>Agilent-Life Sciences>Feature Extract
Agilent G2565AA Feature Extraction Step 1 Feature Extraction Step 2 Step 3 Step 4 ( ) Step 5 ( ) Step 6 Step 7 Step 8 Feature Extraction Step 9 Step 10 Feature Extraction Step 11 Feature Extraction Step
Microsoft Word - MetaFluor70取扱説明.doc
MetaFluor (Version 7.7) MetaFluor 1. MetaFluor MetaFluor Meta Imaging Series 7.x Meta Imaging Series Administrator CCD Meta Imaging Series Administrator CCD Molecular Devices Japan KK/ Imaging Team (1/14)
(
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..............
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]
BRADY Worldwide, Inc. BRADY BRADY BRADY BMP 51 BRADY Worldwide, Inc. Microsoft Windows Microsoft BRADY 2011 BRADY Worldwide, Inc. All Rights Reserved
BRADY Worldwide, Inc. BRADY BRADY BRADY BMP 51 BRADY Worldwide, Inc. Microsoft Windows Microsoft BRADY 2011 BRADY Worldwide, Inc. All Rights Reserved 2011 2 2 Brady Worldwide Inc. 6555 West Good Hope Road
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
cover-1
BMP 21-LAB BRADY Worldwide, Inc. BRADY BRADY BRADY BMP 21-LAB BRADY, Inc. Worldwide Microsoft Windows Microsoft Corporation BRADY 2013 BRADY Worldwide, Inc. All Rights Reserved 2014 1 Firmware 1 Brady
橡マニュアル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
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]
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
X Window System X X &
1 1 1.1 X Window System................................... 1 1.2 X......................................... 1 1.3 X &................................ 1 1.3.1 X.......................... 1 1.3.2 &....................................
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
職業訓練実践マニュアル 重度視覚障害者編Ⅰ
資料 3 訓練カリキュラムの詳細 支援機器 ソフトを利用した基本的なパソコン操作の習得 1-1 Windows の基本的な操作実施時期訓練前期 ( 習得済みの者については確認程度で終了 ) 実施内容 Windows アプリケーションの起動 終了操作の理解ダイアログボックスの理解タスクの切り替えファイル フォルダの理解拡張子の理解ショートカットの作成訓練の流れテキスト ( 電子ファイル ) に沿って
SR-X526R1 サーバ収容スイッチ ご利用にあたって
SR-X526R1 P3NK-3432-05Z0 526R1 V01 SR-X526R1 V01 2009 10 2010 4 2 2011 5 3 2012 3 4 2012 11 5 Microsoft Corporation Copyright FUJITSU LIMITED 2009-2012 2 SR-X526R1 V01...2...5...5...5...5...6...7...8...8...11...11...11...11...11...11...12...12...12...12...13...13...13
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.
HIS-CCBASEver2
Information Access Interface in the Immersive Virtual World Tetsuro Ogi, *1*2*3 Koji Yamamoto, *3*4 Tadashi Yamanouchi *3 and Michitaka Hirose *2 Abstract - In this study, in order to access database server
2
WJ-HD150 Digital Disk Recorder WJ-HD150 2 3 q w e r t y u 4 5 6 7 8 9 10 11 12 13 14 15 16 q w SIGNAL GND AC IN 17 SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY DAILY Program 1 Event No.1 Event
ワイヤレス～イーサネットレシーバー UWTC-REC3
www.jp.omega.com : esales@jp.omega.com www.omegamanual.info UWTC-REC3 www.jp.omega.com/worldwide UWIR UWTC-NB9 / UWRH UWRTD UWTC 61.6 [2.42] REF 11.7 [0.46] 38.1 [1.50] 66.0 [2.60] REF 33.0 [1.30]
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...
Bento 3
Bento 3 2007-2009 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento Bento FileMaker,Inc. Mac Mac Apple Inc. FileMaker FileMaker,
RTX830 取扱説明書
RTX830 JA 1 2 3 4 5 6 7 8 9 10 11 external-memory performance-test go 12 13 show config 14 15 16 17 18 19 20 save 21 22 23 24 25 26 27 save RTX830 BootROM Ver. 1.00 Copyright (c) 2017 Yamaha Corporation.
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.
AuthorManual_JSTP.ppt
ScholarOne Manuscripts Log In Create Account Main Menu Author Dashboard Step 1: Type, Title & Abstract Step 2: Attributes Step 3: Authors & Institutions Step 4: Reviewers Step 5: Details & Comments Step
解きながら学ぶＣ言語
printf 2-5 37 52 537 52 printf("%d\n", 5 + 37); 5370 source program source file.c ex00.c 0 comment %d d 0 decimal -2 -p.6 3-2 5 37 5 37-22 537 537-22 printf("537%d\n", 5-37); function function call ( )argument,
Systemwalker IT Service Management Systemwalker IT Service Management V11.0L10 IT Service Management - Centric Manager Windows
Systemwalker IT Service Management Systemwalker IT Service Management V11.0L10 IT Service Management - Centric Manager Windows Systemwalker IT Service Management Systemwalker Centric Manager IT Service
rzamhpdf.ps
IBM i 7.2 IBM i 7.2 43 IBM i 7.2 ( 5770-SS1) RISC CISC IBM IBM i Version 7.2 Security Service Tools 1 2014.4 Copyright IBM Corporation 2003, 2013. .............. 1 IBM i 7.2............ 1 PDF.........
rzat10pdf.ps
IBM i 7.2 IBM Navigator for i IBM IBM i 7.2 IBM Navigator for i IBM 9 IBM i 7.2 ( 5770-SS1) RISC CISC IBM IBM i Version 7.2 Connecting to your system Connecting to IBM Navigator for i Copyright IBM Corporation
Word 2007 Word 2007 Word Word 2003 Word 2007 Excel Web
Microsoft Office Word 2007 Microsoft Office Word 2007 Microsoft Office Word 2007 Office Professional 2007 1 / / 1 /5 Word 2007 Word 2007 Word 2007 Word Word 2003 Word 2007 Excel Web http://office.microsoft.com/ja-jp/word/ha100744321041.aspx
5.2 White
1 EViews 1 : 2007/5/15 2007/5/25 1 EViews 4 2 ( 6 2.1............................................ 6 2.2 Workfile............................................ 7 2.3 Workfile............................................
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
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
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
Fortran90/95 [9]! (1 ) " " 5 "Hello!"! 3. (line) Fortran Fortran 1 2 * (1 ) 132 ( ) * 2 ( Fortran ) Fortran ,6 (continuation line) 1
![Fortran90/95 [9]! (1 ) 5 Hello!! 3. (line) Fortran Fortran 1 2 * (1 ) 132 ( ) * 2 ( Fortran ) Fortran ,6 (continuation line) 1](/thumbs/48/24845697.jpg "Fortran90/95 [9]! (1 ) 5 Hello!! 3. (line) Fortran Fortran 1 2 * (1 ) 132 ( ) * 2 ( Fortran ) Fortran ,6 (continuation line) 1")
Fortran90/95 2.1 Fortran 2-1 Hello! 1 program example2_01! end program 2! first test program ( ) 3 implicit none! 4 5 write(*,*) "Hello!"! write Hello! 6 7 stop! 8 end program example2_01 1 program 1!
MYWORDⅤ Pro 操作マニュアル
This software is a human word proccessor for the blind,the lowvision and general people. new AOK system MYWORD MYWORD Windows XP Windows DOS/V NEC PC-9821 DOS/V NEC PC-9821 DOS/V Esc ESC Tab TAB Ctrl CTRL
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
改訂履歴
EXCEL 関数の利用 2015.01.16 改訂履歴 目次 使用可能な EXCEL 関数 論理関数統計関数数学 三角関数検索 行列関数文字列操作関数 入れ子の計算式 年月日 / 時刻の計算 年月日 / 時刻の計算結果表示 計算結果データ型 旧形式と新形式の計算式クラスター 旧形式から新形式への計算式クラスターの変更 EXCEL 計算式におけるConMas i-reporterの仕様制限 EXCEL
¥¤¥ó¥¿¡¼¥Í¥Ã¥È·×¬¤È¥Ç¡¼¥¿²òÀÏ Âè2²ó
2 2015 4 20 1 (4/13) : ruby 2 / 49 2 ( ) : gnuplot 3 / 49 1 1 2014 6 IIJ / 4 / 49 1 ( ) / 5 / 49 ( ) 6 / 49 (summary statistics) : (mean) (median) (mode) : (range) (variance) (standard deviation) 7 / 49
GM-F520S/GM-F470S/GM-F420S
GM-F520S GM-F470S GM-F420S LCT2504-002A-H 2 3 4 200 150 150 50 1 3 4 1 2 3 1 2 3 4 5 e 6 7 8 9 p q w r t 5 6 5 23 7 8 9 p q 4 5 6 7 8 9 2 3 4 5 5 23 6 7 8 9 w 1 2 e r t p p 5 6 9( 3 DVI-D (HDCP) RGB IN
HARK Designer Documentation 0.5.0 HARK support team 2013 08 13 Contents 1 3 2 5 2.1.......................................... 5 2.2.............................................. 5 2.3 1: HARK Designer.................................
z-tree 2005 4 1 1 4 1.1............................ 4 1.2.............................. 5 1.3......................................... 5 1.4............................................. 5 1.5................................
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>