SOAL POST TEST MICROSOFT EXCEL INTERMEDIATE OF ADVANCED
Quiz
•
Other
•
Professional Development
•
Medium
Media Edutama
Used 2+ 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
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple

Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
20 questions
ICE BREAKING PAK CIK
Quiz
•
Professional Development
25 questions
UJI COBA US MATEMATIKA
Quiz
•
Professional Development
20 questions
CA02/L3 KESEDARAN TEKNOLOGI MAKLUMAT
Quiz
•
Professional Development
20 questions
Sales and Order Quiz
Quiz
•
Professional Development
20 questions
JUMP & GROW
Quiz
•
Professional Development
20 questions
POST- TEST Motion Graphics
Quiz
•
Professional Development
20 questions
QC MBS 2
Quiz
•
Professional Development
20 questions
Excel Quiz
Quiz
•
Professional Development
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
20 questions
ELA Advisory Review
Quiz
•
7th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade