SOAL POST TEST MICROSOFT EXCEL INTERMEDIATE OF ADVANCED
Professional Development
•25 Qs
Similar activities
QUIS RANDOM
Professional Development
•20 Qs
#TillJannah2021
Professional Development
•21 Qs
ACTIVE TRADER QUIZ (TOS)
Professional Development
•20 Qs
TEKNIS KEGIATAN BELAJAR MENGAJAR DAN PENILAIAN T.A 2026-2025
Professional Development
•22 Qs
Latihan Kata Kerja
1st Grade - Professional Development
•20 Qs
Private Pilot Stage Check Packet Vocabulary
Professional Development
•20 Qs
Customer Service - Service Tools (1)
Professional Development
•20 Qs
ทดสอบ Microsoft Word
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
Asas Psikologi Sukan
Quiz
•
9th Grade - Professio...
20 questions
Kuiz Soalan Ramalan C01
Quiz
•
Professional Development
20 questions
NABL Queries -1st Quiz (South 24 Pgs)
Quiz
•
Professional Development
21 questions
COMMON COMPETENCY 1 - APPLY QUALITY STANDARDS
Quiz
•
Professional Development
25 questions
Pretest LPA - Day 2
Quiz
•
Professional Development
20 questions
TES KARAKTERISTIK PRIBADI
Quiz
•
Professional Development
20 questions
Batch 2 Post Test 2 Analyzing Data Using Ms. Excel
Quiz
•
Professional Development
20 questions
BAHASA MELAYU TINGKATAN 1
Quiz
•
3rd Grade - Professio...
Popular Resources on Wayground
10 questions
Video Games
Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines
Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22
Lesson
•
9th - 12th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
20 questions
US Constitution Quiz
Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade