Apa kegunaan rumus IF dalam Excel?
Quiz 3
Professional Development
•5 Qs
Similar activities
Skincare Quizz
Professional Development
•10 Qs
Prize Game "How Well Do You Know Generation Girl?"
Professional Development
•9 Qs
Latihan
KG - Professional Development
•2 Qs
Pelatihan UKS TKK
Professional Development
•10 Qs
Quiz 1
Professional Development
•7 Qs
Quiz 2
Professional Development
•6 Qs
GPTP15 Sesi 2
Professional Development
•10 Qs
Quiz Webinar Kupas Tuntas Vaksin Covid
Professional Development
•10 Qs
Quiz 3
Quiz
•
Fun
•
Professional Development
•
Hard
zhofar setiawan
FREE Resource
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Melakukan operasi logika berdasarkan kondisi
Menggabungkan teks
Menjumlahkan nilai
Menghitung jumlah sel
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jelaskan cara membuat rumus IF bertingkat (nested IF) dan kapan kita menggunakannya
IF(kondisi1, nilai1, IF(kondisi2, nilai2, nilai_jika_salah))
IF(kondisi, nilai1, nilai2)
IF(kondisi1, IF(kondisi2, nilai2), nilai1)
IFERROR(nilai, nilai_jika_error)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa itu Conditional Formatting di Excel?
Format sel berdasarkan kondisi tertentu
Menggabungkan teks
Menjumlahkan nilai
Menghitung jumlah sel
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa gina Pivot Table di Excel?
Menyaring dan menganalisis data
Menggabungkan teks
Menjumlahkan nilai
Menghitung jumlah sel
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa langkah pertama dalam membuat Pivot Table di Excel?
Menyusun data dalam format tabel
Memilih sel acak di worksheet
Menggunakan fungsi SUM
Menggunakan rumus VLOOKUP
Similar Resources on Quizizz
10 questions
Sports
Quiz
•
1st Grade - Professio...
10 questions
GENBA CP 2023
Quiz
•
Professional Development
10 questions
Quiz CSW - SKK Migas 2023 (Hari 1).
Quiz
•
Professional Development
10 questions
Pelatihan Excel - Pre Test
Quiz
•
Professional Development
8 questions
TINI'S SPA 18TH ANNIVERSARY
Quiz
•
Professional Development
8 questions
Ice breaking
Quiz
•
Professional Development
10 questions
ASN BerAKHLAK P3k Pemprov Jatim (pre-test)
Quiz
•
Professional Development
10 questions
Refreshment Manager Bening's Clinic
Quiz
•
Professional Development
Popular Resources on Quizizz
15 questions
Character Analysis
Quiz
•
4th Grade
17 questions
Chapter 12 - Doing the Right Thing
Quiz
•
9th - 12th Grade
10 questions
American Flag
Quiz
•
1st - 2nd Grade
20 questions
Reading Comprehension
Quiz
•
5th Grade
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
18 questions
Full S.T.E.A.M. Ahead Summer Academy Pre-Test 24-25
Quiz
•
5th Grade
14 questions
Misplaced and Dangling Modifiers
Quiz
•
6th - 8th Grade