Post Test Excel Logika IF
10th Grade
•10 Qs
Similar activities
Bài làm việc Access, cấu trúc bảng
9th - 12th Grade
•10 Qs
Soal Simulasi Ujian Daring Informatika
10th Grade
•15 Qs
Q1 W1 M1 PRE-TEST
10th Grade
•15 Qs
Ôn tập KTGK. Bài 17. Biến và lệnh gán
10th Grade
•15 Qs
Creative iMedia: Strengths, Weaknesses and Improvements
10th Grade
•11 Qs
Test Your Knowledge of HTML
9th - 12th Grade
•15 Qs
Мозгобойня
10th - 11th Grade
•14 Qs
CHƯƠNG TRÌNH CON BT1
10th - 12th Grade
•10 Qs
Post Test Excel Logika IF
Quiz
•
Computers
•
10th Grade
•
Medium
Zulfikkar Purwa Nugraha
Used 86+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 10 pts
Pada sel A2 terisi 75, dan terdapat fungsi =IF(A2<65,”C”,IF(A2<75,”B”,”C”)) maka akan memberikan hasil ...
A
B
C
A atau B
B atau C
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Sintak fungsi IF adalah ...
=IF(Pernyataan)
=IF(Pernyataan,”Jawaban”)
=IF(Pernyataan,”Pilihan Jawaban”)
=IF(Pernyataan,”Pilihan Jawaban Benar”,”Pilihan Jawaban Salah”)
=IF(Pernyataan,”Jawaban Benar”,”Jawaban Salah",0)
3.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Pada suatu sel terdapat pernyataan =IF(B3=”A”,”Anjing”,IF(B3=”B”,”Bebek”,IF(B3=”C”,”Cicak”,”Kuda”))) jika pada B3 terdapat huruf “E” maka hasil yang muncul adalah ...
Anjing
False
Cicak
Bebek
Kuda
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan perintah logika berikut ini yang benar adalah …
=IF(A5>5)5,A1=200
=IF(A1>5,A1)=”LULUS”,B1=”TIDAK”
=IF(A1>5,”SARJANA”,”SMA”)
=IF(A1>5)=”LULUS”,B1=”TIDAK”
=IF(A1>5,A1*B1,A1…B1)
5.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
=IF(B6=”J”,”JAKARTA”,….=”B”,”BANDUNG”,”SEMARANG”))
Untuk melengkapi titik-titik pada rumus di atas maka digunakan …
=IF(
IF(B6
B6
IF
=IF(B6
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Budi akan mendapat hadiah jika Budi mendapat nilai lebih dari 80 atau ranking 1.
Jika nilai = A6 dan Ranking = D6, maka rumus yang benar adalah ...
=IF(OR(A6=D6;Hadiah))
=IF(OR(A6>80;D6=1);"Hadiah";"-")
=IF(AND(A6>80;D6=1);"Hadiah";"-")
=IFOR(A6>80;D6=1);"Hadiah";"-")
=(AND(A6>80;D6=1);"Hadiah";"-")
7.
MULTIPLE CHOICE QUESTION
45 sec • 10 pts
Charly akan berlibur ke Jogja jika Charly mendapat nilai lebih dari sama dengan 90 dan usia sudah 17 tahun.
Jika nilai = A6 dan usia = D6, maka rumus yang benar adalah ...
=IF(AND(A6=D6;Hadiah))
=IF(OR(A6>80;D6=1);"Hadiah";"-")
=IF(AND(A6>=80;D6=17);"Hadiah";"-")
=IF(AND(A6>80;D6=1);"Hadiah";"-")
=(OR(A6>80;D6=1);"Hadiah";"-")
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
10 questions
KS4 Programming Techniques (1)
Quiz
•
8th - 10th Grade
10 questions
Microsoft Publisher
Quiz
•
7th - 10th Grade
10 questions
python-BTxâu
Quiz
•
9th - 12th Grade
12 questions
HTML
Quiz
•
9th - 12th Grade
10 questions
Циклы
Quiz
•
10th Grade
15 questions
Digital Etiquette
Quiz
•
4th Grade - University
10 questions
Komputer dan Jaringan Dasar Semester 2 - Implementasi dan Analisis Jaringan
Quiz
•
10th Grade
10 questions
Topologies and Architecture
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
20 questions
Halloween Trivia
Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Order of Operations
Quiz
•
5th Grade
20 questions
Halloween
Quiz
•
5th Grade
16 questions
Halloween
Quiz
•
3rd Grade
12 questions
It's The Great Pumpkin Charlie Brown
Quiz
•
1st - 5th Grade
20 questions
Possessive Nouns
Quiz
•
5th Grade
10 questions
Halloween Traditions and Origins
Interactive video
•
5th - 10th Grade
Discover more resources for Computers
10 questions
Halloween Traditions and Origins
Interactive video
•
5th - 10th Grade
20 questions
Halloween movies trivia
Quiz
•
7th - 12th Grade
15 questions
Halloween Characters
Quiz
•
7th - 12th Grade
10 questions
Halloween Movies Trivia
Quiz
•
5th Grade - University
10 questions
Halloween Trivia Challenge
Interactive video
•
6th - 10th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
14 questions
Halloween Fun
Quiz
•
2nd - 12th Grade
28 questions
Ser vs estar
Quiz
•
9th - 12th Grade