Search Header Logo

POST TEST HLOOKUP VLOOKUP

Authored by Rosma Lianti

Computers

12th Grade

Used 4+ times

POST TEST HLOOKUP VLOOKUP
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

6 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 15 pts

Jenis fungsi lookup yang datanya tersusun secara koordinat X horizontal adalah?

VLOOKUP

HLOOKUP

COUNTIF

MATCH

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Perhatikan tabel berikut!

Untuk mengisi sel D3 (JUMLAH), rumus yang digunakan adalah?

=Vlookup(B3;$A$11:$C$13;3)

=Hlookup(B3;$A$11:$C$13;3)

=Vlookup(B3;$A$11:$C$13;2)

=Vlookup(B3;$A$11:$C$13;2)

3.

MULTIPLE CHOICE QUESTION

1 min • 20 pts

Media Image

Perhatikan tabel di atas ! Jika pada baris “ISI” diisi dengan rumus =VLOOKUP(A3,$A$2:$C$5,3)

Maka apa yang akan muncul?

Rp. 1.500.000

HANI

Rp. 1.000.000

GANJAR

4.

MULTIPLE CHOICE QUESTION

30 sec • 15 pts

Bentuk umum penulisan fungsi =Vlookup( ) adalah …

=Vlookup(range tabel, kunci, kolom ke)

=Vlookup( kolom ke, kunci, range tabel)

=Vlookup(kunci, range tabel, kolom ke)

=Vlookup(kolom ke, range tabel, kunci)

5.

MULTIPLE CHOICE QUESTION

1 min • 15 pts

Media Image

Perhatikan tabel di samping!

Untuk mengisi sel C3 (NAMA BARANG), rumus yang digunakan adalah?

=Hlookup(B3;$A$11:$C$13;2)

=Vlookup(B3;$A$11:$C$13;1)

=Vlookup(B3;$A$11:$C$13;3)

=Vlookup(B3;$A$11:$C$13;2)

6.

MULTIPLE CHOICE QUESTION

1 min • 20 pts

Media Image

Perhatikan tabel di atas ! Jika pada baris “ISI” diisi dengan rumus =VLOOKUP(A2;$A$2:$C2;2)

 Maka apa yang akan muncul?

Rp. 1.000.000

GANJAR

Rp. 1.500.000

HANI

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?