Kuis ke 5
University
•29 Qs
Similar activities
TechZoom24-BugBash_Prelims
University
•25 Qs
Web Application Frameworks
University
•25 Qs
Kelas IoT_
University
•25 Qs
Fourth Grade March Rivision
4th Grade - University
•24 Qs
Python Module 1
University
•25 Qs
PYTHON CONTEST
University
•25 Qs
SQL MIDTERM EXAM
University
•25 Qs
NETZKNOTEN (Web Designing)
University
•25 Qs
Kuis ke 5
Quiz
•
Computers
•
University
•
Practice Problem
•
Hard
mizanul itidal
Used 13+ times
FREE Resource
Enhance your content in a minute
29 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pada Sel E7 terdapat syarat yaitu, jika mendapatkan nilai 82 ke atas maka akan LULUS dan jika mendapatkan nilai di bawah 82 makan akan GAGAL. Rumus logika yang digunakan dengan syarat tersebut adalah ...
=IF(E7>82;"LULUS";"GAGAL")
=IF(E7>=82;"LULUS";"GAGAL")
=IF(E7<82;"LULUS";"GAGAL")
=IF(E7>82;"LULUS";IF(E7<82"GAGAL")
2.
FILL IN THE BLANK QUESTION
30 sec • 1 pt
Perhatikan gambar di atas! Tuliskan rumus fungsi IF untuk mengisi kolom Grade dengan ketentuan:
Grade A for Marks 90 – 100,
Grade B for marks 80 – 89,
Grade C for marks 70 – 79,
Grade D for marks 60 – 69,
Grade E for < 60
3.
FILL IN THE BLANK QUESTION
30 sec • 1 pt
Perhatikan gambar pada tabel di atas!
Tuliskan fungsi IF untuk mengisi kolom "Status" dengan ketentuan:
Status : if grade > 75 is Complete, if grade < 75 is Failed
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
(klik soal untuk membesarkan gbr ) !. Agar penulisannya benar dengan standar lolos remidi punya nilai di atas 70, maka penulisan rumus di D5 adalah..........
=IF(C5<70;"REMIDI";"LOLOS") enter
=IF(D5<70;"REMIDI";"LOLOS") enter
=IF(A5<70;"REMIDI";"LOLOS") enter
=IF(B5<70;"REMIDI";"LOLOS") enter
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi IF merupakan fungsi ...
Logika
Matematika dasar
Teks
Excel
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perintah Jika Benar akan dilaksanakan jika ....
logika benar
logika salah
logika lebih besar
logika lebih kecil
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Sel A1 beisi teks SAYA
jika kita membuat rumus =if(A1="SAYA",45+45,45+54)
akan menghasilkan nilai ...
90
99
45
54
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
[Pre-Assessment]Networking 1
Quiz
•
University
25 questions
Basic GIS, RS, Photogrammetry
Quiz
•
University - Professi...
25 questions
CSS
Quiz
•
9th Grade - University
25 questions
Quiz Formatif Bab 7 : Algoritma dan Pemrograman
Quiz
•
7th Grade - University
26 questions
ASM452
Quiz
•
University
29 questions
COMPTIA ITF
Quiz
•
1st Grade - Professio...
25 questions
Internet
Quiz
•
University
25 questions
Tema 2 Programación Básica
Quiz
•
University
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade