Excel XLSX | Diposting 27 Jan 2022 | 3 thn lalu
Authentication
digital resources
326x Tipe XLSX Ukuran file 0.04 MB
Sheet 1: Soal 1
| Soal 1.A | ||||||||
| Lengkapilah tabel dibawah ini sesuai dengan ketentuan soal yang diminta! | ||||||||
| Daftar NamaMahasiswa | ||||||||
| Diploma III Fakultas Pertanian | ||||||||
| Nama | Tahun | Kode | No.urut | Nama | Jumlah | |||
| No. | No. BP | Mahasiswa | Masuk | Jurusan | Mahasiswa | Depan | Karakter | |
| 1 | 16051001 | Lili Mawarsari | ? | ? | ? | ? | ? | |
| 2 | 16051004 | Anto Sugianto | ? | ? | ? | ? | ? | |
| 3 | 16053020 | BJ Harman | ? | ? | ? | ? | ? | |
| 4 | 16054001 | Melati Sukma | ? | ? | ? | ? | ? | |
| 5 | 15051001 | Dewi Saputra | ? | ? | ? | ? | ? | |
| Soal 1.B | ||||||||
| Daftar Nama Mahasiswa | ||||||||
| Semester Pendek TA 2016/2017 | ||||||||
| No. | No. BP | Nama | Kode | Jenis | Nama | Jumlah | ||
| Mahasiswa | Mata Kuliah | Mata Kuliah | Mata Kuliah | SKS | ||||
| 1 | 01052001 | Budi Santoso | MDU102 | ? | ? | 2 | ||
| 2 | 01052002 | Indra Laksmana | MKW404 | ? | ? | 4 | ||
| 3 | 01052003 | Arale | MKK203 | ? | ? | 3 | ||
| 4 | 00052004 | Sovialajuba | MKP492 | ? | ? | 2 | ||
| 5 | 01052005 | Ariel Tatum | MDU102 | ? | ? | 2 | ||
| 6 | 00052006 | Aura Kasih | MKP492 | ? | ? | 2 | ||
| 7 | 01052007 | Citra Kirana | MKK203 | ? | ? | 3 | ||
| 8 | 00052008 | Dahlia Poland | MKW404 | ? | ? | 4 | ||
| 9 | 00052009 | Dewi Perssik | MKP492 | ? | ? | 2 | ||
| 10 | 01052010 | Julia Perez | MDU102 | ? | ? | 2 | ||
| Fungsi Logika IF | |||||||||
| Lengkapilah tabel dibawah ini! | |||||||||
| DAFTAR PENJUALAN BARANG | |||||||||
| PT. HARAPAN BARU ELEKTRONIK SARI LAMAK | |||||||||
| NO | NAMA | TGL. | KODE | JNS.BRG | HRG.SAT | JML | HRG. | DISKON | HRG. |
| PEMBELIAAN | BARANG | 15% | DIBAYAR | ||||||
| 1 | AMIR SANTOSO | 15 Agustus 1999 | 1 | ? | ? | 4 | ? | ? | ? |
| 2 | ANDRI HERMAWAN | 01 Agustus 1999 | 4 | ? | ? | 7 | ? | ? | ? |
| 3 | ARIF RAKHMAN | 05 Agustus 1999 | 5 | ? | ? | 5 | ? | ? | ? |
| 4 | ARIANTOKO | 20 Agustus 1999 | 2 | ? | ? | 4 | ? | ? | ? |
| 5 | CHICHI | 21 Agustus 1999 | 3 | ? | ? | 2 | ? | ? | ? |
| 6 | ERIKA | 17 Agustus 1999 | 4 | ? | ? | 5 | ? | ? | ? |
| 7 | HAPSARIE | 14 Agustus 1999 | 1 | ? | ? | 4 | ? | ? | ? |
| 8 | LEONARD | 25 Agustus 1999 | 5 | ? | ? | 5 | ? | ? | ? |
| 9 | ZENI | 27 Agustus 1999 | 4 | ? | ? | 1 | ? | ? | ? |
| 10 | ZUHRO WARDI | 03 September 1999 | 3 | ? | ? | 2 | ? | ? | ? |
| T O T A L | ? | ? | ? | ? | ? | ||||
| Jumlah Barang Yang Terjual | |||||||||
| AC | ? | Unit | |||||||
| DVD Player | ? | Unit | |||||||
| TV | ? | Unit | |||||||
| Dispenser | ? | Unit | |||||||
| Sabilizer | ? | Unit | |||||||
| Jumlah | = ……………… | Unit | |||||||
| Buat dan Lengkapi kolom kosong berikut ! | |||||||||||||
| Tanggal | Nama | Biaya | Denda | Total | |||||||||
| Pinjam | Peminjam | Film | Film | Utama | Audio | Film | CD | Kembali | Pinjam | per Hari | Sewa | Bayar | |
| 6-Dec-00 | Fadli | F04-DR-ST | Home Alone 2 | Macauly C. | ? | ? | 2 | 9-Dec-00 | ? | ? | ? | ? | ? |
| 7-Dec-00 | Rafki | F01-AC-MN | Double Impact | Van Damme | ? | ? | 3 | 9-Dec-00 | ? | ? | ? | ? | ? |
| 7-Dec-00 | Rafli | F02-KM-MN | BEAN | Mr.Bean | ? | ? | 2 | 13-Dec-00 | ? | ? | ? | ? | ? |
| 7-Dec-00 | Lucky | F09-KR-ST | Caspher | Syaithon | ? | ? | 2 | 10-Dec-00 | ? | ? | ? | ? | ? |
| 7-Dec-00 | Martha | F10-AC-ST | Speed 2 | Van Damme | ? | ? | 3 | 10-Dec-00 | ? | ? | ? | ? | ? |
| 8-Dec-00 | Widi | F08-KR-MN | The Lost World | Dinosaurus | ? | ? | 2 | 15-Dec-00 | ? | ? | ? | ? | ? |
| 9-Dec-00 | Wanda | F05-AC-MN | Fire Down Below | Steven Seagel | ? | ? | 2 | 13-Dec-00 | ? | ? | ? | ? | ? |
| 9-Dec-00 | Maria | F12-DR-ST | Dances With Wolve | Kevin Costner | ? | ? | 2 | 13-Dec-00 | ? | ? | ? | ? | ? |
| 10-Dec-00 | Kevin | F07-DR-ST | Savage Hearts | Meryam Dabo | ? | ? | 2 | 16-Dec-00 | ? | ? | ? | ? | ? |
| 10-Dec-00 | Sofia | F03-CT-MN | Ghost | Demi Moore | ? | ? | 1 | 12-Dec-00 | ? | ? | ? | ? | ? |
| 11-Dec-00 | Lidya | F06-DR-ST | My Best Friends | Julia Robert | ? | ? | 1 | 13-Dec-00 | ? | ? | ? | ? | ? |
| 11-Dec-00 | Bram | F11-CT-MN | Basic Instince | Sharoon Stone | ? | ? | 2 | 19-Dec-00 | ? | ? | ? | ? | ? |
| Total Seluruhnya | |||||||||||||
| Jumlah Peminjam | |||||||||||||
| Total Bayar Terbesar | = ? | ||||||||||||
| Total Bayar Terkecil | = ? | Tabel -1 | |||||||||||
| Total Bayar Rata-rata | = ? | Kode | Jen.Film | Jumlah CD | |||||||||
| AC | Action | Horor | =………….. | Buah | |||||||||
| Jumlah Jenis Film | DR | Drama | Komedi | = …………… | Buah | ||||||||
| Horor | =………….. | Buah | KM | Komedi | Cinta | = …………… | Buah | ||||||
| Komedi | = …………… | Buah | KR | Kartun | Kartun | = …………… | Buah | ||||||
| Cinta | = …………… | Buah | CT | Cinta | Action | = …………… | Buah | ||||||
| Kartun | = …………… | Buah | Drama | = …………… | Buah | ||||||||
| Action | = …………… | Buah | Tabel -2 | ||||||||||
| Drama | = …………… | Buah | Kode | MN | ST | ||||||||
| Sistem Audio | Mono | Stereo | |||||||||||
| Keterangan Proses : | Sewa per Hari | 5,000 | 7,500 | ||||||||||
| - Biaya Sewa = Lama Pinjam * Sewa per Hari | |||||||||||||
| - Denda (15%) dikenakan kepada peminjam yang melebih waktu 3 hari, jika tidak dendanya 0 | |||||||||||||
| -Total Bayar = Biaya Sewa + Denda | |||||||||||||
| - sistem Audio berdasarkan tabel 2 dari 2 digit terakhir nomor film | |||||||||||||
no reviews yet
Please Login to review.
