Search Header Logo

PH KELAS 8

Authored by ARROYYAN BARA

Computers

7th Grade

Used 8+ times

PH KELAS 8
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

50 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Fungsi HLOOKUP digunakan untuk mencari nilai secara...

Vertikal

Horizontal

Diagonal

Acak

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Fungsi VLOOKUP digunakan untuk mencari nilai di...

Baris pertama tabel

Kolom pertama tabel

Sel terakhir tabel

Sel acak tabel

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Sintaks yang benar untuk fungsi HLOOKUP adalah...

=HLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

=HLOOKUP(lookup_value, table_array, row_index_num)

=HLOOKUP(lookup_value, table_array, col_index_num)

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Jika =VLOOKUP("A001", A1:D10, 3, FALSE) digunakan, artinya Excel akan mencari nilai "A001" di...

Baris pertama tabel A1:D10

Kolom pertama tabel A1:D10

Kolom ketiga tabel A1:D10

Baris ketiga tabel A1:D10

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Jika range_lookup diisi dengan TRUE pada fungsi VLOOKUP, artinya Excel akan mencari nilai yang...

Tepat sama

Terdekat

Lebih besar

Lebih kecil

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Fungsi HLOOKUP mencari nilai di...

Kolom pertama tabel

Baris pertama tabel

Sel terakhir tabel

Sel acak tabel

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Jika =HLOOKUP("Nama", A1:D4, 2, FALSE) digunakan, artinya Excel akan mengembalikan nilai dari...

Baris pertama

Baris kedua

Kolom pertama

Kolom kedua

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?