HAVE FUN
Quiz
•
Computers
•
11th Grade
•
Practice Problem
•
Medium
Wiwid Wulandari
Used 2+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Fungsi teks yang digunakan untuk mengambil sejumlah karakter dari suatu teks atau sel dimulai dari sebelah kiri adalah.......
CONCATENATE
LEFT
RIGHT
UPPER
LOWER
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Formula yang benar untuk menuliskan hasil pada cell "B2" adalah....
=LEN(A1;4)
=LOWER(A2;4)
=MID(A2;4)
=REPT(A2;4)
=LEFT(A2;4)
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Rumus yang digunakan untuk hasil pada B2 adalah......
=ROUND(B2;2)
=ROUNDUP(B2;2)
=ROUNDUP(B2;3)
=ROUNDDOWN(B2;2)
=ROUNDDOWN(B2;3)
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Rumus yang tepat untuk cell "B2" adalah....
=MID(A2;5;4)
=MID(A2;4;5)
=LEFT(A2;3)
=RIGHT(A2;3)
=MID(A2;3;4)
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Rumus/ formula Ms. Excel pada cell "B6" yang tepat adalah....
=AVERAGE(B2:B5)
=AVERAGE(C2:C5)
=MIN(B2:B5)
=SUM(C2:C5)
=SUM(B2:B5)
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Formula yang tepat digunakan untuk menentukan hasil pada cell "C2" yaitu..........
=IF(OR(A2<50;B2>60);"LULUS";"GAGAL")
=IF(OR(A2<50;B2<60);"LULUS";"GAGAL")
=IF(OR(A2>50;B2>60);"LULUS";"GAGAL")
=IF(OR(A2<70;B2<60);"LULUS";"GAGAL")
=IF(OR(A2>50;B2<60);"LULUS";"GAGAL")
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Fungsi yang tepat untuk semua hasil pada kolom keterangan yaitu......
=IF(A3<50;"LULUS";"GAGAL")
=IF(A2>=50;"LULUS";"GAGAL")
=IF(A6>=80;"LULUS";"GAGAL")
=IF(A5>=40;"LULUS";"GAGAL")
=IF(A4<=50;"LULUS";"GAGAL")
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
Основы программирования на языке Паскаль
Quiz
•
8th - 11th Grade
12 questions
Clase de Computación: Excel
Quiz
•
11th Grade
13 questions
Pengenalan Aplikasi Blender
Quiz
•
11th Grade
10 questions
Programming with C++
Quiz
•
9th - 12th Grade
10 questions
10 câu kiểu xâu tiết 1
Quiz
•
11th Grade
15 questions
Fungsi Agregasi
Quiz
•
11th Grade
10 questions
KIỂM TRA TRẮC NGHIỆM BÀI 15 TIN HỌC 11
Quiz
•
11th Grade
8 questions
Excel
Quiz
•
1st - 12th Grade
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
