quiz IF EXCEL
Authored by Ratno Nugroho
Computers
12th Grade
Used 9+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Manakah rumus IF berikut yang akan menampilkan teks "Lulus" jika nilai di sel A2 lebih besar dari sama dengan 70, dan "Tidak Lulus" jika tidak?
=(A2>=70,"Lulus","Tidak Lulus")
=IF(A2>70,"Lulus",Tidak Lulus)
=IF(A2>=70,Lulus,Tidak Lulus)
=IF(A2>70,Lulus)
2.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Manakah rumus IF berikut yang akan menampilkan teks "Sukses" jika nilai di sel B2 lebih besar dari 50, dan "Gagal" jika tidak?
=IF(B2>50,"Sukses","Gagal")
=IF(B2>=50,Sukses,Gagal)
=IF(B2>50,"Sukses",Gagal)
=IF(B2>=50,"Sukses")
3.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Manakah rumus IF berikut yang akan menampilkan teks "Aman" jika nilai di sel C2 kurang dari 100, dan "Tidak Aman" jika tidak?
=IF(C2<100,"Aman","Tidak Aman")
=IF(C2>100,Aman,Tidak Aman)
=IF(C2>=100,"Tidak Aman")
=IF(C2<100,"Tidak Aman")
4.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Manakah rumus IF berikut yang akan menampilkan teks "Diterima" jika nilai di sel D2 lebih besar dari 60, dan "Ditolak" jika tidak?
=IF(D2>60,"Diterima","Ditolak")
=IF(D2>60,"Diterima",Ditolak)
=IF(D2<60,"Ditolak")
=IF(D2>=60,"Diterima")
5.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Anda ingin menghitung bonus karyawan berdasarkan target penjualan. Jika penjualan melebihi target, bonusnya 10% dari penjualan. Jika tidak, bonusnya 5%. Rumus IF yang tepat adalah...
=IF(B2>C2,B20.1,B20.05)
=IF(B2<C2,B20.1,B20.05)
=IF(B2=C2,B20.1,B20.05)
=IF(B2>=C2,B20.1,B20.05)
6.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Anda ingin mengkategorikan pelanggan berdasarkan jumlah pembelian. Jika pembelian lebih dari 100 unit, kategori "Platinum", jika antara 50-100 unit, "Gold", dan jika kurang dari 50 unit, "Silver". Rumus IF bersarang yang tepat adalah...
=IF(A2>100,"Platinum",IF(A2>=50,"Gold","Silver"))
=IF(A2>100,"Platinum",IF(A2<50,"Silver","Gold"))
=IF(A2>=50,"Gold",IF(A2>100,"Platinum","Silver"))
=IF(A2<50,"Silver",IF(A2>100,"Platinum","Gold"))
7.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Manakah rumus IF berikut yang akan menampilkan teks "Baik" jika nilai di sel E2 lebih besar dari 80, dan "Buruk" jika tidak?
=IF(E2>80,"Baik","Buruk")
=IF(E2>=80,Baik,Buruk)
=IF(E2>80,"Baik",Buruk)
=IF(E2<80,"Buruk")
Access all questions and much more by creating a free account
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
Already have an account?
Similar Resources on Wayground
14 questions
Bài 29. Nhận biết lỗi chương trình
Quiz
•
9th - 12th Grade
20 questions
Format File Gambar
Quiz
•
12th Grade
20 questions
Quiz ASJ
Quiz
•
12th Grade
20 questions
TIK 9 - Penggunaan Browser Untuk Akses Internet
Quiz
•
11th - 12th Grade
17 questions
Quiz 01 Keamanan Jaringan
Quiz
•
12th Grade
10 questions
XI_осн_веб_кон
Quiz
•
9th - 12th Grade
15 questions
网络与通讯
Quiz
•
12th Grade
15 questions
Excel
Quiz
•
12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
