KUIS EXCEL - Logika IF
Authored by ypa labpuskom
Other
8th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
8 questions
Show all answers
1.
OPEN ENDED QUESTION
5 mins • 20 pts
Tulislah rumus pada kolom LOKASI TRIBUN menggunakan rumus IF dengan ketentuan:
Jika kode tiket adalah T maka lokasi tribun berada di "Bagian Timur" sedangkan kode B adalah "Bagian Barat"
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
5 mins • 20 pts
Jika pada kolom HARGA TIKET dituliskan rumus =IF(B2="B",100000,50000), maka harga tiket untuk kode tiket T adalah ... .
Evaluate responses using AI:
OFF
3.
OPEN ENDED QUESTION
5 mins • 20 pts
Jelaskan perbedaan fungsi rumus COUNT dan COUNTIF pada Excel!
Evaluate responses using AI:
OFF
4.
DRAW QUESTION
5 mins • 1 pt
Tanda pertidaksamaan yang digunakan untuk menuliskan rumus dengan kondisi "Jika karyawan memiliki gaji pokok diatas 1.000.000 rupiah, maka termasuk ke dalam golongan D"
5.
DRAW QUESTION
5 mins • 1 pt
Tanda pertidaksamaan yang digunakan untuk menuliskan rumus dengan kondisi "Jika karyawan memiliki gaji pokok 1.000.000 rupiah atau lebih, maka termasuk ke dalam golongan D"
6.
DRAW QUESTION
5 mins • 1 pt
Penulisan rumus di dalam formula bar yang harus ada di awal penulisan adalah tanda ...
7.
OPEN ENDED QUESTION
5 mins • 1 pt
=IF(B5>89,"A",IF(B5>70,"B","C")
Tanda yang kurang di dalam penulisan rumus tersebut adalah ... .
Evaluate responses using AI:
OFF
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
10 questions
Statistika
Quiz
•
8th Grade
10 questions
PRETEST-Iklan-Poster-Slogan-BAHASA-INDONESIA
Quiz
•
8th Grade
10 questions
Latihan Drama 1
Quiz
•
8th Grade
10 questions
Kuis seputar bahasa Indonesia
Quiz
•
8th Grade
10 questions
AKHLAK TAHUN 4 - PENTAKSIRAN 2
Quiz
•
7th - 12th Grade
10 questions
Mudik Ramadhan
Quiz
•
1st Grade - Professio...
10 questions
PRETEST
Quiz
•
8th Grade
11 questions
How well do you know your school
Quiz
•
8th Grade
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
Discover more resources for Other
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
7 questions
SMS Playground Expectations Quiz
Quiz
•
6th - 8th Grade
16 questions
Mario Trivia Challenge
Quiz
•
6th - 8th Grade
14 questions
SMS Car & Bus Expectations Quiz
Quiz
•
6th - 8th Grade
20 questions
Scatter Plots and Line of Best Fit
Quiz
•
8th Grade
12 questions
8th U6 L4 - Fitting a Line to Data
Quiz
•
8th Grade
22 questions
Phases of the moon
Quiz
•
8th Grade