quiz IF EXCEL
12th Grade
•15 Qs
Similar activities
Dasar Komputer
10th Grade - University
•20 Qs
EXCEL
KG - Professional Development
•20 Qs
Post-Test Algoritma dan Pemrograman
10th Grade - University
•10 Qs
Penilaian Harian 1 Ms. Excel (Kondisi IF)
1st - 12th Grade
•10 Qs
Sains Komputer (Java) 2: Struktur Kawalan Pilihan
10th Grade - University
•10 Qs
Logical Function
9th - 12th Grade
•10 Qs
Percabangan c++
9th - 12th Grade
•20 Qs
quiz IF EXCEL
Quiz
•
Computers
•
12th Grade
•
Medium
Ratno Nugroho
Used 7+ times
FREE Resource
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")
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
Uji Pemahaman Formula Excel
Quiz
•
9th Grade - University
18 questions
SAINS KOMPUTER F5 BAB 3
Quiz
•
10th - 12th Grade
10 questions
Microsoft Excel էլեկտրոնային աղյուսակ
Quiz
•
12th Grade
10 questions
IPA 2
Quiz
•
12th Grade
12 questions
Java Strings
Quiz
•
9th - 12th Grade
20 questions
SPREADSHEET CR
Quiz
•
12th Grade
20 questions
Year 12 Spreadsheets
Quiz
•
12th Grade
20 questions
Trắc nghiệm Excel cơ bản - Nhóm 6
Quiz
•
4th Grade - University
Popular Resources on Wayground
10 questions
Video Games
Quiz
•
6th - 12th Grade
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition
Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12
Lesson
•
11th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade