Post Test Excel Logika IF
10th Grade
•10 Qs
Similar activities
Microsoft Excel (Basic Formula)
10th Grade
•10 Qs
TIK-Ms Excel
10th Grade
•10 Qs
3.7 Fungsi Date & Time
10th Grade
•10 Qs
Excel 2016 perusteet
10th Grade
•12 Qs
Processors Quiz (Medium Level)
6th - 10th Grade
•10 Qs
Excel Intermedio [01]
7th Grade - Professional Development
•11 Qs
Funciones en Hojas de Cálculo (básico)
10th Grade
•15 Qs
Funcion CONVERTIR - Google Sheets
KG - Professional Development
•11 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
Similar Resources on Wayground
10 questions
PRETEST MS EXCEL
Quiz
•
10th Grade
10 questions
Microsoft Excel Quiz 1
Quiz
•
10th Grade
10 questions
Формулы в Excel
Quiz
•
9th - 10th Grade
10 questions
Adresowanie bezwzględne
Quiz
•
KG - 12th Grade
12 questions
Excel: more functions
Quiz
•
9th - 12th Grade
15 questions
Google Spreadsheet
Quiz
•
9th - 12th Grade
10 questions
Относительные, абсолютные, смешанные ссылки
Quiz
•
9th - 12th Grade
5 questions
Recap-Sum() function
Quiz
•
8th - 12th Grade
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
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
10 questions
Proper Keyboarding Techniques
Interactive video
•
6th - 10th Grade
10 questions
Understanding Computers: Hardware, Software, and Operating Systems
Interactive video
•
7th - 12th Grade
29 questions
AP CSP Unit 2 Review (Code.org)
Quiz
•
10th - 12th Grade