Transcription of 表計算ソフト（Excel）基本操作
1 excel excel .. 2 .. 3 .. 4 .. 5 .. 5 .. 6 .. 10 .. 11 Appendix .. 14 excel [ excel ] 65536 256 1 65536 A IV Sheet1 Sheet3 excel !
2 ! / Delete Enter Enter excel excel
3 Or excel Ctrl excel [ ] [ ] [ ] (4/4)
4 [ ] [ ] [ ] excel excel [ ] [ ] [ ] [ ] [ ] [ ] " " [ ] [ ] [ ] [ ] [ ] [ ] 0 [ ] 1200 [ ] 300 3-D 2003 2003 [ ] [ ] [ ] [ ] [ ] 100 Ctrl 3-D Ctrl 3-D [3-D ] [ ] [ ] [ ] [ ] [ ]
5 [ ] [ ] [ ] [ ] [ ] excel Ctrl 3-D 3-D PC PC 100 100 100 300 200 100 100 400 130 140 180 450 140 160 280 580 80 100 90 270 80 180 170 430 30 40 80 150 40 120 80 240 340 380 450 1,170 460 560 630 1.
6 650 PC PC 300 100 100 500 400 350 200 950 100 150 250 500 40 150 80 270 840 750 630 2,220 Shift Enter excel B H22 2004 1 B H22 2004 1
7 10000 excel [ ] [ ] [ ] B H22 [ ] $B$2:$H$22 [ ] [ ] [ ] -----> [ ] [ ] -----> [ ] [ ] ---> [ ]
8 excel DSUM DAVERAGE DCOUNT DSUM(B2 H22,7,B26 H27 DAVERAGE(B2 H22,7,B26 H27 DCOUNT(B2 H22,7,B26 H27 excel Appendix Enter excel )))
9 Ctrl F4 800 8000 Enter excel COUNT COUNT (,)
10 12 Enter 2 12 G5 G16 F4 $ RANK G5 $G$5 $G$16 RANK ,1 RANK G5,$G$5 $G$16,1 excel (,) Enter VLOOKUP(D5,G4 I12,3,1 FALSE 10 10)
