Quiz Fungsi Excel
12th Grade
•50 Qs
Similar activities
untitled
10th - 12th Grade
•50 Qs
IT Essentials — Pengoperasian Windows (Kelas XI TKJ 2,5)
12th Grade
•50 Qs
PERSIAPAN UNBK TKR PAKET 1
12th Grade
•50 Qs
Soal Latihan Kelas 7
12th Grade
•47 Qs
TRY OUT KE -3 TEORI KEJURUAN TKRO
12th Grade - University
•50 Qs
antarmuka kelas 7
7th Grade - University
•51 Qs
Ujian Sekolah Teori Kejuruan TKRO 1
9th - 12th Grade
•45 Qs
Simulasi dan Digital Komunikasi Digital
9th - 12th Grade
•50 Qs
Quiz Fungsi Excel
Quiz
•
Instructional Technology
•
12th Grade
•
Practice Problem
•
Easy
BUNGA BARIMBING
Used 5+ times
FREE Resource
Enhance your content in a minute
50 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Fungsi apa yang digunakan untuk mencari nilai di kolom pertama dan mengembalikan nilai di kolom lain berdasarkan posisi yang sesuai?
SUM
VLOOKUP
IF
CONCATENATE
COUNTIF
2.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Fungsi VLOOKUP mencari nilai berdasarkan kecocokan yang:
Tepat
Kira-kira
Di atas atau di bawah
Semua jawaban benar
Tidak relevan
3.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Fungsi yang digunakan untuk mencari nilai di baris pertama dan mengembalikan nilai dari baris lain adalah:
VLOOKUP
HLOOKUP
INDEX
MATCH
SUM
4.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Fungsi IF digunakan untuk:
Menghitung rata-rata
Membandingkan dua nilai
Menggabungkan teks
Menentukan nilai berdasarkan kondisi tertentu
Menjumlahkan angka
5.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Dalam fungsi IF, jika kondisi yang diberikan bernilai TRUE, maka hasil yang dikembalikan adalah:
Nilai kedua
Nilai pertama
Nilai ketiga
Nilai yang tidak dapat diprediksi
Sel kosong
6.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Fungsi yang digunakan untuk mengambil sejumlah karakter dari awal sebuah teks adalah:
RIGHT
LEFT
MID
CONCATENATE
SUM
7.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Fungsi RIGHT digunakan untuk:
Mengambil karakter dari awal teks
Menghitung jumlah karakter
Mengambil karakter dari akhir teks
Mengubah teks menjadi angka
Menghitung rata-rata
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
Already have an account?
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
Discover more resources for Instructional Technology
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
28 questions
Ser vs estar
Quiz
•
9th - 12th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
20 questions
Christmas Trivia
Quiz
•
5th - 12th Grade
20 questions
Stages of Meiosis
Quiz
•
9th - 12th Grade
11 questions
Solve Systems of Equations and Inequalities
Quiz
•
9th - 12th Grade
16 questions
AP Biology: Unit 2 Review (CED)
Quiz
•
9th - 12th Grade
20 questions
Winter Jokes
Quiz
•
5th - 12th Grade