Page 4 - Buku MS Excell
P. 4
E. Border and Shading ……………………………………. ……….. 24
F. Memutar Teks (Orientation) …………………………………….. 26
BAB 6 MENGCOPY, MENGHAPUS, DAN MEMINDAHKAN DATA
A. Perintah-perintah Copy, Cut, and Paste…………………………… 28
B. Meng-copy Data ………………………………………………….. 29
C. Menghapus Data………………………………. ………………… 29
D. Memindahkan (Move) Data…………………………………… …. 29
BAB 7 MEMASUKKAN DATA SECARA OTOMATIS ………………….. 30
BAB 8 PERHITUNGAN (OPERATOR ARITMATIKA)
A. Operator Arithmetical ……………………………………………. 32
B. Perhitungan ……………………………………………………….. 32
C. Menghitung Total ………………………………………………… 33
D. Latihan ……………………………………………………………. 34
BAB 9 MENGCOPY RUMUS
A. Mengcopy Cell Relative ………………………………………….. 35
B. Mengcopy Cell Absolute …………………………………………. 35
C. Mengcopy Cell Semi Absolute …………………………………… 36
BAB 10 FORMAT ANGKA
A. Format Decimal Number …………………………………………. 38
B. Format Currency (Mata Uang) ……………………………………. 39
C. Format Time, Date, and Accounting ……………………………… 40
BAB 11 FUNGSI MATEMATIKA DANFUNGSI STATISTIK ……………. 42
BAB 12 FUNGSI-FUNGSI LOGIKA (LOGICAL)
A. Operator Logical …………………………………………………. 52
B. Function IF ……………………………………………………….. 52
C. Function OR ………………………………………………………. 54
D. Function AND ……………………………………………………. 56
E. Function NOT ……………………………………………………. 56
BAB 13 FUNGSI-FUNGSI LOOKUP AND REFERENCE
A. Vertical Lookup (Vlookup) ………………………………………. 57
B. Horizontal Lookup (HLookup)……………………………………. 58
BAB 14 FUNGSI-FUNGSI TEXT …………………………………………… 60
BAB 15 MENGURUTKAN DATA…………………………………………… 64
BAB 16 GRAPHIC …………………………………………………………… 66
Panduan MS-Word 2000/2003 iii Edi Supriyanto, At Taqwa.Com
