HAVE FUN
11th Grade
•10 Qs
Similar activities
Informática
11th Grade
•15 Qs
Google Sheets - Aritmatika dan $
11th Grade
•10 Qs
Funções do Google Planilhas
8th Grade - University
•15 Qs
PERULANGAN Quiz
9th - 12th Grade
•5 Qs
Excel Lanjut
9th - 12th Grade
•12 Qs
Parcial I - I Unidad - Quinto Perito Contador(5to. PC) -CIA - Evaluación de Excel
11th Grade
•13 Qs
Y7Spreadsheet Homework 1 Quiz
6th Grade - University
•15 Qs
Fungsi Dasar pada Microsoft Excel
11th Grade
•15 Qs
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
Les Tableurs ( Microsoft Excel ) 1
Quiz
•
6th - 12th Grade
10 questions
Asesmen Awal Pengolah Data Dasar
Quiz
•
7th Grade - University
10 questions
Post-Test Algoritma dan Pemrograman
Quiz
•
10th Grade - University
10 questions
BÀI 11A. SỬ DỤNG HÀM SUMIF
Quiz
•
9th Grade - University
10 questions
Hàm Thống Kê - Hàm Value
Quiz
•
11th - 12th Grade
10 questions
MICROSOFT EXCEL
Quiz
•
9th - 11th Grade
10 questions
Logical Function
Quiz
•
9th - 12th Grade
14 questions
S1 Spreadsheets Functions/Formulae
Quiz
•
7th - 11th Grade
Popular Resources on Wayground
10 questions
Video Games
Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines
Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22
Lesson
•
9th - 12th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
20 questions
US Constitution Quiz
Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade