Fungsi teks yang digunakan untuk mengambil sejumlah karakter dari suatu teks atau sel dimulai dari sebelah kiri adalah.......
HAVE FUN
11th Grade
•10 Qs
Similar activities
Excel Básico [02]
7th Grade - Professional Development
•15 Qs
Excel
7th - 11th Grade
•10 Qs
HTML Text Formatng
11th Grade
•10 Qs
Diagnostik Rumus IF
9th - 12th Grade
•14 Qs
Soal Java
11th Grade - University
•15 Qs
Câu hỏi về hàm SUMIF trong Excel
9th Grade - University
•10 Qs
Excel
11th - 12th Grade
•13 Qs
Ինֆորմատիկա-մաթեմատիկա
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
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
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Quizizz
12 questions
Excel: more functions
Quiz
•
9th - 12th Grade
10 questions
Google Sheets - IF
Quiz
•
11th Grade
15 questions
Entendendo funções no Excel
Quiz
•
10th - 12th Grade
8 questions
Excel
Quiz
•
1st - 12th Grade
10 questions
XI - Kuis AP 1
Quiz
•
11th Grade
12 questions
Excel Lanjut
Quiz
•
9th - 12th Grade
12 questions
7 клас Підсумковий тест з інформатики
Quiz
•
1st - 12th Grade
9 questions
Asesmen PHP IF
Quiz
•
11th Grade
Popular Resources on Quizizz
15 questions
Character Analysis
Quiz
•
4th Grade
17 questions
Chapter 12 - Doing the Right Thing
Quiz
•
9th - 12th Grade
10 questions
American Flag
Quiz
•
1st - 2nd Grade
20 questions
Reading Comprehension
Quiz
•
5th Grade
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
18 questions
Full S.T.E.A.M. Ahead Summer Academy Pre-Test 24-25
Quiz
•
5th Grade
14 questions
Misplaced and Dangling Modifiers
Quiz
•
6th - 8th Grade
Discover more resources for Computers
17 questions
Chapter 12 - Doing the Right Thing
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Taxes
Quiz
•
9th - 12th Grade
17 questions
Parts of Speech
Quiz
•
7th - 12th Grade
20 questions
Chapter 3 - Making a Good Impression
Quiz
•
9th - 12th Grade
20 questions
Inequalities Graphing
Quiz
•
9th - 12th Grade
10 questions
Identifying equations
Quiz
•
KG - University