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 Web "" http://office.microsoft.com/ja-jp/excel/ha101491511041.aspx
Microsoft Office Excel 2007 3 1620 1 150 1.1 5 1.2 15 1.3 20 1.4 15 1.5 25 1.6 20 1.7 35 15 2 180 2.1 5 2.2 20 2.3 30 2.4 30 2.5 45 2.7 35 15 3 90 3.1 5 3.2 30 3.3 SmartArt 15 3.4 15 3.5 10 15 4 160 4.1 5 4.2 20 4.3 30 4.4 45 4.5 25 4.6 20 15 5 160 5.1 5 5.2 30 5.3 30
Microsoft Office Excel 2007 5.4 5.5 6 6.1 6.2 6.3 7 7.1 7.2 7.3 7.4 7.5 7.6 7.7 7.8 7.9 Excel 30 50 15 110 5 60 30 15 140 5 20 10 10 20 10 15 15 10 15 4
Microsoft Office Excel 2007 1 1.1p.2 1.2 1.2.1 p.54 Ctrl p.55 p.6 1 1.2.2p.8 p.82 1.3 p.9 2 Ctrl 2 p.121 " " 5
Microsoft Office Excel 2007 p.122 1.4p.13 5.3.3 p.15 5 "..." 1 Enter p.163 Microsoft Office Excel 2007 p.60 p.17 1.5 p.19 1 p.19 2 SUM p.20 3 p.20 4 D6 SUM(B6:C6) p.20 5 D6 D11 6
Microsoft Office Excel 2007 "" "" "" Esc p.21 Microsoft Office OK Microsoft Office Excel Office 1.6 p.233-d 2 3-D p.243-d 4 SUM 1 1, 2 SUMEnter p.243-d 5 "" "" " 1 " p.243-d 6 1.7 p.252 7
Microsoft Office Excel 2007 p.264 p.28 8 3 p.2810 22 p.29 165 5.4 "0" p.30 p.31 2 2.1p.36 2.2p.37 Macintosh Excel 1904 1904 1 2 1 9999 12 31 p.38today 2 8
Microsoft Office Excel 2007 p.38today 3 p.39today 4 TODAY =TODAY() Excel 2007 "" 2.3p.41 p.41round ROUND ROUNDDOWN ROUNDUP ROUNDDOWN ROUNDUP 44 ROUNDDOWN ROUNDUP p.43round 2 "*5%" "*0.05" 1 p.44round 4 "0" p.44rounddown ROUNDUP ROUND ROUNDDOWN ROUNDUP p.45 Office Excel 2.4p.46 p.46if IF p.47 IF 1 9
Microsoft Office Excel 2007 p.47 IF 2 p.49 IF 4 H8 =IF(G8="",F8,ROUND(F8*(1-G8),0)) H15 G8 G15 G8 10% " 10% p.502 2.5p.51 p.51vlookup ID p.52vlookup 1 p.52vlookup 2 VLOOKUP "" p.54vlookup 4 p.54vlookup 5 C8 2 2 p.55 / Office Excel / p.56 ID 2 ID "B100" / 2.6 p.58 10
Microsoft Office Excel 2007 64 p.59if VLOOKUP 1 C8 p.60if VLOOKUP 4 p.61if VLOOKUP 5 VLOOKUP VLOOKUP p.64 ID 2 "" p.64 C8 p.65 " " 3.5 p.66 RANK 0 0 p.67 3 3.1p.74 3.2 3.2.1 p.76 3 11
Microsoft Office Excel 2007 0 100 0 100 8,192 20 20 = OK 3.2.2 p.771 3 0 100 12
Microsoft Office Excel 2007 0 100 8,192 20 20 = OK p.84 / 3.3 SmartArt p.85 SmartArt SmartArt 1 3 """" "" 2 4 p.87smartart 2 13
Microsoft Office Excel 2007 SmartArt SmartArt Excel SmartArt p.88smartart 4 SmartArt SmartArt p.89smartart 6 SmartArt SmartArt p.91smartart 2 SmartArt SmartArt SmartArt 3-D SmartArt SmartArt 3.4 p.943 3 =E3+3 p.944 "" "" "" 3 "" "" "" "" "" OKOK p.955 p.95 1 Ctrl + ; p.96 4 14
Microsoft Office Excel 2007 OK OK Excel 255 3.5 p.983 p.102 4 4.1p.108 4.2 p.111 4 Ctrl p.111 5 Shift p.1121 Excel 2007 p.1132 15
Microsoft Office Excel 2007 p.1133 p.114 "3 " "2 " "1 " "1 " "2 " "3 " 4.3 p.115 p.1171 1 p.1202 4.4 p.121 p.112 1 p.124 3 p.1252 p.1284 p.1295 16
Microsoft Office Excel 2007 4.5 p.130 Excel 2007 "" p.1313 ".crtx" Windows Vista "C: Users <> AppData Roaming Microsoft Templates Charts" p.1323 4.6 p.135 p.1361 p.1374 p.139 5 5.1p.144 5.2 5.2.1 p.146 " " 5.2.2p.147 Excel 2003 "" Excel 2007 "" 154 p.149 2 17
Microsoft Office Excel 2007 p.149 3 p.152 3 SUBTOTAL SUBTOTAL Excel 5.3 p.156 Excel 2007 64 5.3.1 1 p.1571 "" Ctrl + 1 147 p.158 2 3 5.3.2 p.1592 OK 5.3.3 p.1624 18
Microsoft Office Excel 2007 p.1625 Excel 2007 p.1637 p.164 5.4 p.165 p.1663 "No."" " "" " " p.1674 p.1682 p.1695 19
Microsoft Office Excel 2007 p.1691 "" "" p.1692 p.1703 2 p.1704 "4" p.1716 1 5.5 5.5.1 p.173 Excel 2007 p.174 p.1762 p.176 1 p.178 10 2 20
Microsoft Office Excel 2007 p.178 10 3 " " p.1791 3 1 Excel 2007 1 3 p.1801 p.1802 149 p.1803 AND p.1814 p.1815 p.183 181 5.5.2 p.183 p.1851 p.1852 21
Microsoft Office Excel 2007 p.1863 A3 Enter p.1864 p.1871 "2LDK" p.1885 184 p.190 "<=100000" "<=150000" p.192 " " =E9>AVERAGE($E$9:$E$158) TRUE p.195 6 6.1p.202 6.2 p.203 6.2.1 p.206 2 1 p.206 3 22
Microsoft Office Excel 2007 Excel Excel 2007 / p.208 5 166 "/" Enter 6.2.2 p.210 1 A5 p.210 2 p.210 3 3 p.2121 23
Microsoft Office Excel 2007 /A3 p.2122 p.2134 4 p.2141 p.217 1 p.218 4 p.219 1 "" p.221 3 p.222 3 1 6 E8 p.223 5 6.2.3 p.224 p.225 2 1 24
Microsoft Office Excel 2007 p.227 1 p.228 p.229 6.3 p.230 p.2323 Excel 2007 " " p.235 2 p.237 7 7.1p.242 7.2 p.243 "" 25
Microsoft Office Excel 2007 p.244 p.246 Visual Basic Editor 7.3p.247 Visual Basic Editor 7.4p.248 p.2482 7.7 7.5 p.249 p.252 2 Ctrl + Ctrl + Shift + Excel 7.6 p.2542 Alt F8 7.7 p.2591 / 7.8 p.2622 p.2634 26
Microsoft Office Excel 2007 7.9 Excel p.265excel 1 Excel.xlsx Excel p.267 OK p.268 p.271 291 27
1. Office Excel2007 1-1 2. "" Ctrl "" "" Ctrl 3. "(2)" Enter 4. "" 3 B5 D8 Del 5. "" Shift "" A2 14 3 "" "" "" "" A2 6. "" B5 D8 SUM "" B5 Shift " " SUM 7. Office Excel2007 "Excel2007 28
Microsoft Office Excel 2007 " "1-1 " "1-1 " 1. Office Excel2007 "Excel2007 " Excel2007 1-2 2. "" A5 A7 Office Excel Excel "$A$5:$A$7" A5 A7 OK OKExcel A5 A7 4. "" E5 E7 "" B5 "" E5 E7 "" C5 C7 "" E5 E7 "" D5 D7 5. Office Excel2007 "Excel2007 " "1-2 " "1-2 " 3. "" A5 29
Microsoft Office Excel 2007 1. Office Excel2007 "Excel2007 " Excel2007 1-3 2. "" A3 "" "" A4 E13 "!$A$4:$E$13" "" B8 F14"" D11 H17 OK 3. Office Excel2007 "Excel2007 " "1-3 " "1-3 " 1. Office Excel2007 "Excel2007 " Excel2007 2-1 2. "" F5 / ROUND E5 1 OK 3. F5 F8 30
Microsoft Office Excel 2007 4. Office Excel2007 "Excel2007 " "2-1 " 1. "" 2. E2 / TODAY OK 1. "" B13 2. E4 IF D4 "D4" >=1000 "" OK 3. E4 E15 4. 3. / VLOOKUP A13 G13 I20 F4 2 FALSE OK 4. A13 3 Enter B13 "" 5. B13 Del 6. B13 IF 31
Microsoft Office Excel 2007 A13 "A13" ="" "" VLOOKUP A13 G13 I20 F4 2 FALSE OK 7. B13 B20 8. C13 IF A13 "A13" ="" "" VLOOKUP A13 G13 I20 F4 3 FALSE OK 9. C13 C20 10. A13 3 D13 3 A14 1 D14 1 A15 8 D15 2 A16 2 D16 1 11. "2-1 " 1. Office Excel2007 "Excel2007 " Excel2007 3-1 2. "" B4 G10 32
Microsoft Office Excel 2007 3. B4 G10 3 4. B G B C 5. Office Excel2007 "Excel2007 " "3-1 " 1. "2" 2. B4 G10 500000 OK 3. B4 G10 2000000 2 4 OK OK 4. B G B C 5. "2" 33
Microsoft Office Excel 2007 SmartArt SmartArt 2 OK SmartArt 1-1 12 SmartArt 6. SmartArt 1 2 4 2 3 4 7. SmartArt A13 SmartArt 8. SmartArt 9. 1. "" 2. B4 OK 3. B4 4. B6 34
Microsoft Office Excel 2007 =B5+2 "" 2 OK 5. B5 B6 4 6. B6 2 8. "3-1 " 1. Office Excel2007 "Excel2007 " Excel2007 4-1 2. "" A4 D9 2-D 3. 7. A6 2 A6 A11 G29 4. G4 G9 35
Microsoft Office Excel 2007 Esc 5. "" "" OK "" 6. "" 2 / 7. 13 2 5 8. "" 4 9. "" 1 2 3 10. 36
Microsoft Office Excel 2007 11. 12. Office Excel2007 "Excel2007 " "4-1 " 2. "" A4 D9 Ctrl G4 G9 OK 3. A11 G29 1. "" "Microsoft Templates Charts" " " 4. E10 5. 6. 37
Microsoft Office Excel 2007-1 1 2 OK 7. 10 4 8. "4-1 " 1. Office Excel2007 "Excel2007 " Excel2007 5-1 1 2. "" A1 F122 "=$A$1:$F$122" 3. 4. 5. "" 123 6. 7. 38
Microsoft Office Excel 2007? 8. Office Excel2007 "Excel2007 " "5-1 1" " " OK 3. 1 A F 1. "" 1 "" 2. 1 A F "" " " "" 2 OK 4. 1 A F 39
Microsoft Office Excel 2007 "" OK 5. 2 6. 91 7. 3 8. A1 F122 "" OK 10. "5-1 1" 1. Office Excel2007 "Excel2007 " Excel2007 5-3 2 2. "" 1 A F 3. "" OK 23 9. 3 4. "" 40
Microsoft Office Excel 2007 "" 5. "" AND 1000000 "" OK 500,000 1,000,000 6 8. 10 OK 10 15 6. "" "" "" OK 44 7. "" 500000 "" 9. 1 5 A6 F6 A1 Esc B2 C3 6 "$A$6:$F$127" 41
Microsoft Office Excel 2007 1 5 A1 F3 "!$A$1:$F$3" OK """ " 43 2" "5-3 2" 10. A2 F3 Del B2 C2 B3 C3 6 "$A$6:$F$127" "!$A$1:$F$3" OK "" " """ "" 8 11. Office Excel2007 "Excel2007 " "5-3 1. Office Excel2007 "Excel2007 " Excel2007 6-1 2. "" 1 / "!$A$1:$F$111" OK "Sheet1" 42
Microsoft Office Excel 2007 3. A5 OK 4. A3 / "/" OK A3 OK 5. A3 / 6. "" B1 OK " " OK 7. "" 43
Microsoft Office Excel 2007 OK "" "" "" 8. "Sheet1" H9 Sheet5 A B A, OK OK 11. 16 9. "Sheet1" B9 "45600" "" E4 1500 Enter "Sheet1" B9 "45600" B9 "5715200" 10. " Sheet1" A3 12. Office Excel2007 "Excel2007 " "6-1 " "" 1. 44
Microsoft Office Excel 2007 OK 2. A15 3. 4. "" OK 5. "" OK "" " " 6. "6-1 " 1. Office Excel2007 "Excel2007 " Excel2007 7-1 2. A12 A16 Del A12 3. 4. Office Excel Excel Excel OK 5. "Macro1" 45
Microsoft Office Excel 2007 " " OK A12 A16 Del A12 6. 7. "Macro1" A12 A13 A12 2. "Macro1" D12 D16 3. B20 B21 B20 B21 Macro1 OK 1. "Macro1" Microsoft Visual Basic "Range "A12:A16".Select" 16 "),D12:D16 Microsoft Visual Basic 4. "1" 5. A12 200 Enter D12 25 Enter 46
Microsoft Office Excel 2007 6. A12 7. Office Excel Excel2007 "Excel2007 " " Excel2007 " "7-1 " "Excel " "7-1 " 1. Office Excel2007 "Excel2007 " Excel2007 1 2. "" Ctrl " " " " Ctrl "(2)" 2 Enter 3. B4 D6 Del 4. A1 "" 2 Enter 5. " 2 " 6. "" B3 D3 Office Excel Excel "$B$3:$D$3" B3 D3 47
Microsoft Office Excel 2007 OK OKExcel 7. "" B3 D3 B4 "" E4 E6 " " C4 C6 "" E4 E6 " " D4 D6 8. "" Shift" 2 " A1 14 5 A1 E1 "" "" "" " " " 2 " A1 9. "" E4 E6 " " 10. " 2 " B4 D6 SUM "" B4 Shift " " SUM 11. Office Excel2007 "Excel2007 " "" 1. Office 48
Microsoft Office Excel 2007 Excel2007 "Excel2007 " Excel2007 2 2. E2 / TODAY OK 3. B15 IF A15 "A15" ="" "" VLOOKUP A15 G15 I20 F4 2 FALSE OK 4. B15 B21 5. D15 IF A15 "A15" ="" "" VLOOKUP A15 G15 I20 F4 3 FALSE OK 6. D15 D21 7. E15 IF A15 "A15" 49
Microsoft Office Excel 2007 ="" "" C15*D15 OK 8. E15 E21 9. 10. Office Excel2007 "Excel2007 " "" 2. B4 D8 3. B4 D8 3 4. H4 J8 1000000 OK 1. Office Excel2007 "Excel2007 " Excel2007 3 2 5. H4 J8 20000005000000 50
Microsoft Office Excel 2007 2 4 OK OK 6. SmartArt SmartArt 2 1 OK 7. SmartArt 1 2 6 2 3 4 8 9 " 2 " 5 6 8. SmartArt A11 SmartArt 9. SmartArt SmartArt 6-6 63 SmartArt 10. Office Excel2007 "Excel2007 " 2 1. Office 51
Microsoft Office Excel 2007 Excel2007 "Excel2007 " Excel2007 4 2. " 1 " A2 E5 2-D 3. A9 F28 4. A7 E7 Esc 5. "" "" OK "" 2 / "" 2 6. 29 4 4 7. "" 52
Microsoft Office Excel 2007 3 "" 8. 4 1 9. " 1 " "Microsoft Templates Charts" " " 10. " 2 " A2 E5 Ctrl A7 E7 OK 11. A9 F28 12. C9 10% 53
Microsoft Office Excel 2007 10-6 1 1 13. Office Excel2007 "Excel2007 " "" 1. Office Excel2007 "Excel2007 " Excel2007 5 2. "4 6 " A3 G86 "=$A$3:$G$86" OK A3 G86 3. 18 4. "" 87 "" 87 "" "" 54
Microsoft Office Excel 2007 "" 5.? " " "" 2 OK 8. 6. 3 A F "4 6 " 1 "" 7. 3 A G OK "" " " "" 9. 2 55
Microsoft Office Excel 2007 10. A3 G86 Esc A3 G3 14. 11. "4 6 " 3 A G "" OK "" 2007 5 "" "" 2007 5 8 12. "7 9 " 3 7 5 13. A8 G8 A3 C4 G4 C5 G5 8 "$A$8:$G$91" 3 5 A3 G5 " '7 9 '!$A$3:$G$5 " OK "" "" 12 15. Office Excel2007 "Excel2007 " 56
Microsoft Office Excel 2007 " " 1. Office Excel2007 "Excel2007 " Excel2007 6 2. 3 /" ' '!$A$3:$G$86 " OK Sheet1 3. 4. A5 OK 5. 6. A3 / "/" 57
Microsoft Office Excel 2007 OK 7. A3 OK 8. "Sheet1" 5 C6 Sheet2 B C B B 9. "Sheet1" B7 "411600" "" E5 100 Enter "Sheet1" B7 "411600" B7 "1293600" 10. A1 B1 B1 " " OK "" 11. "" OK """" "" 12. "Sheet1" A3 / 58
Microsoft Office Excel 2007, OK OK 13. 7 14. "Sheet1" "" OK 15. A12 E29 16. Office Excel2007 "Excel2007 " " " 59
BP Microsoft Office Excel 2007 2007 10 15 BP BP 108-8646 1-17-3 FAX 03 5421-9137 nsp@nikkeibp.co.jp http://ec.nikkeibp.co.jp/nsp/ 207 BP Microsoft Microsoft Press Visual Basic Windows Windows Vista Microsoft Corporation