TIK _Vlookup,Match,Index dan Choose
8th Grade
•20 Qs
Similar activities
TIK KELAS 5 MICROSOFT EXCEL
1st Grade - University
•20 Qs
Types of information sources
8th - 10th Grade
•20 Qs
M1_Final_Quiz1_2017
7th - 8th Grade
•20 Qs
WE Lesson 2: Formatting, Editing & Printing
6th - 8th Grade
•20 Qs
MS EXCEL BASIC COMPUTATIONS AND FUNCTIONS
7th Grade - University
•20 Qs
Alphabetic Keys Quiz--Retake
6th - 8th Grade
•20 Qs
TEST -EXCEL 1
1st - 10th Grade
•20 Qs
PRETEST TIK KELAS 8
8th Grade
•20 Qs
TIK _Vlookup,Match,Index dan Choose
Quiz
•
Computers
•
8th Grade
•
Practice Problem
•
Medium
Sunandar Sunandar
Used 13+ times
FREE Resource
Enhance your content in a minute
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Apa tujuan utama dari mengolah data dalam aplikasi spreadsheet?
Menghapus data yang tidak diperlukan
Mengubah data menjadi informasi yang berguna
Menyimpan data dalam bentuk fisik
Menampilkan data secara acak
2.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Fungsi VLOOKUP digunakan untuk...
Mencari data secara vertikal berdasarkan nilai tertentu
Menghitung rata-rata dari suatu range
Menggabungkan dua sel menjadi satu
Menyortir data secara otomatis
3.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Fungsi MATCH dalam Excel digunakan untuk...
Mencari posisi suatu nilai dalam sebuah range
Menggabungkan beberapa teks menjadi satu
Menghitung jumlah sel yang berisi angka
Menampilkan nilai terbesar dalam suatu range
4.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Fungsi INDEX digunakan untuk...
Mengembalikan nilai dari suatu sel berdasarkan posisi baris dan kolom
Menghitung total nilai dalam suatu range
Menyortir data secara ascending
Menghapus data duplikat
5.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Fungsi CHOOSE dalam Excel digunakan untuk...
Memilih satu nilai dari daftar argumen berdasarkan nomor indeks
Menggabungkan beberapa sel menjadi satu
Menghitung jumlah sel yang berisi teks
Menyortir data secara descending
6.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
ika kita ingin mencari nilai dari tabel berdasarkan dua kriteria (baris dan kolom), fungsi apa yang dapat dikombinasikan?
VLOOKUP dan MATCH
INDEX dan MATCH
CHOOSE dan INDEX
VLOOKUP dan CHOOSE
7.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
Rumus VLOOKUP yang benar untuk mencari nilai Budi adalah...
=VLOOKUP("Budi", A1:C3, 3, FALSE)
=VLOOKUP("Budi", A1:C3, 2, TRUE)
=VLOOKUP("Budi", A1:C3, 1, FALSE)
=VLOOKUP("Budi", A1:C3, 3, TRUE)
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
20 questions
HTML Tags
Quiz
•
6th - 8th Grade
20 questions
Advanced Excel
Quiz
•
KG - University
18 questions
Home Row Keyboarding
Quiz
•
3rd - 9th Grade
21 questions
HTML-CSS
Quiz
•
8th Grade
20 questions
End of year quiz: Spreadsheet Modelling
Quiz
•
8th Grade
20 questions
Spreadsheets - Lesson 1
Quiz
•
6th - 8th Grade
20 questions
Tin học 7 Excel
Quiz
•
7th - 12th Grade
18 questions
Intro to HTML
Quiz
•
7th - 8th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade