New game
Download
SCORM download
To be used in an LMS (Moodle, Blackboard...)
Regular download
To be published on a website or blog.
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.
Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.
Get Academic Plan
If you wish, you can download a demo game here and test its integration:
Share game
Quiz
Quiz

Kuis Analisis Data & Lookup

Integrate it into your platform
G. Classroom M. Teams
You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

Get Academic Plan

Kuis Analisis Data & Lookup

Quiz

Played 1 %Accuracy 78 Average time 05:03
Create copy

About this activity

Kuasai VLOOKUP, HLOOKUP & Lookup

Created by

SUTRA KASIH
SUTRA KASIH
Indonesia

Download the paper version to play

Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game
Make challenge

Top Games

 %
Anonymous
Anonymous
 %
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Print your game
Kuis Analisis Data & Lookup
 

Kuis Analisis Data & LookupOnline version

Kuasai VLOOKUP, HLOOKUP & Lookup

by SUTRA KASIH
1

Apa fungsi utama VLOOKUP?

2

Apa perbedaan utama antara VLOOKUP dan HLOOKUP?

3

Apa kegunaan umum LOOKUP dalam analisis data?

4

Mengapa kita menggunakan lookup untuk menghubungkan data antar tabel?

5

Sebutkan batasan utama VLOOKUP.

6

Bagaimana cara menggunakan HLOOKUP jika baris kunci berada di baris pertama?

7

Kapan lebih tepat pakai HLOOKUP?

8

Apa arti dasar kata LOOKUP dalam konteks data?

9

Contoh sederhana pakai VLOOKUP sehari-hari?

Feedback

VLOOKUP menggunakan kolom kunci di kiri untuk mengambil nilai dari kolom yang ditentukan.

VLOOKUP menelusuri kolom, HLOOKUP menelusuri baris untuk mendapatkan nilai.

LOOKUP berguna untuk menemukan padanan nilai yang mendekati selain pencarian tepat.

Lookup menyambungkan data antara tabel lewat kunci yang sama.

VLOOKUP hanya menelusuri dari kolom kiri menuju kanan dalam tabel.

HLOOKUP menelusuri baris pertama untuk mengambil nilai di kolom tertentu.

HLOOKUP cocok untuk tabel dengan data disusun horizontal.

LOOKUP mencari padanan nilai untuk menautkan data antara keduanya.

Gunakan VLOOKUP untuk mengambil harga dari daftar produk menggunakan kode produk sebagai kunci.

 
Are you sure you want to leave the page?

If you leave the page, you will lose your game progress.