Vlookup dan Hlookup Quiz

Vlookup dan Hlookup

Quiz

•

Information Technology (IT)

•

8th Grade

•

Hard

JAJANG HUMAEDI

Used 24+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Vlookup dipakai jika range data atau tabel disusun secara ...

Vertikal

Horizontal

Diagonal

Miring

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Hlookup dipakai jika range data atau tabel disusun secara ...

Vertikal

Horizontal

Diagonal

Miring

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Perhatikan rumus Vlookup di bawah ini!

=vlookup(lookup_value;table_array;col_index_num;0)

Berdasarkan rumus di atas, pengertian dari lookup_value adalah ...

Nilai yang akan dicari di dalam tabel

tabel yang berisi data yang dicari

nomor kolom yang akan diambil datanya

Semua Jawaban Benar

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Perhatikan rumus Vlookup di bawah ini!

=vlookup(lookup_value;table_array;col_index_num;0)

Berdasarkan rumus di atas, pengertian dari table_array adalah ...

Nilai yang akan dicari di dalam tabel

tabel yang berisi data yang dicari

nomor kolom yang akan diambil datanya

Semua Jawaban Benar

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Perhatikan rumus Vlookup di bawah ini!

=vlookup(lookup_value;table_array;col_index_num;0)

Berdasarkan rumus di atas, pengertian dari col_index_num adalah ...

Nilai yang akan dicari di dalam tabel

tabel yang berisi data yang dicari

nomor kolom yang akan diambil datanya

Semua Jawaban Benar

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Perhatikan rumus Hlookup di bawah ini!

=hlookup(lookup_value;table_array;row_index_num;0)

Berdasarkan rumus di atas, pengertian dari row_index_num adalah ...

Nilai yang akan dicari di dalam tabel

nomor baris yang akan diambil datanya

nomor kolom yang akan diambil datanya

Semua Jawaban Benar

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Perhatikan gambar di samping ini!

Berdasarkan gambar di samping, lookup_value pada rumus tersebut adalah ...

Cell E6

Cell E7

Cell E8

Cell E9

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

Apple

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

15 questions

Informatika kelas 8 semester 2

Quiz

•

8th Grade

10 questions

Asesmen Formatif Berpikir Komputasional

Quiz

•

6th - 8th Grade

15 questions

UJI COBA QUIZ

Quiz

•

8th Grade

10 questions

INFORMATIKA

Quiz

•

8th Grade

15 questions

Microsoft Word

Quiz

•

4th Grade - University

15 questions

SAS informatika kelas 8 S2

Quiz

•

8th Grade - University

10 questions

IF THEN KELAS 6

Quiz

•

6th - 8th Grade

10 questions

Python Data Visualization Dashboard

Quiz

•

8th Grade

Popular Resources on Wayground

20 questions

Halloween Trivia

Quiz

•

6th - 8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

15 questions

Order of Operations

Quiz

•

5th Grade

20 questions

Halloween

Quiz

•

5th Grade

16 questions

Halloween

Quiz

•

3rd Grade

12 questions

It's The Great Pumpkin Charlie Brown

Quiz

•

1st - 5th Grade

20 questions

Possessive Nouns

Quiz

•

5th Grade

10 questions

Halloween Traditions and Origins

Interactive video

•

5th - 10th Grade

Discover more resources for Information Technology (IT)

20 questions

Halloween Trivia

Quiz

•

6th - 8th Grade

10 questions

Halloween Traditions and Origins

Interactive video

•

5th - 10th Grade

12 questions

Digital Citizenship BSMS

Quiz

•

6th - 8th Grade

20 questions

Physical and Chemical Changes

Quiz

•

8th Grade

20 questions

Halloween movies trivia

Quiz

•

7th - 12th Grade

15 questions

Halloween History Trivia

Quiz

•

7th - 8th Grade

15 questions

Halloween Characters

Quiz

•

7th - 12th Grade

10 questions

Halloween Movies Trivia

Quiz

•

5th Grade - University