KTE - 03 - Basic Functions and Formulas
Quiz
•
Other
•
Professional Development
•
Medium
ini bossexcel
Used 2+ times
FREE Resource
Enhance your content
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus untuk menjumlahkan dengan lebih dari satu KONDISI adalah..
AVERAGEIFS
SUMIF
SUMIFS
SUM
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan sel yang ter-highlight kuning. Rumus yang tidak bisa digunakan untuk sel ini adalah...
VLOOKUP
HLOOKUP
LOOKUP
XLOOKUP
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Kalau Mimin sudah mencuci piring dan menjemur pakaian, Mimin boleh menonton TV. Illustrasi ini bisa dituliskan dalam Excel menggunakan kombinasi rumus..
IFERROR dan VLOOKUP
OR dan AND
IF dan OR
IF dan AND
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Ada berapa tipe [match_type] dalam rumus MATCH?
1
2
3
Rumus MATCH tidak mempunyai [math_type]
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dalam membuat IF Bertingkat (Nested IF), jika terdapat 5 pilihan, berapa jumlah IF yang diperlukan di dalam rumus?
3
4
5
6
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Functions di bawah ini digunakan untuk menggabungkan kata/value, kecuali...
CONCAT
CONCATENATE
TEXTJOIN
TEXTSPLIT
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Keyboard Shortcut untuk Flash Fill adalah...
Ctrl + B
Ctrl + P
Ctrl + FF
Ctrl + E
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
10 questions
PERSUASIVE SELLING FORMAT
Quiz
•
Professional Development
10 questions
BCA - Leading Self
Quiz
•
Professional Development
15 questions
BRIlian QUIZ
Quiz
•
Professional Development
15 questions
Kuis Rapat Pembinaan Agustus 2023
Quiz
•
Professional Development
10 questions
Mengenal AKMI
Quiz
•
Professional Development
11 questions
APEL KESIAPAN KERJA TAHUN 2023
Quiz
•
Professional Development
10 questions
Permainan Tradisi Brunei
Quiz
•
KG - Professional Dev...
10 questions
REFLEKSI WEBINAR LITNUM SD
Quiz
•
Professional Development
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
11 questions
NEASC Extended Advisory
Lesson
•
9th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
20 questions
Multiplying and Dividing Integers
Quiz
•
7th Grade
