Kuis ke 5
Authored by mizanul itidal
Computers
University
Used 13+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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
SQL MIDTERM EXAM
Quiz
•
University
25 questions
Stack and Queue
Quiz
•
University
28 questions
MAWD 1.01 B
Quiz
•
KG - University
24 questions
Fourth Grade March Rivision
Quiz
•
4th Grade - University
25 questions
BSCE_MIDTERM_EXAM
Quiz
•
University
25 questions
Python Module 1
Quiz
•
University
25 questions
PYTHON CONTEST
Quiz
•
University
25 questions
Set Theory Quiz
Quiz
•
University
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
5 questions
What is Presidents' Day?
Interactive video
•
10th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
20 questions
Mardi Gras History
Quiz
•
6th Grade - University
10 questions
The Roaring 20's Crash Course US History
Interactive video
•
11th Grade - University
17 questions
Review9_TEACHER
Quiz
•
University