Apa fungsi utama dari IF di Microsoft Excel?

Kuis: Penggunaan Fungsi IF, And & Or di Microsoft Excel

Interactive Video
•
Computers
•
7th - 10th Grade
•
Hard

Ethan Morris
FREE Resource
Read more
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Menghitung jumlah sel
Menghitung rata-rata
Membuat keputusan berdasarkan kondisi
Mengurutkan data
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana sintaks dasar dari fungsi IF?
=IF(nilai_jika_salah, kondisi, nilai_jika_benar)
=IF(nilai_jika_benar, kondisi, nilai_jika_salah)
=IF(kondisi, nilai_jika_salah, nilai_jika_benar)
=IF(kondisi, nilai_jika_benar, nilai_jika_salah)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa yang dilakukan fungsi AND ketika digabungkan dengan IF?
Memeriksa apakah semua kondisi benar
Memeriksa apakah salah satu kondisi benar
Menghitung jumlah kondisi
Mengubah urutan kondisi
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa perbedaan utama antara fungsi AND dan OR ketika digunakan dengan IF?
AND memerlukan semua kondisi benar, OR hanya satu
OR memerlukan semua kondisi benar, AND hanya satu
AND dan OR memerlukan semua kondisi benar
AND dan OR hanya memerlukan satu kondisi benar
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Kapan sebaiknya menggunakan fungsi OR dengan IF?
Ketika semua kondisi harus benar
Ketika salah satu dari beberapa kondisi bisa benar
Ketika tidak ada kondisi yang benar
Ketika ingin menghitung jumlah kondisi
Similar Resources on Quizizz
5 questions
Aljabar Interaktif

Interactive video
•
8th Grade
11 questions
Kuis Pengukuran Volume Balok

Interactive video
•
7th - 10th Grade
11 questions
Kuis Tentang Enzim dan Metabolisme

Interactive video
•
7th - 10th Grade
11 questions
Kuis Biologi Manusia

Interactive video
•
6th - 10th Grade
11 questions
Alat dan Keselamatan di Laboratorium Kimia

Interactive video
•
7th - 10th Grade
9 questions
Median_Matematika SMP_Video Interaktif

Interactive video
•
8th Grade
9 questions
Komposisi Fungsi dan Aplikasi

Interactive video
•
7th - 10th Grade
11 questions
Kabel dan Kumparan Motor Listrik

Interactive video
•
7th - 10th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade
Discover more resources for Computers
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade