SOAL POST TEST MICROSOFT EXCEL INTERMEDIATE OF ADVANCED
Professional Development
•25 Qs
Similar activities
ACTIVE TRADER QUIZ (TOS)
Professional Development
•20 Qs
TEKNIS KEGIATAN BELAJAR MENGAJAR DAN PENILAIAN T.A 2026-2025
Professional Development
•22 Qs
QC MBS 2
Professional Development
•20 Qs
UH 2 SIMKOMDIG (MS EXCEL)
Professional Development
•25 Qs
POST- TEST Motion Graphics
Professional Development
•20 Qs
UJI KOMPETENSI IGTM
Professional Development
•20 Qs
Pemanfaatan Google Classroom dan Quizizz dalam PJJ
Professional Development
•20 Qs
Point Quiz Round 4
Professional Development
•20 Qs
SOAL POST TEST MICROSOFT EXCEL INTERMEDIATE OF ADVANCED
Quiz
•
Other
•
Professional Development
•
Medium
Media Edutama
Used 1+ times
FREE Resource
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
1. Bagaimana cara Anda menamai sebuah range di Excel?
A. Mengetik nama range di kotak "Name Box"
B. Mengklik kanan pada sel dan memilih "Name Range"
C. Menggunakan fungsi =NAMERANGE()
D. Menambah nama range di menu "Insert"
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
2. Tuliskan rumus untuk menjumlahkan data dari sel A1 di Sheet1 dan sel A1 di Sheet2.
A. =SUM(Sheet1!A1+Sheet2!A1)
B. =SUM(A1, Sheet1!A1, Sheet2!A1)
C. =SUM(A1+Sheet1!A1+Sheet2!A1)
D. =Sheet1!A1+Sheet2!A1
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
3. Berikan contoh penggunaan fungsi TEXT untuk mengubah format angka menjadi teks.
A. =TO_TEXT(A1, "0.00")
B. =TEXT(A1,"0.00")
C. =TEXTFORMAT(A1, "0.00")
D. =TEXTCONVERT(A1, "0.00")
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
4. Apa perbedaan antara fungsi IF dan IFS? Berikan contohnya.
A. IF tidak mendukung logika ganda, IFS mendukung.
B. IFS digunakan untuk kondisi tunggal, IF untuk kondisi ganda.
C. IF digunakan untuk kondisi tunggal, IFS untuk kondisi ganda.
D. IF digunakan untuk perhitungan angka, IFS untuk teks.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
5. Bagaimana cara menggunakan VLOOKUP untuk mencari data di tabel? Berikan contoh rumusnya.
A. =VLOOKUP(A1, Table, 2, TRUE)
B. =VLOOKUP(A1, Table, 2, FALSE)
C. =LOOKUP(A1, Table, 2, FALSE)
D. =LOOKUP(A1, Table, 2, TRUE)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
6. Bagaimana cara membuat tabel dari rentang data di Excel?
A. Pilih data, klik "Home", lalu "Table".
B. Pilih data, klik "Data", lalu "Table".
C. Pilih data, klik "Insert", lalu "Table".
D. Pilih data, klik "Format", lalu "Table".
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
7. Sebutkan langkah-langkah untuk menambahkan kolom baru dalam tabel yang sudah ada.
A. Klik kanan pada tabel dan pilih "Insert Column".
B. Klik tab "Table Design" dan pilih "Insert Column".
C. Klik tab "Home" dan pilih "Insert Column".
D. Klik kanan pada kolom dan pilih "Insert".
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
Konjungsi (pemula 1)
Quiz
•
Professional Development
20 questions
Mobile Legend Quiz
Quiz
•
Professional Development
20 questions
KUIZ HARI GURU SKKJ
Quiz
•
Professional Development
20 questions
Batch 2 Post Test 2 Analyzing Data Using Ms. Excel
Quiz
•
Professional Development
20 questions
Kuiz Soalan Ramalan C01
Quiz
•
Professional Development
20 questions
ULANGKAJI C04
Quiz
•
Professional Development
20 questions
Tertinggi mendapatkan hadiah dari sasa!
Quiz
•
Professional Development
20 questions
BAHASA MELAYU TINGKATAN 1
Quiz
•
3rd Grade - Professio...
Popular Resources on Wayground
18 questions
Writing Launch Day 1
Lesson
•
3rd Grade
11 questions
Hallway & Bathroom Expectations
Quiz
•
6th - 8th Grade
11 questions
Standard Response Protocol
Quiz
•
6th - 8th Grade
40 questions
Algebra Review Topics
Quiz
•
9th - 12th Grade
4 questions
Exit Ticket 7/29
Quiz
•
8th Grade
10 questions
Lab Safety Procedures and Guidelines
Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview
Lesson
•
9th - 12th Grade
20 questions
Subject-Verb Agreement
Quiz
•
9th Grade