i I Excel iii Excel Excel Excel
|
|
|
- ゆゆこ かやぬま
- 5 years ago
- Views:
Transcription
1 Excel
2 i I Excel iii Excel Excel Excel Excel
3 (SUM ) (AVERAGE ) (RANK ) (IF ) (VLOOKUP ) (VLOOKUP ) (MATCH ) (IFERROR ) (RANDBETWEEN ) (COUNTIF ) (COUNTIFS ) ii
4 I Excel
5 1 1 Excel 1 2 ([Ctrl]) [Ctrl] windowsos : Esc F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 [Ctrl] + c [Ctrl] + a [Ctrl] + x [Ctrl] + v [Ctrl] + z [Ctrl] + s [Ctrl] + p Excel Excel ( ) ) F8 ) Excel Excel Word ( )
6 2 2 Excel Excel Microsoft Office Microsoft Office Excel Excel Microsoft Office Excel 2010 ( ) 2.1: Windows 7 2.2: 2.3: 2.2 Excel Excel 2.4 Excel Sheet( ) Book( ) Sheet A,B,C,... 1,2,3,... A1 Book1.xlsx 1 (Sheet1,Sheet2,Sheet3) 1 Excel2010.xslx
7 2.4: Excel ➀ ➁ / ➂ / ➃ ➄ ➃ ➄ ➅ A,...,Z,AA,...,AZ,BA,...,BZ,CA,...,XFA,...,XFD 16, ,048,576 Ctrl A1 ➆ Book Sheet
8 ➇ ➈ ➉ 2.3 Excel Excel 2.5 Excel 2.5: Excel ( ) 2.4 Excel USB Excel :
9 ˆ 2.6 ˆ ˆ Excel xlsx PDF Excel2003 Excel xls 2.7: 2.1: ( )? : < >
10 6 3 Excel Excel 3.1 Excel 3.1 OK : 3.2 Excel sheet1 sheet2 sheet3 1. sheet1 3.4 Sheet1 ( ) Sheet4 2.
11 3.2: 3.3: 3.4: 3.5:
12 Sheet2 3.6: Sheet : OK OK 3.8 Sheet2 Sheet4 3.3 Sheet1 Sheet2 3.9 Sheet BackSpace Delete
13 3.8: Sheet2 Sheet4 3.9: Sheet2 3.10:
14 3.4 Excel 1. Shift 3.11 A1 C3 3.11: (A1 C3 ) 2. Ctrl 3.12:
15 3.5 Excel A1 A Enter Tab 3.13: Tab 3.14:
16 / : /12/14 15:53 Excel ( 1 24 ) ( ) 3.15: : Enter Shift + Enter Tab Shift + Tab Excel 13.5 (18 ) 8.38 (72 ) mm mm 8.38 MS P
17 3.16: 3.16 A1 abcdefghijklmnopqrst A1 B2 A 3.17 A B ) 3.17: J J1
18 ➀ : ➁ ➂ 3.19: J
19 % % :
20 3.7.4 Delete ( ) :
21 Excel Excel 2,4,6,8 A1 A11 1,2,3,,10,11 1 ( ) 1. (a) 1 (a) A1 A2 2 (b) A1 A2 (c) A2 ( ) (d) A11 (e) : A1 1 A11 (a) A1 (b) A1 (c) A11 (d) 1 (e) (f) : 1 11
22 2. 1 A : 3.25: 3.26: A1 1 A2 2 A1 A OK A A ( 2/21) ) A1 1 3/ A
23 3.27: 3.9 A B C D E 1 10 Excel 3.28: A B C D E 1 10 Ctrl + z )
24 3.29: Excel A B B : C 3.32
25 3.31: C C 3.32: C5 C
26 3.33:
27 C Excel 1. ) - / ˆ 2. = >= > <= < <> 3. 2 ( ) =A1& ABC A1 ABC
28 4. :, A1:C3 A1,A2,A3,B1,B2,B3,C1,C2,C3 A1:C2,E1:F2 A1,A2,B1,B2,C1,C2,E1,E2,F1,F = () ) 3.34 A1 =1+(6-3)*2 Enter : A A1 2 B1 5 ( ) C1 C1 =A1*B : C1 =A1 B A1 B1
29 3.36: C1 = A :
30 3.12 Excel Ctrl + c Ctrl + v A1 Ctrl + c A2 Ctrl + v 2 A A1 B1 Ctrl + c A3 Ctrl + v A3 B : A1 B1 B A1 B1 Ctrl + c A5 D8 Ctrl + v ( 2 4 ) 3.39: A1 B1 A5 D C1 C2 C C2 [ ] C1 Ctrl + c C3 Ctrl + v
![C2 C3 [ ] C1 Ctrl + c 3.](/docs-images/91/105387177/images/31-2.jpg "42 C2 C3 Ctrl + v 3.")
31 3.40: C1 C C3 [ ] C1 C3 Ctrl + v C1 Ctrl + c C : C1 C C2 C3 [ ] C1 Ctrl + c 3.42 C2 C3 Ctrl + v 3.42: C1 C2 C3 4. C2 C3 [ ] C1 C3 C1 C2 C3 C1 10 =A1*B1
32 3.43: C1 C C2 C3 C2 C2 A2 B2 =A2*B2 0 ( B2 0 ) Excel C1 C1 [ESC] D3 =A1 B : A1 D C
33 3.45: C1 D3
34 3.13 5%(0.05) 3.46: =B2*C2 D2 D D3 D : D2 D3 D4 D2 D3 D D4 D4 2 (3) (90) =B4+C E2 5% 5% F2 5% 0.05
35 =D2*(1+F2)...( =D2 + D2*F E2 E3 E4 3.48: E2 E3 E4 E2 1 E3 E3 1 (280) (0) 280[=280*(1+0)] E3 F2 $ 1 F2 E2 =D2*(1+$F$2) E3 E4 3.49: E E2
36 E2 ( ) 3 4 F4 3.2: F4 F4 ( ) 1 $A$1 2 A$1 ( ) 3 $A1 ( ) 4 A Excel 3.50 = = ( ) 3.50: f x
37 3.51: 3.52:
38 : 3.54 E2 E4 E7 E9 3.54: E2 E4 E7 E E7 E9 E7 =D2*(1+F2) E2 3.55: E2 E4 E7 E F2 G3 E2
39 =D2*(1+G3) Excel 3.56: F2 G3 E : A1 E4 ( ) 3.58
40 . 3.58: A1 E4
41 37 4 Excel Sheet1. 4.1: 1. A1 A1 L1 ( ) 2. A A2 L2 ( ) A A A xlsx.xlsx Excel Sheet1
42 4.2: 4.2 (SUM ) 7 5 ( ) H3 = =C3+D3+E3+F3 ( H3 = C3 + ) Excel ( ) SUM 1. H3 =SUM(C3:G3) Enter C3:G3 =SUM( C3 G3 2. H3 H3 =SUM(C3:G3) (3.14 ) 3. C3 G3 (➀) (➁) H3 (➂)
43 4.3: C3 G3 H3, H3 H3 5 H3 H9 H3 H10 4. H3 H9 4.4: H3 H9 H3 H9
![4.3 (AVERAGE ) AVERAGE [ ]](/docs-images/91/105387177/images/44-0.jpg "=AVERAGE(C3:G3) 2 3 2 4.")
44 4.3 (AVERAGE ) AVERAGE [ ] =AVERAGE(C3:G3) I3 =AVER- AGE(C3:H3) 4.6 I3 Enter C3 G3 I4 I9 I3 4.5: I3 C3 H3 4.6: I3 C3 H3 C3 G3 [ ] 1 C10 =AVERAGE(C3:C9) 4.7
45 4.7: I3 I9 Ctrl C10 G : 4.9: :
46 4.5 (RANK ) RANK 4.11 J3 f x 4.11: J3 f x 4.12 RANK OK 4.12: RANK RANK =RANK (,, )
47 0 0 ( 1 ) 4.13: RANK 4.13 J3 =RANK(I3,I3:I9,0) J4 J9 J6 [ ] [ ] J6 ) [ ] I3:I9 J3 =RANK(I3,$I$3:$I$9,0) J3 4.15
48 4.14: J3 J4 J9 J6 4.15: J3
![4.6 (IF ) K3 60 K3 K9 IF =IF (,, ) [TRUE] [FALSE] 4.](/docs-images/91/105387177/images/49-0.jpg "17 K3 =IF(I3>=60,, ) ( I3 60 K3 ) 4.16 4.")
49 4.6 (IF ) K3 60 K3 K9 IF =IF (,, ) [TRUE] [FALSE] 4.17 K3 =IF(I3>=60,, ) ( I3 60 K3 ) : IF K4 K9 4.17
50 4.17: K3 K9 4.7 (VLOOKUP ) $ $ A E 5 L 0 60 E D C B 90 A VLOOKUP VLOOKUP =VLOOKUP (,,, [ ] ) [ ] 2 TRUE(1, ) FALSE(0) Excel 4.18 N2 O7 L3 =VLOOKUP(I3, $N$3:$O$7, 2, 1) I3 N3:O7 N 1 I O6 B L3
51 VLOOKUP 1. (N ) : N2 O7 RANK N3:O K4 K : K3 K9 4.20: L3 L9 5
52 : C3 G :
53 4.23: (VLOOKUP ) Sheet1 Sheet2 Sheet : B3 A5 K5 Sheet1 VLOOKUP A5 VLOOKUP 1. B3 ) 2. Sheet1!A3:L A5 =VLOOKUP(B3, Sheet1!A2:L9, 2, 0) (1) 4.26 #N/A A5
54 4.25: VLOOKUP 4.26: B3 A5
55 VLOOKUP A5 B3 Sheet1!A2:L9 2 B3 Sheet1!A2:L9 A5 =VLOOKUP($B$3, Sheet1!$A$2:$L$9, 2, 0) (2) B5 K : A5 B5 K5 (2) B5 K : A5 B5 K (MATCH ) (4.9) Sheet1!$A$2:$L$ MATCH MATCH =MATCH (,, [ ] )
![[ ] 0 1, -1 4.29 Sheet1!$A$2:$L$2 MATCH A7 =MATCH( A4, Sheet1!](/docs-images/91/105387177/images/56-0.jpg "$A$2:$L$2, 0) A7 2 4.29: A7 ( A4) Sheet1!")
56 [ ] 0 1, Sheet1!$A$2:$L$2 MATCH A7 =MATCH( A4, Sheet1!$A$2:$L$2, 0) A : A7 ( A4) Sheet1!$A$2:$L$2 A5 =VLOOKUP($B$3, Sheet1!$A$2:$L$9, MATCH( A4, Sheet1!$A$2$L$2, 0 ), 0) A5 B5 K5 4.30: A5 VLOOKUP MATCH 4.11 (IFERROR ) 4.31 #N/A IFERROR IFERROR
57 4.31: A5 VLOOKUP MATCH =IFERROR (, ) A5 =IFERROR ( VLOOKUP($B$3, Sheet1!$A$2:$L$9, MATCH( A4, Sheet1!$A$2:$L$2, 0 ), 0), ) VLOOKUP ) #N/A A5 VLOOKUP B5 =IFERROR (VLOOKUP($B$3, Sheet1!$A$2:$L$9, MATCH( B4, Sheet1!$A$2:$L$2, 0 ), 0), ) A5 ) K : A5 B5
58 Sheet1 A2 L A2 L9 4.33: A2 L9 : ( ) : =Sheet!$A$2:$L$9 A5 =IFERROR ( VLOOKUP($B$3,, MATCH( A4, Sheet1!$A$2$L$2, 0 ), 0), ) B5 ( A3 A9) 1. Sheet1 A3 A9 2. B3
59 4.34: A3 A = 4.36 B3 4.35: B3 4.36: B
60 4.37:
61 B2 G9 2-D 4.38: 4.39:
62 C D 4.40 / : 4.41:
63 ( ) 4.42: 4.43: 100
64 B2 G Ctrl B7 G D 4.44: 4.45: Ctrl 1. 2.
65 4.46: 4.47:
66 4.48: 4.49:
67 : : 1. A B3 1 F3
68 5.1 (RANDBETWEEN ) 4 1,2,3, Excel RANDBETWEEN =RANDBETWEEN (, ) 1 B4 =RANDBETWEEN( 1, B$1) $ 5.2 B4 F4 B4 F : B4 F13 B4 F B4 ( ) (COUNTIF ) 5.4 A16 F COUNTIF
69 5.3: B4 F13 5.4: A16 F24
70 =COUNTIF (, ) B18 =COUNTIF ( B4:B13, 1 ) 5.5 B18 5.5: B18 C18 B19 C18 C4:C13 1 B19 2 B5:B14 1 B4:B13 C4:C13 1 B4:B13 B5 B14 2 B$4:B$13 A18 A19 1,2,... A18 $A18 B18
71 =COUNTIF ( B$4:B$13, $A18 ) 5.6 B26 F26 5.6: B (COUNTIFS ) 4 COUNTIFS =COUNTIFS ( 1, 1, 2, 2,... ) COUNTIF :
72 K20 =COUNTIFS ( C4:C13, K19, F4:F13, J20 ) (1) C4 C13 1 ( K19) 5 F4 F13 1 ( J20) 5.8 f x 5.8: COUNTIFS (1) K21 L20 =COUNTIFS ( $C$4:$C$13, K$19, $F$4:$F$13, $J20 ) (2) : COUNTIFS
73 Excel A1 1 ˆ ˆ : 6.2:
74 6.3: :
75 6.5: ( 6.7) ( 6.10)
76 6.6: 6.7: S 6.8:
77 6.9: 6.10:
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
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]
h16ﾏｽﾀｰｾﾝﾀｰ報告書（神奈川県支部）
( / 36 16 /16 /16 /16 /100 [ ] % [ ] [ ] [ ] [ ][ ] 5 ➀ ➁ ➂ ➀ ➀ ➁ ➀ ➁ ➀ ➀ ➁ ➂ ➀ ➂ ➀ ➁ ➂ ➀ ➁ ➂ ➀ ➂ ➀ ➁ ➂ ➀ ➂ ➀ ➀ ➁ ➂ ➀ ➁ ➂ ➀ ➁ ➂ ➀ ➂ ➀ ➂ ➀ ➁ ➂ ➃ ➀ ➁ ➂ ➀ ➁ ➀
マリモの育て方
2 3 (2011 7 ) ( ) 1.2 4 ( 2.4.4 ) (URL: http://marimo-inner.seesaa.net/) 5 ) 6 3 1 8 1.1........................ 8 1.2.............. 10 2 12 2.1.................... 12 2.2............. 13 2.3........................
( 2 / 35
Office 1 / 35 ( 2 / 35 3 / 35 ( 4 / 35 ( 5 / 35 6 / 35 =SUMPRODUCT((C$3:C$42>=$A46)(C$3:C$42
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
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. []
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
橡マニュアル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
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
OFISTAR S3100取扱説明書
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 1 7 2 4 3 0 6 4 1 2 5 3 24 1 2 3 1 2 3 25 1 2 3 6 7 8 9 26 27 1 2 3 4 5 28 29 ABC 30 31 32 : : 33 1 8 2 1 3 1 2 3 4 34 1 2 35 1 1 36 1 2 3a 3b
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
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
dynabookガイド
1 2 3 4 5 6 7 8 9 10 11 14 15 16 17 18 19 20 21 22 23 SHIFT SHIFT 24 25 SHIFT SHIFT 26 27 28 29 D Y N A B O O K BACKSPACE DEL 30 31 32 33 34 35 36 37 ENTER SHIFT SHIFT 38 39 40 41 FN F8 FN F8 42 43 ENTER
情報科学概論 第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
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
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
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
( )
( ) 56 2006 1 28 ( ) 2006 1 180 2 180 3 180 1 4 180 2 5 180 3 6 180 4 7 ( ) 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 8 ( ) 9 P18 A A 10 P18 A A : = A : A 11 P18 A A : = A : A 12 P18 A F E A : = A : EF
PSCHG000.PS
a b c a ac bc ab bc a b c a c a b bc a b c a ac bc ab bc a b c a ac bc ab bc a b c a ac bc ab bc de df d d d d df d d d d d d d a a b c a b b a b c a b c b a a a a b a b a
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
オンラインマニュアル
1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 ENTER ENTER 20 F12 ENTER ENTER 21 FN F8 FN F8 22 FN F3 23 FN F4 24 25 26 27 28 FN F9 FN F9 FN F9 FN F9 FN F9 29 30 31 SHIFT SHIFT FN 32 33 FN FN ESC FN SPACE
1981 i ii ➀ ➁ 61
(autism) 1943 60 1981 i ii ➀ ➁ 61 DSM- 4 3 29 99 DSM- 62 1 2 3 4 4 vi 63 64 ix x xi 204 3 65 176 90 3 79 66 DSM- 82 67 68 ➀ ➁ ➂ 69 34 5 70 JR 71 i 1944 ii iii 28 72 iv 48 v ➀ vi PHP 39 vii 176 viii ➄ 77
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 )
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
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
資料32-2-2 深海掘削検討会報告書（平成24年3月 独立行政法人海洋研究開発機構 深海掘削検討会）
- i - - ii - - 1 - - 2 - - 3 - - 4 - - 5 - - 6 - - 7 - - 8 - - 9 - - 10 - - 11 - - 12 - - 13 - - 14 - - 15 - - 16 - - 17 - - 18 - - 19 - - 20 - - 21 - - 22 - - 23 - - 24 - - 25 - - 26 - ➀ ➁ ➂ ➃ ➄ - 27
TEL-L70/TEL-LW70
TEL-L70/TEL-LW70 Ni-Cd ➀ ➁ ➂ ➃ ➀ ➁ ➂ ➃ ' d d d d d d d d d d d b 4 4 1 2 3 4 5 6 7 8 9 0 d 1 8 4 1 2 3 4 5 6 1 2 3 4 5 6 7 8 9 0 7 8 9 0 ' ' 0 0 0 0 1 8 6 ' 1 2 3 4 5 6 7
(3) はがきの種類を選びます はがきの種類 を選択し 次へ (N) をク リックします (4) 縦書き / 横書き を指定 宛名を 縦書き にするか 横書き にする かを指定し 次へ (N) をクリックします (5) 書式を設定 宛名/ 差出人 のフォント 住所 の数字を漢数字で表示するかどうかを
Microsoft Office を使って はがき宛名面 を印刷するには Word で はがき宛 名面印刷ウィザード を使って 住所録用のファイル (Excel 使用 ) を作成し 宛名 面のフォーマット (Word 使用 ) を作成し 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.
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
Microsoft Word - ニュース更新システム（サイト用）.docx
1. ニュース更新システム 1.1. 記事情報管理 1.1.1. ニュース更新システムへのログイン ニュース更新システム用の ログイン ID とパスワードで ログインしてください 1 1.1.2. 新しい記事 1.1.2.1. 追加 新しく記事を追加します 記事情報管理画面 ここをクリック ( 次ページへ ) 2 1.1.2.2. 作成 記事内容を作成します 記事情報編集画面 ➀ ➁ ➂ ➃ 必須
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..
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 2 3 1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 % 23 24 25 26 27 28 29 30 31 32 33 34 35 4 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
橡統計担当者のためのエクセル表紙.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 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
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 SHIFT SHIFT 27 28 SHIFT SHIFT 29 30 31 32 D Y N A B O O K BACKSPACE DEL 33 34 35 36 37 38 39 40 ENTER SHIFT SHIFT 41 42 43 44 FN F8 FN
１
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
Word 2000 Standard
.1.1 [ ]-[ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [OK] [ ] 1 .1.2 [ ]-[ ] [ ] [ ] [ [ ] [ ][ ] [ ] [ ] [ / ] [OK] [ ] [ ] [ ] [ ] 2 [OK] [ ] [ ] .2.1 [ ]-[ ] [F5] [ ] [ ] [] [ ] [ ] [ ] [ ] 4 ..1 [ ]-[ ] 5 ..2
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
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
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
-2- Teen's
-1-1. 1-1. 1-2. -2- Teen's 1-3. A B / ATOK.2007 Shift CapsLock / ATOK.2007 ATOK A. B.ATOK / / -3- -4- Home Home Ctrl Tab Ctrl Tab Home -5- F4 ATOK -6- 2. SE -7- 2-1. SE SE SE OK -8- 2-2. OK -9- -10- Ctrl.
untitled
( ) 200133 3 3 3 3, 7 347 57 10 i ii iii -1- -2- -3- -4- 90011001700mm -5- 4.2 1991 73.5 44.4 7.4 10.5 10.5 7.4 W 3 H 2.25 H 2.25 7.4 51.8 140.6 88.8 268.8m 5,037.9m 2 2mm 16cm916cm 10.5 W 3 H 2.25 62.8
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
( ) HISC 2010 2 HISC 2010 3 HISC 2010 4 HISC 2010 5 HISC 2010 6 13 B14 4/29 29 C14 75000 4 30 10000 HISC 2010 7 A1 F22 A1 F1 D2 F21 HISC 2010 8 F2 D2 150,000 F2 150,000 2 2,150,000 2,000 152,000 F3 F2
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
1 3 4 4 6 7 8 9 11 11 12 CD 13 CD 14 15 18
Power Point 2007 1 3 4 4 6 7 8 9 11 11 12 CD 13 CD 14 15 18 8 15 1 bon_odori OK 2 3 4 OK 5 1 Windows Media Windows Video Microsoft Recorded TV Show Windows Media.asf.avi.mpg mpeg dvr-ms wmv 6 Word Excel
untitled
0. =. =. (999). 3(983). (980). (985). (966). 3. := :=. A A. A A. := := 4 5 A B A B A B. A = B A B A B B A. A B A B, A B, B. AP { A, P } = { : A, P } = { A P }. A = {0, }, A, {0, }, {0}, {}, A {0}, {}.
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
... 4... 5 (FA )... 6... 6 A FA... 7... 7. FA... 8.... 9.... 10. FA... 11 B. FA... 12 C 3 ()... 13 FA... 13 FA... 14... 14 FA... 14 ()... 15... 16...
... 4... 5 (FA )... 6... 6 A FA... 7... 7. FA... 8.... 9.... 10. FA... 11 B. FA... 12 C 3 ()... 13 FA... 13 FA... 14... 14 FA... 14 ()... 15... 16... 17 ()... 20... 20... 21... 22 D... 23 E ()... 23...
48 * *2
374-1- 17 2 1 1 B A C A C 48 *2 49-2- 2 176 176 *2 -3- B A A B B C A B A C 1 B C B C 2 B C 94 2 B C 3 1 6 2 8 1 177 C B C C C A D A A B A 7 B C C A 3 C A 187 187 C B 10 AC 187-4- 10 C C B B B B A B 2 BC
untitled
(N) FAX 256 20 10 20 10 Access X [ (N)] [OK] [ (A)] : ABC [ ] [ ] : [OK] (D) (V) / (H) [] : [Delete] Aa Ctrl CCtrl C (P) ... 0.423cm 0.423cm 0.423cm Ctrl C 0.423cm 0.556cm 0.423cm Ctrl V 0.556cm 0.423cm
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]
Plano-POS Ver1
1 Quick Version2.0.0 Chapter1 Chapter1-1 Chapter2 Chapter2-1 Quick--------------------------------------------------------------P.7 -----------------------------------------------------------------------P.11
はじめての帳票作成
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
140 120 100 80 60 40 20 0 115 107 102 99 95 97 95 97 98 100 64 72 37 60 50 53 50 36 32 18 H18 H19 H20 H21 H22 H23 H24 H25 H26 H27 1 100 () 80 60 40 20 0 1 19 16 10 11 6 8 9 5 10 35 76 83 73 68 46 44 H11
http://www1.iwate-ed.jp/ WindowsXP - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
untitled
Mail de ECO Professional ...1 EXCEL...2...3...4 EXCEL...6...7...8 EXCEL...9...10...11 EXCEL...12...13...14 EXCEL...16...21...23...25...33...34...37...38...40...44 EXCEL OK 1 EXCEL EXCEL MailDeEco No 1
CharacterSets.book Japanese
FRAMEMAKER 9 ADOBE i................................................. 2 1 2 1 2 3 4 ú þ ý! " # $ % & ( ) * +, -. / 0 1 2 3 4 5 5 6 7 8 9 : ; < = >? @ A B C D E F G H I J K L M N O P Q R S T U 6 V W X
=
2. 2.1 2.2 kuri@ice.uec.ac.jp ( 2007/10/30/16:46) 1 . 1. 1 + 2 = 5. 2. 180. 3. 3 3. 4.. 5.. 2 2.1 1.,,,,. 2., ( ) ( ).,,,, 3.,. 4.,,,. 3 1.,. 1. 1 + 2 = 5. (, ) 2. 180. (, ) 3. 3, 3. (, ) 4.. (, ) 5..
1009.\1.\4.ai
- 1 - E O O O O O O - 2 - E O O O - 3 - O N N N N N N N N N N N N N N N N N N N N N N N E e N N N N N N N N N N N N N N N N N N N N N N N D O O O - 4 - O O O O O O O O N N N N N N N N N N N N N N N N N
ワードプロセッシングについて
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)
Excel2000
Microsoft Excel 2000 Excel Excel ( )m...1...1...1 Shift...2 Shift...2...3...4...6...7...8...10...11...12...13...14...16...17...19...19...20 Excel B2 E5 E5 1/21 Shift B2 Shift E5 Shift B2 Shift Shift 2/21
<4D6963726F736F667420576F7264202D204850835483938376838B8379815B83578B6594BB2D834A836F815B82D082C88C60202E646F63>
例 題 で 学 ぶ Excel 統 計 入 門 第 2 版 サンプルページ この 本 の 定 価 判 型 などは, 以 下 の URL からご 覧 いただけます. http://www.morikita.co.jp/books/mid/084302 このサンプルページの 内 容 は, 第 2 版 発 行 当 時 のものです. i 2 9 2 Web 2 Excel Excel Excel 11 Excel
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
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...
FileMaker Pro 9 Tutorial
FileMaker Pro 10 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
活用編
1 2 3 FN F6 FN F6 FN F7 FN F7 6 7 8 9 10 11 12 13 FN F5 FN F5 FN F5 FN ENTER 14 15 FN 3 FN 4 FN 3 FN 4 FN 3 FN 4 16 17 18 19 FN 3 FN 4 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
橡Microsoft Word
Microsoft Word (F) (X) 6 Word OK OK Enter 7 CenturyComic Sans MSCourier NewTimes New Roman 8 HG 13 5 15 MS 16pt 150% HG -PRO 9 1 Alt 1 Tab Alt 11 1532 12.235 233 411.26 16489 1356.2 12 13 6 1 1. 13 1,500
スライド 1
Power Point 2003 ILC HELPDESK 1 1 1 a) 1 b) 3 a) b b-1) Step1 Step2 Step3 F4 PowerPoint b-2) Step1 Step2 Step3 Step4 OK Step5 I c) c-1) Step1 Step2 5 7 7 Step3 c-2) Step1 Step2 9 9 Step3 8 2 5
1 (1) vs. (2) (2) (a)(c) (a) (b) (c) 31 2 (a) (b) (c) LENCHAR
() 601 1 () 265 OK 36.11.16 20 604 266 601 30.4.5 (1) 91621 3037 (2) 20-12.2 20-13 (3) ex. 2540-64 - LENCHAR 1 (1) vs. (2) (2) 605 50.2.13 41.4.27 10 10 40.3.17 (a)(c) 2 1 10 (a) (b) (c) 31 2 (a) (b) (c)
Keynote '08 ユーザーズガイド
Keynote 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 Apple Apple AppleWorks
(
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..............
1 (1) (2)
1 2 (1) (2) (3) 3-78 - 1 (1) (2) - 79 - i) ii) iii) (3) (4) (5) (6) - 80 - (7) (8) (9) (10) 2 (1) (2) (3) (4) i) - 81 - ii) (a) (b) 3 (1) (2) - 82 - - 83 - - 84 - - 85 - - 86 - (1) (2) (3) (4) (5) (6)
- 2 -
- 2 - - 3 - (1) (2) (3) (1) - 4 - ~ - 5 - (2) - 6 - (1) (1) - 7 - - 8 - (i) (ii) (iii) (ii) (iii) (ii) 10 - 9 - (3) - 10 - (3) - 11 - - 12 - (1) - 13 - - 14 - (2) - 15 - - 16 - (3) - 17 - - 18 - (4) -
2 1980 8 4 4 4 4 4 3 4 2 4 4 2 4 6 0 0 6 4 2 4 1 2 2 1 4 4 4 2 3 3 3 4 3 4 4 4 4 2 5 5 2 4 4 4 0 3 3 0 9 10 10 9 1 1
1 1979 6 24 3 4 4 4 4 3 4 4 2 3 4 4 6 0 0 6 2 4 4 4 3 0 0 3 3 3 4 3 2 4 3? 4 3 4 3 4 4 4 4 3 3 4 4 4 4 2 1 1 2 15 4 4 15 0 1 2 1980 8 4 4 4 4 4 3 4 2 4 4 2 4 6 0 0 6 4 2 4 1 2 2 1 4 4 4 2 3 3 3 4 3 4 4
20 15 14.6 15.3 14.9 15.7 16.0 15.7 13.4 14.5 13.7 14.2 10 10 13 16 19 22 1 70,000 60,000 50,000 40,000 30,000 20,000 10,000 0 2,500 59,862 56,384 2,000 42,662 44,211 40,639 37,323 1,500 33,408 34,472
I? 3 1 3 1.1?................................. 3 1.2?............................... 3 1.3!................................... 3 2 4 2.1........................................ 4 2.2.......................................
立ち読みページ
1 Word 1-1 33 1-2 45 1-3 54 1-4 Office Word 2007 66 1 1-1 1-1-1 33 Word FAX 1 1 2 1 Office Windows 7 Windows Vista Windows XP 3 4 5 6 34 2 Office Microsoft Office Online 35 1-1-2 1 2 3 4 5 6 2 1 1 36 37
Microsoft Word - 204.1MSExcel2013
4.1 MS-Excel 2013 の 起 動 と 終 了 第 4 章 表 計 算 1.MS-Excel2013 の 起 動 (1)マウスの 左 ボタンでスタートボタンをクリックします (2)[すべてのプログラム] [Microsoft Office] [Microsoft Excel]の 順 にマウスをクリックすると MS-Excel 2013の 初 期 画 面 ( 図 4-1)が 開 かれます
20090503-04t-Word
Word (1) Word Word Word -1 Word Word Word Word Word -1 Word -2-2 (2) Word -3 Word 1 -3-1 2 3-1 Web Web SmartArt HTML (3) Command Z Command Word (4) Control J K L (5) USB USB USB TrueCrypt USB Word Word