HAVE FUN

Quiz
•
Computers
•
11th Grade
•
Medium
Wiwid Wulandari
Used 2+ times
FREE Resource
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")
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
TIN 11 - PYTHON - PHÉP TOÁN - BIỂU THỨC - CÂU LỆNH GÁN

Quiz
•
11th Grade
10 questions
Excel Quis Before Examination

Quiz
•
11th Grade
12 questions
Bab 1.4.2 - Operator Hubungan dan Operator Logikal dlm Struktur

Quiz
•
9th - 12th Grade
10 questions
Excel

Quiz
•
7th - 11th Grade
7 questions
POSTTEST APLIKASI PENGOLAH ANGKA UKIN

Quiz
•
11th Grade
15 questions
Soal Java

Quiz
•
11th Grade - University
12 questions
Excel Lanjut

Quiz
•
9th - 12th Grade
10 questions
Câu hỏi về hàm SUMIF trong Excel

Quiz
•
9th Grade - University
Popular Resources on Wayground
18 questions
Writing Launch Day 1

Lesson
•
3rd Grade
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
Discover more resources for Computers
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
40 questions
LSHS Student Handbook Review: Pages 7-9

Quiz
•
11th Grade
20 questions
Scalars, Vectors & Graphs

Quiz
•
11th Grade
62 questions
Spanish Speaking Countries, Capitals, and Locations

Quiz
•
9th - 12th Grade
10 questions
Solving Equations Opener

Quiz
•
11th Grade
20 questions
First Day of School

Quiz
•
6th - 12th Grade
21 questions
Arithmetic Sequences

Quiz
•
9th - 12th Grade