
Google Sheets - IF
Authored by ADI SETYAWAN
Computers
11th Grade
Used 5+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika sel A1 berisi 85, maka hasil dari =IF(A1>=75, "Lulus", "Tidak Lulus") adalah:
TRUE
85
Lulus
Tidak Lulus
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi =IF(B2<60, "Remedial", "Tuntas") akan mengembalikan "Remedial" jika:
B2 = 60
B2 = 59
B2 = 75
B2 = 100
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika A1 = "Laki-laki", rumus =IF(A1="Perempuan", "Putri", "Putra") akan menghasilkan:
Putri
Perempuan
Putra
TRUE
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi =IF(A1>50, A1*2, A1/2) digunakan untuk:
Menggandakan semua nilai
Membagi semua nilai
Menggandakan jika lebih dari 50, membagi jika tidak
Selalu menghasilkan bilangan genap
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika A1 = 40, maka hasil dari =IF(A1>=60, "Tuntas", IF(A1>=40, "Remedial", "Tidak Hadir")) adalah:
Tuntas
Remedial
Tidak Hadir
Error
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika A1 = 70, rumus =IF(A1<60, "E", IF(A1<70, "C", "B")) akan menghasilkan:
C
B
E
A
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=IF(AND(A1>=70, B1>=70), "Lulus", "Tidak Lulus") akan mengembalikan "Lulus" jika:
Salah satu nilai < 70
A1 atau B1 kosong
Keduanya ≥ 70
A1 lebih dari B1
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
15 questions
HTML Quiz
Quiz
•
11th Grade - University
10 questions
Hệ Điều Hành Của Máy Tính
Quiz
•
10th Grade - University
15 questions
Uji Pemahaman Formula Excel
Quiz
•
9th Grade - University
10 questions
KTTX Tin 9-HKII
Quiz
•
9th - 12th Grade
15 questions
ASAS PEMBELAJARAN DIGITAL
Quiz
•
9th - 12th Grade
12 questions
Web II: CSS Positioning
Quiz
•
9th - 12th Grade
10 questions
CHƯƠNG TRÌNH CON BT1
Quiz
•
10th - 12th Grade
9 questions
IT
Quiz
•
9th - 12th Grade
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
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade
10 questions
Valentine's Day: History and Modern Celebration
Interactive video
•
9th - 12th Grade
11 questions
Valentine's Day Trivia
Quiz
•
8th - 12th Grade
10 questions
Factor Quadratic Expressions with Various Coefficients
Quiz
•
9th - 12th Grade
10 questions
Evaluating Piecewise Functions Practice
Quiz
•
11th Grade
18 questions
Success Strategies
Quiz
•
9th - 12th Grade