{"id":2043,"date":"2026-07-24T13:15:18","date_gmt":"2026-07-24T06:15:18","guid":{"rendered":"https:\/\/www.itera.ac.id\/blog\/?p=2043"},"modified":"2026-07-24T12:20:23","modified_gmt":"2026-07-24T05:20:23","slug":"contoh-soal-excel","status":"publish","type":"post","link":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/","title":{"rendered":"30 Contoh Soal Excel Beserta Rumus dan Jawaban Lengkap"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Contoh soal Excel<\/strong> sangat bermanfaat bagi pelajar, mahasiswa, maupun karyawan yang ingin meningkatkan kemampuan mengolah data menggunakan Microsoft Excel. Aplikasi spreadsheet ini banyak digunakan untuk perhitungan, analisis data, pembuatan laporan, hingga pengolahan informasi dalam dunia pendidikan maupun pekerjaan.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sebelum mengerjakan <strong>contoh soal Excel<\/strong>, ada baiknya memahami beberapa rumus dasar yang paling sering digunakan. Penguasaan rumus-rumus ini akan mempermudah Anda dalam menyelesaikan berbagai permasalahan secara cepat dan akurat.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Beberapa rumus Excel yang wajib dipahami antara lain:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SUM<\/strong> \u2192 Menjumlahkan data.\n<ul class=\"wp-block-list\">\n<li>Contoh: <code>=SUM(A1:A10)<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>AVERAGE<\/strong> \u2192 Menghitung nilai rata-rata.\n<ul class=\"wp-block-list\">\n<li>Contoh: <code>=AVERAGE(B2:B11)<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>MAX<\/strong> \u2192 Menentukan nilai terbesar.\n<ul class=\"wp-block-list\">\n<li>Contoh: <code>=MAX(C2:C20)<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>MIN<\/strong> \u2192 Menentukan nilai terkecil.\n<ul class=\"wp-block-list\">\n<li>Contoh: <code>=MIN(C2:C20)<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>COUNT<\/strong> \u2192 Menghitung jumlah sel yang berisi angka.\n<ul class=\"wp-block-list\">\n<li>Contoh: <code>=COUNT(A1:A20)<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>COUNTIF<\/strong> \u2192 Menghitung jumlah data berdasarkan kriteria tertentu.\n<ul class=\"wp-block-list\">\n<li>Contoh: <code>=COUNTIF(B2:B20,\"&gt;=75\")<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>IF<\/strong> \u2192 Menghasilkan keputusan berdasarkan suatu kondisi.\n<ul class=\"wp-block-list\">\n<li>Contoh: <code>=IF(C2&gt;=75,\"Lulus\",\"Tidak Lulus\")<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>VLOOKUP<\/strong> \u2192 Mencari data secara vertikal dalam tabel referensi.\n<ul class=\"wp-block-list\">\n<li>Contoh: <code>=VLOOKUP(A2,F2:H10,2,FALSE)<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>HLOOKUP<\/strong> \u2192 Mencari data secara horizontal.\n<ul class=\"wp-block-list\">\n<li>Contoh: <code>=HLOOKUP(B1,A1:G5,3,FALSE)<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>LEFT, RIGHT, MID<\/strong> \u2192 Mengambil sebagian karakter dari sebuah teks.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Dengan memahami fungsi-fungsi tersebut, Anda akan lebih mudah menyelesaikan berbagai <strong>contoh soal Excel<\/strong>, mulai dari soal dasar hingga soal analisis data yang sering muncul dalam tes kerja, ujian sekolah, seleksi administrasi, maupun sertifikasi komputer.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 1<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhatikan data berikut.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>A<\/th><th>B<\/th><\/tr><\/thead><tbody><tr><td>80<\/td><td>75<\/td><\/tr><tr><td>90<\/td><td>85<\/td><\/tr><tr><td>70<\/td><td>95<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Rumus Excel yang tepat untuk menghitung jumlah seluruh nilai pada rentang <strong>A1:B3<\/strong> adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. <code>=COUNT(A1:B3)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. <code>=AVERAGE(A1:B3)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. <code>=SUM(A1:B3)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. <code>=MAX(A1:B3)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. <code>=MIN(A1:B3)<\/code><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. <code>=SUM(A1:B3)<\/code><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>SUM<\/strong> digunakan untuk menjumlahkan seluruh angka dalam suatu rentang sel. Rumus <code>=SUM(A1:B3)<\/code> akan menghasilkan total semua nilai pada A1 sampai B3. Fungsi lain memiliki tujuan berbeda, seperti menghitung rata-rata, jumlah data, nilai terbesar, atau nilai terkecil.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi dasar Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu memilih rumus penjumlahan yang tepat.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 2<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Rumus Excel yang digunakan untuk menghitung nilai rata-rata dari sel <strong>C2 sampai C11<\/strong> adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. <code>=SUM(C2:C11)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. <code>=COUNT(C2:C11)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. <code>=AVERAGE(C2:C11)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. <code>=MAX(C2:C11)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. <code>=MIN(C2:C11)<\/code><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. <code>=AVERAGE(C2:C11)<\/code><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>AVERAGE<\/strong> digunakan untuk mencari nilai rata-rata dari sekumpulan angka. Pilihan lainnya memiliki fungsi yang berbeda sehingga tidak sesuai dengan perintah soal.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi AVERAGE.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menentukan rumus rata-rata yang benar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 3<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhatikan rumus berikut.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=IF(D2&gt;=75,\"Lulus\",\"Tidak Lulus\")<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Jika nilai pada sel <strong>D2 = 82<\/strong>, hasil yang ditampilkan adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. Gagal<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. Tidak Lulus<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. Lulus<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. Benar<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. Tinggi<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. Lulus<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Karena nilai D2 adalah <strong>82<\/strong>, kondisi <strong>D2&gt;=75<\/strong> bernilai benar sehingga fungsi IF akan menampilkan teks <strong>&#8220;Lulus&#8221;<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi IF.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menentukan hasil fungsi IF berdasarkan kondisi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 4<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi Excel yang digunakan untuk mencari nilai terbesar dalam rentang data adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. MIN<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. MAX<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. SUM<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. COUNT<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. AVERAGE<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>B. MAX<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>MAX<\/strong> digunakan untuk memperoleh nilai terbesar pada suatu rentang data. Sementara <strong>MIN<\/strong> mencari nilai terkecil, <strong>SUM<\/strong> menjumlahkan data, <strong>COUNT<\/strong> menghitung jumlah data numerik, dan <strong>AVERAGE<\/strong> menghitung rata-rata.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi statistik Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu mengidentifikasi fungsi untuk mencari nilai terbesar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C1 (Mengingat)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 5<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Rumus yang tepat untuk menghitung jumlah sel yang berisi angka pada rentang <strong>A1:A20<\/strong> adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. <code>=COUNT(A1:A20)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. <code>=COUNTA(A1:A20)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. <code>=SUM(A1:A20)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. <code>=MAX(A1:A20)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. <code>=IF(A1:A20)<\/code><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>A. <code>=COUNT(A1:A20)<\/code><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>COUNT<\/strong> digunakan untuk menghitung jumlah sel yang berisi angka. Berbeda dengan <strong>COUNTA<\/strong> yang menghitung seluruh sel yang tidak kosong, baik angka maupun teks.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi COUNT.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu membedakan fungsi COUNT dan COUNTA.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 6<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhatikan tabel berikut.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Nama<\/th><th>Nilai<\/th><\/tr><\/thead><tbody><tr><td>Andi<\/td><td>80<\/td><\/tr><tr><td>Budi<\/td><td>72<\/td><\/tr><tr><td>Citra<\/td><td>90<\/td><\/tr><tr><td>Dinda<\/td><td>65<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Rumus yang tepat untuk menghitung jumlah siswa yang memperoleh nilai <strong>minimal 75<\/strong> adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. <code>=COUNT(B2:B5)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. <code>=COUNTIF(B2:B5,\"&gt;=75\")<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. <code>=SUM(B2:B5)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. <code>=AVERAGE(B2:B5)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. <code>=MAX(B2:B5)<\/code><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>B. <code>=COUNTIF(B2:B5,\"&gt;=75\")<\/code><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>COUNTIF<\/strong> digunakan untuk menghitung jumlah data berdasarkan syarat tertentu. Pada tabel tersebut terdapat dua nilai yang memenuhi syarat, yaitu 80 dan 90.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Menggunakan fungsi COUNTIF.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menerapkan fungsi COUNTIF dengan kriteria tertentu.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sedang<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 7<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>VLOOKUP<\/strong> digunakan untuk &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. Mengurutkan data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. Menjumlahkan data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. Mencari data secara vertikal pada tabel referensi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. Menghapus data ganda.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. Menghitung rata-rata.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. Mencari data secara vertikal pada tabel referensi.<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>VLOOKUP (Vertical Lookup)<\/strong> digunakan untuk mencari data pada kolom pertama tabel referensi, kemudian mengambil nilai dari kolom lain dalam baris yang sama.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi pencarian data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menjelaskan fungsi VLOOKUP.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sedang<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 8<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>LEFT(&#8220;KOMPUTER&#8221;,3)<\/strong> akan menghasilkan &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. PUT<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. KOM<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. TER<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. MPU<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. OMP<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>B. KOM<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>LEFT<\/strong> mengambil sejumlah karakter dari sisi kiri teks. Karena diminta 3 karakter pertama, hasilnya adalah <strong>KOM<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi teks pada Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menggunakan fungsi LEFT.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 9<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Jika sel <strong>A1<\/strong> berisi angka <strong>125<\/strong> dan sel <strong>A2<\/strong> berisi angka <strong>75<\/strong>, maka hasil rumus:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=A1-A2<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. 40<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. 45<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. 50<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. 55<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. 60<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. 50<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhitungan dilakukan langsung menggunakan operator pengurangan.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">125 \u2212 75 = <strong>50<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Melakukan operasi aritmetika di Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menggunakan operator matematika dasar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 10<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhatikan rumus berikut.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=MIN(C2:C12)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi tersebut digunakan untuk &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. Menentukan nilai rata-rata.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. Menjumlahkan seluruh nilai.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. Menentukan nilai terbesar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. Menentukan nilai terkecil.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. Menghitung jumlah data.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>D. Menentukan nilai terkecil.<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>MIN<\/strong> digunakan untuk mencari nilai terkecil dalam suatu rentang data. Fungsi ini sering digunakan dalam analisis nilai, penjualan, maupun data statistik.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi MIN.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu mengidentifikasi fungsi untuk mencari nilai terkecil.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 11<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhatikan rumus berikut.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=MAX(B2:B12)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi tersebut digunakan untuk &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. Menghitung jumlah data<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. Menjumlahkan seluruh angka<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. Menentukan nilai terbesar<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. Menentukan nilai terkecil<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. Mengurutkan data<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. Menentukan nilai terbesar<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>MAX<\/strong> digunakan untuk mencari nilai terbesar dalam suatu rentang data. Fungsi ini sering digunakan untuk mengetahui nilai tertinggi, penjualan terbesar, atau skor maksimum.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi MAX.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menentukan fungsi yang digunakan untuk mencari nilai terbesar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C1 (Mengingat)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 12<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhatikan tabel berikut.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>A (Kode)<\/th><th>B (Nama Barang)<\/th><\/tr><\/thead><tbody><tr><td>B001<\/td><td>Buku<\/td><\/tr><tr><td>B002<\/td><td>Pensil<\/td><\/tr><tr><td>B003<\/td><td>Penghapus<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Rumus yang paling tepat untuk mencari nama barang berdasarkan kode menggunakan <strong>VLOOKUP<\/strong> adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. <code>=SUM(A2:B4)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. <code>=AVERAGE(A2:B4)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. <code>=VLOOKUP(E2,A2:B4,2,FALSE)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. <code>=COUNT(A2:B4)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. <code>=MIN(A2:B4)<\/code><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. <code>=VLOOKUP(E2,A2:B4,2,FALSE)<\/code><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>VLOOKUP<\/strong> mencari nilai pada kolom pertama tabel, kemudian mengambil data dari kolom yang ditentukan. Angka <strong>2<\/strong> menunjukkan kolom kedua (Nama Barang), sedangkan <strong>FALSE<\/strong> digunakan agar pencarian bersifat tepat (<em>exact match<\/em>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Menggunakan fungsi VLOOKUP.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu memilih rumus VLOOKUP yang benar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sedang<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 13<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Jika sel <strong>A1<\/strong> berisi teks <strong>&#8220;INFORMATIKA&#8221;<\/strong>, hasil dari rumus:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=RIGHT(A1,4)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. INFO<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. TIKA<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. FORM<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. MATI<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. ATIK<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>B. TIKA<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>RIGHT<\/strong> mengambil sejumlah karakter dari bagian kanan teks. Empat karakter terakhir dari kata <strong>INFORMATIKA<\/strong> adalah <strong>TIKA<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi RIGHT.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menggunakan fungsi RIGHT untuk mengambil karakter.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 14<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhatikan rumus berikut.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=IF(C2&gt;=80,\"A\",\"B\")<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Jika nilai pada sel <strong>C2<\/strong> adalah <strong>75<\/strong>, hasil yang ditampilkan adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. A<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. B<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. C<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. Lulus<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. Tidak Lulus<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>B. B<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Karena nilai <strong>75<\/strong> lebih kecil dari <strong>80<\/strong>, kondisi pada fungsi IF bernilai salah sehingga Excel menampilkan hasil <strong>&#8220;B&#8221;<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Menggunakan fungsi IF.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menentukan hasil fungsi IF berdasarkan kondisi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 15<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi Excel yang digunakan untuk menghitung jumlah seluruh sel yang <strong>tidak kosong<\/strong> adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. COUNT<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. COUNTA<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. COUNTIF<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. SUM<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. AVERAGE<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>B. COUNTA<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>COUNTA<\/strong> menghitung seluruh sel yang berisi data, baik angka, teks, maupun tanggal. Berbeda dengan <strong>COUNT<\/strong> yang hanya menghitung sel yang berisi angka.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi COUNTA.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu membedakan fungsi COUNT dan COUNTA.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sedang<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 16<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Jika sel <strong>B2<\/strong> berisi angka <strong>45<\/strong> dan sel <strong>B3<\/strong> berisi angka <strong>55<\/strong>, hasil dari rumus:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=SUM(B2:B3)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. 90<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. 95<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. 100<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. 105<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. 110<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. 100<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>SUM<\/strong> menjumlahkan semua angka dalam rentang yang dipilih.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">45 + 55 = <strong>100<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Menggunakan fungsi SUM.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menghitung hasil fungsi SUM.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 17<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>HLOOKUP<\/strong> digunakan untuk &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. Mencari data secara vertikal.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. Mencari data secara horizontal.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. Menjumlahkan data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. Mengurutkan data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. Menghapus data.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>B. Mencari data secara horizontal.<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>HLOOKUP (Horizontal Lookup)<\/strong> digunakan untuk mencari data berdasarkan baris pertama tabel, kemudian mengambil nilai dari baris yang ditentukan.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi HLOOKUP.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu membedakan fungsi VLOOKUP dan HLOOKUP.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sedang<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 18<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhatikan rumus berikut.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=MID(\"KOMPUTER\",3,4)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Hasil yang ditampilkan adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. KOMP<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. MPUT<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. MPUT<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. OMPU<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. PUTE<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. MPUT<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>MID(teks, posisi_awal, jumlah_karakter)<\/strong> mengambil karakter mulai dari posisi tertentu.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Posisi ke-3 pada kata <strong>KOMPUTER<\/strong> adalah huruf <strong>M<\/strong>.<\/li>\n\n\n\n<li>Empat karakter berikutnya adalah <strong>MPUT<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Menggunakan fungsi MID.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menentukan hasil fungsi MID.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sedang<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 19<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi Excel yang digunakan untuk mencari nilai terkecil pada suatu rentang data adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. MAX<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. MIN<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. SUM<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. COUNT<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. IF<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>B. MIN<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>MIN<\/strong> menghasilkan nilai paling kecil dari seluruh angka dalam rentang yang dipilih.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi MIN.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu mengidentifikasi fungsi pencari nilai minimum.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C1 (Mengingat)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 20<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Sebuah sekolah ingin memberikan keterangan <strong>&#8220;Lulus&#8221;<\/strong> jika nilai siswa minimal <strong>75<\/strong>, dan <strong>&#8220;Remedial&#8221;<\/strong> jika kurang dari 75. Rumus Excel yang paling tepat adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. <code>=SUM(B2:B10)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. <code>=COUNT(B2:B10)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. <code>=IF(B2&gt;=75,\"Lulus\",\"Remedial\")<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. <code>=AVERAGE(B2:B10)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. <code>=MAX(B2:B10)<\/code><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. <code>=IF(B2&gt;=75,\"Lulus\",\"Remedial\")<\/code><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>IF<\/strong> digunakan untuk membuat keputusan berdasarkan suatu kondisi. Jika nilai pada sel <strong>B2<\/strong> lebih besar atau sama dengan 75, hasilnya <strong>&#8220;Lulus&#8221;<\/strong>. Jika kurang dari 75, hasilnya <strong>&#8220;Remedial&#8221;<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Menggunakan fungsi logika IF.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menerapkan fungsi IF dalam kasus penilaian.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sedang<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 21<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhatikan rumus berikut.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=LEN(\"MATEMATIKA\")<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Hasil yang ditampilkan adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. 8<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. 9<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. 10<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. 11<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. 12<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. 10<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>LEN<\/strong> digunakan untuk menghitung jumlah karakter dalam sebuah teks. Kata <strong>MATEMATIKA<\/strong> terdiri atas 10 karakter.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi LEN.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menentukan hasil fungsi LEN.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 22<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi Excel yang digunakan untuk mengubah seluruh huruf menjadi huruf kapital adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. LOWER<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. PROPER<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. UPPER<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. MID<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. LEFT<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. UPPER<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>UPPER<\/strong> mengubah seluruh huruf pada teks menjadi huruf kapital. Fungsi <strong>LOWER<\/strong> mengubah menjadi huruf kecil, sedangkan <strong>PROPER<\/strong> hanya membuat huruf pertama setiap kata menjadi kapital.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi pengolah teks.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu memilih fungsi UPPER sesuai kegunaannya.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C1 (Mengingat)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 23<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhatikan tabel berikut.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Nilai<\/th><\/tr><\/thead><tbody><tr><td>85<\/td><\/tr><tr><td>90<\/td><\/tr><tr><td>70<\/td><\/tr><tr><td>75<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Rumus yang tepat untuk menghitung rata-rata seluruh nilai tersebut adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. <code>=SUM(A2:A5)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. <code>=COUNT(A2:A5)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. <code>=AVERAGE(A2:A5)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. <code>=MAX(A2:A5)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. <code>=MIN(A2:A5)<\/code><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. <code>=AVERAGE(A2:A5)<\/code><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>AVERAGE<\/strong> digunakan untuk menghitung nilai rata-rata dari sekumpulan angka. Rumus tersebut akan menghasilkan rata-rata dari seluruh nilai pada rentang A2:A5.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Menggunakan fungsi AVERAGE.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu memilih rumus rata-rata yang benar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 24<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Jika sel <strong>A1<\/strong> berisi teks <strong>&#8220;Belajar Excel&#8221;<\/strong>, hasil dari rumus:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=LOWER(A1)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. BELAJAR EXCEL<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. Belajar Excel<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. belajar excel<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. Belajar excel<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. BELAJAR Excel<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. belajar excel<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>LOWER<\/strong> mengubah seluruh huruf menjadi huruf kecil (<em>lowercase<\/em>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi LOWER.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menentukan hasil fungsi LOWER.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 25<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Rumus yang digunakan untuk mencari nilai pada tabel referensi secara <strong>horizontal<\/strong> adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. VLOOKUP<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. HLOOKUP<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. SUM<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. COUNTIF<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. IF<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>B. HLOOKUP<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>HLOOKUP<\/strong> mencari data berdasarkan baris pertama (<em>horizontal<\/em>), sedangkan <strong>VLOOKUP<\/strong> mencari berdasarkan kolom pertama (<em>vertikal<\/em>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi pencarian data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu membedakan fungsi HLOOKUP dan VLOOKUP.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2 (Memahami)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sedang<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 26<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Perhatikan rumus berikut.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=COUNTIF(C2:C10,\"&gt;80\")<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi tersebut digunakan untuk &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. Menjumlahkan nilai di atas 80.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. Menghitung banyaknya nilai yang lebih dari 80.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. Menentukan rata-rata nilai di atas 80.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. Menentukan nilai terbesar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. Mengurutkan data.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>B. Menghitung banyaknya nilai yang lebih dari 80.<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>COUNTIF<\/strong> digunakan untuk menghitung jumlah sel yang memenuhi syarat tertentu. Pada rumus tersebut, syaratnya adalah nilai lebih besar dari 80.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Menggunakan fungsi COUNTIF.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu memahami penggunaan COUNTIF dengan kriteria.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sedang<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 27<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Jika sel <strong>B2<\/strong> berisi angka <strong>250<\/strong> dan sel <strong>B3<\/strong> berisi angka <strong>40<\/strong>, hasil dari rumus:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=B2\/B3<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. 5<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. 6<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. 6,25<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. 6,5<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. 7<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. 6,25<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Operasi pembagian pada Excel menggunakan tanda <strong>\/<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">250 \u00f7 40 = <strong>6,25<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Melakukan operasi aritmetika pada Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menggunakan operator pembagian.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 28<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>PROPER<\/strong> pada Excel digunakan untuk &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. Mengubah seluruh huruf menjadi kapital.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. Mengubah seluruh huruf menjadi kecil.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. Mengubah huruf pertama setiap kata menjadi kapital.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. Menghapus spasi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. Menggabungkan teks.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. Mengubah huruf pertama setiap kata menjadi kapital.<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>PROPER<\/strong> mengubah huruf pertama setiap kata menjadi huruf kapital, sedangkan huruf lainnya menjadi huruf kecil.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Memahami fungsi PROPER.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menjelaskan kegunaan fungsi PROPER.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C1 (Mengingat)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 29<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Jika sel <strong>A1<\/strong> berisi angka <strong>15<\/strong> dan sel <strong>A2<\/strong> berisi angka <strong>8<\/strong>, hasil rumus:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>=A1*A2<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. 100<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. 110<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. 120<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. 125<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. 130<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. 120<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Tanda <strong>*<\/strong> digunakan untuk operasi perkalian pada Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">15 \u00d7 8 = <strong>120<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Melakukan operasi perkalian pada Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menggunakan operator perkalian.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1 menit<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Soal Nomor 30<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Pertanyaan<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Sebuah perusahaan ingin menampilkan status <strong>&#8220;Bonus&#8221;<\/strong> jika total penjualan pada sel <strong>D2<\/strong> minimal <strong>10000000<\/strong>, dan <strong>&#8220;Belum Bonus&#8221;<\/strong> jika kurang dari nilai tersebut. Rumus Excel yang paling tepat adalah &#8230;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pilihan Jawaban<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A. <code>=SUM(D2)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B. <code>=COUNT(D2)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C. <code>=IF(D2&gt;=10000000,\"Bonus\",\"Belum Bonus\")<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D. <code>=AVERAGE(D2)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E. <code>=MAX(D2)<\/code><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Jawaban Benar<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C. <code>=IF(D2&gt;=10000000,\"Bonus\",\"Belum Bonus\")<\/code><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pembahasan Lengkap<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Fungsi <strong>IF<\/strong> digunakan untuk menghasilkan keputusan berdasarkan suatu kondisi. Jika nilai pada sel <strong>D2<\/strong> mencapai atau melebihi <strong>10.000.000<\/strong>, Excel akan menampilkan <strong>&#8220;Bonus&#8221;<\/strong>. Jika kurang dari itu, hasilnya adalah <strong>&#8220;Belum Bonus&#8221;<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kompetensi yang Diukur<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Menggunakan fungsi logika IF dalam studi kasus.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indikator Pembelajaran<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peserta didik mampu menerapkan fungsi IF pada kasus pengambilan keputusan.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Level Kognitif (Taksonomi Bloom C1\u2013C6)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C3 (Menerapkan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tingkat Kesulitan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sedang<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Estimasi Waktu Pengerjaan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 menit<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Kesimpulan<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Mempelajari <strong>contoh soal Excel<\/strong> merupakan langkah yang tepat untuk meningkatkan keterampilan mengolah data menggunakan Microsoft Excel. Dengan memahami fungsi-fungsi dasar seperti <strong>SUM<\/strong>, <strong>AVERAGE<\/strong>, <strong>IF<\/strong>, <strong>COUNTIF<\/strong>, <strong>VLOOKUP<\/strong>, <strong>HLOOKUP<\/strong>, hingga fungsi pengolah teks, Anda akan lebih mudah menyelesaikan berbagai pekerjaan maupun soal ujian yang berkaitan dengan spreadsheet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Melalui latihan <strong>contoh soal Excel<\/strong> secara rutin, kemampuan dalam memilih rumus yang tepat, menganalisis data, serta menyelesaikan permasalahan berbasis tabel akan semakin meningkat. Selain itu, pembahasan pada setiap soal dapat membantu memahami konsep penggunaan rumus secara lebih mendalam, sehingga keterampilan menggunakan Excel menjadi lebih cepat, akurat, dan siap diterapkan baik di lingkungan pendidikan maupun dunia kerja.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contoh soal Excel sangat bermanfaat bagi pelajar, mahasiswa, maupun karyawan yang ingin meningkatkan kemampuan mengolah data menggunakan Microsoft Excel. Aplikasi&hellip;<\/p>\n","protected":false},"author":3,"featured_media":2045,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-2043","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pendidikan"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>30 Contoh Soal Excel Beserta Rumus dan Jawaban Lengkap<\/title>\n<meta name=\"description\" content=\"Contoh soal Excel lengkap dengan jawaban. Pelajari rumus SUM, IF, VLOOKUP, HLOOKUP, COUNTIF, hingga fungsi logika melalui latihan soal .\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"30 Contoh Soal Excel Beserta Rumus dan Jawaban Lengkap\" \/>\n<meta property=\"og:description\" content=\"Contoh soal Excel lengkap dengan jawaban. Pelajari rumus SUM, IF, VLOOKUP, HLOOKUP, COUNTIF, hingga fungsi logika melalui latihan soal .\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Itera Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-07-24T06:15:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.itera.ac.id\/blog\/wp-content\/uploads\/2026\/07\/Contoh-Soal-Excel-Lengkap-dengan-Jawaban-dan-Pembahasan-Terbaru.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1672\" \/>\n\t<meta property=\"og:image:height\" content=\"941\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Rizky Pratama\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rizky Pratama\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/\"},\"author\":{\"name\":\"Rizky Pratama\",\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/#\\\/schema\\\/person\\\/2d0d1b8cbbe0f7a63a6b6d0b0768c0f8\"},\"headline\":\"30 Contoh Soal Excel Beserta Rumus dan Jawaban Lengkap\",\"datePublished\":\"2026-07-24T06:15:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/\"},\"wordCount\":2838,\"publisher\":{\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/Contoh-Soal-Excel-Lengkap-dengan-Jawaban-dan-Pembahasan-Terbaru.png\",\"articleSection\":[\"Pendidikan\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/\",\"url\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/\",\"name\":\"30 Contoh Soal Excel Beserta Rumus dan Jawaban Lengkap\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/Contoh-Soal-Excel-Lengkap-dengan-Jawaban-dan-Pembahasan-Terbaru.png\",\"datePublished\":\"2026-07-24T06:15:18+00:00\",\"description\":\"Contoh soal Excel lengkap dengan jawaban. Pelajari rumus SUM, IF, VLOOKUP, HLOOKUP, COUNTIF, hingga fungsi logika melalui latihan soal .\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/Contoh-Soal-Excel-Lengkap-dengan-Jawaban-dan-Pembahasan-Terbaru.png\",\"contentUrl\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/Contoh-Soal-Excel-Lengkap-dengan-Jawaban-dan-Pembahasan-Terbaru.png\",\"width\":1672,\"height\":941,\"caption\":\"Contoh Soal Excel Lengkap dengan Jawaban dan Pembahasan Terbaru\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/contoh-soal-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"30 Contoh Soal Excel Beserta Rumus dan Jawaban Lengkap\",\"item\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/blog\\\/wp-json\\\/wp\\\/v2\\\/posts\\\/2043\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/\",\"name\":\"Itera Blog\",\"description\":\"Portal Informasi Berita Indonesia dari Dunia Kampus\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/#organization\",\"name\":\"Itera Blog\",\"url\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/cropped-pict-1.png\",\"contentUrl\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/cropped-pict-1.png\",\"width\":417,\"height\":154,\"caption\":\"Itera Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/#\\\/schema\\\/person\\\/2d0d1b8cbbe0f7a63a6b6d0b0768c0f8\",\"name\":\"Rizky Pratama\",\"description\":\"Rizky Pratama merupakan penulis yang berfokus pada isu pendidikan, dunia kampus, beasiswa, kurikulum, dan pengembangan sumber daya manusia. Aktif menyusun artikel berbasis referensi resmi agar informasi yang disampaikan mudah dipahami dan bermanfaat bagi pelajar, mahasiswa, guru, serta masyarakat umum.\",\"url\":\"https:\\\/\\\/www.itera.ac.id\\\/blog\\\/author\\\/rizky\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"30 Contoh Soal Excel Beserta Rumus dan Jawaban Lengkap","description":"Contoh soal Excel lengkap dengan jawaban. Pelajari rumus SUM, IF, VLOOKUP, HLOOKUP, COUNTIF, hingga fungsi logika melalui latihan soal .","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/","og_locale":"en_US","og_type":"article","og_title":"30 Contoh Soal Excel Beserta Rumus dan Jawaban Lengkap","og_description":"Contoh soal Excel lengkap dengan jawaban. Pelajari rumus SUM, IF, VLOOKUP, HLOOKUP, COUNTIF, hingga fungsi logika melalui latihan soal .","og_url":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/","og_site_name":"Itera Blog","article_published_time":"2026-07-24T06:15:18+00:00","og_image":[{"width":1672,"height":941,"url":"https:\/\/www.itera.ac.id\/blog\/wp-content\/uploads\/2026\/07\/Contoh-Soal-Excel-Lengkap-dengan-Jawaban-dan-Pembahasan-Terbaru.png","type":"image\/png"}],"author":"Rizky Pratama","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rizky Pratama","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/#article","isPartOf":{"@id":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/"},"author":{"name":"Rizky Pratama","@id":"https:\/\/www.itera.ac.id\/blog\/#\/schema\/person\/2d0d1b8cbbe0f7a63a6b6d0b0768c0f8"},"headline":"30 Contoh Soal Excel Beserta Rumus dan Jawaban Lengkap","datePublished":"2026-07-24T06:15:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/"},"wordCount":2838,"publisher":{"@id":"https:\/\/www.itera.ac.id\/blog\/#organization"},"image":{"@id":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.itera.ac.id\/blog\/wp-content\/uploads\/2026\/07\/Contoh-Soal-Excel-Lengkap-dengan-Jawaban-dan-Pembahasan-Terbaru.png","articleSection":["Pendidikan"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/","url":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/","name":"30 Contoh Soal Excel Beserta Rumus dan Jawaban Lengkap","isPartOf":{"@id":"https:\/\/www.itera.ac.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.itera.ac.id\/blog\/wp-content\/uploads\/2026\/07\/Contoh-Soal-Excel-Lengkap-dengan-Jawaban-dan-Pembahasan-Terbaru.png","datePublished":"2026-07-24T06:15:18+00:00","description":"Contoh soal Excel lengkap dengan jawaban. Pelajari rumus SUM, IF, VLOOKUP, HLOOKUP, COUNTIF, hingga fungsi logika melalui latihan soal .","breadcrumb":{"@id":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/#primaryimage","url":"https:\/\/www.itera.ac.id\/blog\/wp-content\/uploads\/2026\/07\/Contoh-Soal-Excel-Lengkap-dengan-Jawaban-dan-Pembahasan-Terbaru.png","contentUrl":"https:\/\/www.itera.ac.id\/blog\/wp-content\/uploads\/2026\/07\/Contoh-Soal-Excel-Lengkap-dengan-Jawaban-dan-Pembahasan-Terbaru.png","width":1672,"height":941,"caption":"Contoh Soal Excel Lengkap dengan Jawaban dan Pembahasan Terbaru"},{"@type":"BreadcrumbList","@id":"https:\/\/www.itera.ac.id\/blog\/contoh-soal-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itera.ac.id\/blog\/"},{"@type":"ListItem","position":2,"name":"30 Contoh Soal Excel Beserta Rumus dan Jawaban Lengkap","item":"https:\/\/www.itera.ac.id\/blog\/blog\/wp-json\/wp\/v2\/posts\/2043"}]},{"@type":"WebSite","@id":"https:\/\/www.itera.ac.id\/blog\/#website","url":"https:\/\/www.itera.ac.id\/blog\/","name":"Itera Blog","description":"Portal Informasi Berita Indonesia dari Dunia Kampus","publisher":{"@id":"https:\/\/www.itera.ac.id\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itera.ac.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.itera.ac.id\/blog\/#organization","name":"Itera Blog","url":"https:\/\/www.itera.ac.id\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.itera.ac.id\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.itera.ac.id\/blog\/wp-content\/uploads\/2026\/07\/cropped-pict-1.png","contentUrl":"https:\/\/www.itera.ac.id\/blog\/wp-content\/uploads\/2026\/07\/cropped-pict-1.png","width":417,"height":154,"caption":"Itera Blog"},"image":{"@id":"https:\/\/www.itera.ac.id\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.itera.ac.id\/blog\/#\/schema\/person\/2d0d1b8cbbe0f7a63a6b6d0b0768c0f8","name":"Rizky Pratama","description":"Rizky Pratama merupakan penulis yang berfokus pada isu pendidikan, dunia kampus, beasiswa, kurikulum, dan pengembangan sumber daya manusia. Aktif menyusun artikel berbasis referensi resmi agar informasi yang disampaikan mudah dipahami dan bermanfaat bagi pelajar, mahasiswa, guru, serta masyarakat umum.","url":"https:\/\/www.itera.ac.id\/blog\/author\/rizky\/"}]}},"_links":{"self":[{"href":"https:\/\/www.itera.ac.id\/blog\/wp-json\/wp\/v2\/posts\/2043","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itera.ac.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itera.ac.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itera.ac.id\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itera.ac.id\/blog\/wp-json\/wp\/v2\/comments?post=2043"}],"version-history":[{"count":1,"href":"https:\/\/www.itera.ac.id\/blog\/wp-json\/wp\/v2\/posts\/2043\/revisions"}],"predecessor-version":[{"id":2046,"href":"https:\/\/www.itera.ac.id\/blog\/wp-json\/wp\/v2\/posts\/2043\/revisions\/2046"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itera.ac.id\/blog\/wp-json\/wp\/v2\/media\/2045"}],"wp:attachment":[{"href":"https:\/\/www.itera.ac.id\/blog\/wp-json\/wp\/v2\/media?parent=2043"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itera.ac.id\/blog\/wp-json\/wp\/v2\/categories?post=2043"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itera.ac.id\/blog\/wp-json\/wp\/v2\/tags?post=2043"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}