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
11 questions
Kuis Pembelajaran TEK Kelas 8

Interactive video
•
7th - 9th Grade
11 questions
Kuis Penggunaan Jangka Sorong

Interactive video
•
7th - 10th Grade
6 questions
Relasi Dan Fungsi Bagian 3

Interactive video
•
8th Grade
9 questions
Pemahaman Aliran Fluida dalam Pipa

Interactive video
•
7th - 10th Grade
4 questions
Fungsi Statistik

Interactive video
•
8th Grade
11 questions
Kuis: Teknik Menyiku Ruangan

Interactive video
•
7th - 10th Grade
11 questions
Kuis Ekspresi dan Operasi Logika

Interactive video
•
7th - 9th Grade
11 questions
Pemeliharaan Rem Mobil

Interactive video
•
7th - 10th Grade
Popular Resources on Quizizz
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade
Discover more resources for Computers
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

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

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade