Spread Sheet Genap

Spread Sheet Genap

10th Grade

•

29 Qs

quiz-placeholder

Similar activities

Sumatif Tengah Semester Ganjil-Informatika

Sumatif Tengah Semester Ganjil-Informatika

10th Grade

•

25 Qs

Latihan 1

Latihan 1

10th Grade

•

25 Qs

SPREADSHEET

SPREADSHEET

10th Grade

•

25 Qs

Microsoft Word

Microsoft Word

10th - 12th Grade

•

25 Qs

PH BAB 6 - A

PH BAB 6 - A

9th - 12th Grade

•

27 Qs

Remidi DKK-A

Remidi DKK-A

9th - 12th Grade

•

25 Qs

Bepikir Komputasional Kelas-X

Bepikir Komputasional Kelas-X

10th Grade

•

30 Qs

Assesmen Sem Genap Informatika

Assesmen Sem Genap Informatika

10th Grade

•

25 Qs

Spread Sheet Genap

Spread Sheet Genap

Assessment

Quiz

•

Computers

•

10th Grade

•

Practice Problem

•

Hard

Created by

Indra Priyadi

Used 97+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

29 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Fungsi yang digunakan untuk membaca table secara vertikal yang benar adalah....

=IF

=DDB

=CREAT

=VLOOKUP

=HLOOKUP

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

"Lookup_value" pada penulisan fungsi VLOOKUP adalah untuk menyatakan....

alamat cell pembanding

range tabel array

alamat cell hasil

nomor urut dalam table

nama tabel data

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Penulisan fungsi VLOOKUP yang benar adalah....

=VLOOKUP(lookup_value;Tabel_array;Col_index_num:Range_lookup)

=VLOOKUP(lookup_value:Tabel_array,Col_index_num;Range_lookup)

=VLOOKUP(lookup_value;Tabel_array;Col_index_num;Range_lookup)

=VLOOKUP(lookup_value:Tabel_array;Col_index_num;Range_lookup)

=VLOOKUP(lookup_value;Tabel_array,Col_index_num,Range_lookup)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Untuk menghitung jumlah data cell dalam sebuah tabel digunakan fungsi....

SUMIF

SUM

COUNT

COUNTA

COUNTIF

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Nama range tabel yang akan dibaca adalah....

lookup_value

table_array

col_index_num

row_index_num

range_lookup

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Fungsi VLOOKUP adalah fungsi untuk....

pembacaan tabel

pembacaan tabel secara horizontal

pembacaan tabel secara vertikal

pembacaan data secara acak

pembacaan tabel secara vertical maupun horizontal

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Argumen yang akan menentukan tingkat ketepatan pembacaan adalah....

lookup_value

table_array

col_index_num

row_index_num

range_lookup

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?