Uji Pemahaman Formula Excel
Authored by Zulfikkar Purwa Nugraha
Computers
10th Grade
Used 7+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa hasil dari rumus =IF(A1>10, "Lebih dari 10", "10 atau kurang") jika A1 = 15?
Lebih dari 20
Kurang dari 10
Lebih dari 10
Sama dengan 10
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus =IF(A1>10, "A", IF(A1<5, "B", "C")) akan menghasilkan apa jika A1 = 3?
A
C
D
B
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika A1 = 5 dan A2 = 10, apa hasil dari rumus =IF(OR(A1>5, A2<15), "Benar", "Salah")?
Benar
Salah
Tidak Benar
Mungkin
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa hasil dari rumus =IF(AND(A1>5, A2<15), "Benar", "Salah") jika A1 = 6 dan A2 = 14?
Tidak Benar
Kurang Tepat
Benar
Salah
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi VLOOKUP digunakan untuk mencari nilai berdasarkan ....
Baris
Sel
Kolom
Range
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa yang akan dikembalikan oleh rumus =VLOOKUP("Apel", A1:B5, 2, FALSE) jika "Apel" ada di A2 dan B2 berisi "Merah"?
Hijau
Merah
Biru
Kuning
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi HLOOKUP digunakan untuk mencari nilai berdasarkan ....
Kolom
Sel
Baris
Range
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
25 questions
Networks and the Internet
Quiz
•
9th - 12th Grade
25 questions
SAINS KOMPUTER TINGKATAN 4 - 1.6 STRUKTUR DATA DAN MODULAR
Quiz
•
7th - 12th Grade
25 questions
UH Jaringan Komputer
Quiz
•
10th Grade
30 questions
SKT5 : Bab 3 : f) HTML & CSS
Quiz
•
10th - 12th Grade
25 questions
INFORMATIKA DAN KETERAMPILAN GENERIK KELAS X
Quiz
•
10th Grade
25 questions
PAS GENAP - PKK-KJ
Quiz
•
10th Grade
25 questions
MCS Summer Camp Quizizz
Quiz
•
KG - 12th Grade
25 questions
Power point
Quiz
•
10th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
