Page 2 - E-MODUL NELSY YULIA SYAFITRI

1 Microsoft Exel

DAFTAR ISI

DAFTAR ISI ...................................................................................................................................................................... 1
PETUNJUK PENGGUNAAN MODUL ........................................................................................................................... 2
A. Petunjuk Umum ...................................................................................................................................................... 2

B. Petunjuk Khusus ..................................................................................................................................................... 2
A. PENGENALAN MICROSOFT EXCEL ................................................................................................................... 4
B. MENGGUNAKAN RUMUS DAN FUNGSI EXCEL ............................................................................................ 9
1. RUMUS ................................................................................................................................................................. 9
2. FUNCTION ......................................................................................................................................................... 10

C. MENGATUR TAMPILAN MS EXCEL ................................................................................................................ 15
D. MEMODIFIKASI DATA DALAM CELL PADA MS EXCEL ........................................................................... 19
a. Menyalin Data (Copy) ........................................................................................................................................ 19
b. Memindahkan Data (Cut) .................................................................................................................................... 19
c. Menyisipkan Baris/Kolom (Insert) ...................................................................................................................... 20

d. Menghapus Baris, Kolom dan Sel (Delete) ......................................................................................................... 20
e. Mengetengahkan Judul Tabel (Merge & Center) ................................................................................................. 21
f. Memberi Garis Pembatas (Border) ...................................................................................................................... 21
E. MEMBUAT TABEL DAN GRAFIK DENGAN MS EXCEL ................................................................................ 22
1. Membuat Tabel .................................................................................................................................................... 22

2. Membuat Grafik ................................................................................................................................................... 23
F. MENCETAK LEMBAR KERJA MS EXCEL ....................................................................................................... 26
SUMBER ......................................................................................................................................................................... 28

1 DAFTAR ISI | Nelsy Yulia Syafitri 21053167