Spread Sheet Genap

Spread Sheet Genap

10th Grade

29 Qs

quiz-placeholder

Similar activities

Jaringan Komputer dan Internet

Jaringan Komputer dan Internet

8th Grade - University

25 Qs

UH Materi Microsoft Excel

UH Materi Microsoft Excel

10th Grade

25 Qs

SPREADSHEET Kelas X

SPREADSHEET Kelas X

10th Grade

25 Qs

CS-10 Chapter-8 DBMS Part 2: Rabin Ghimire

CS-10 Chapter-8 DBMS Part 2: Rabin Ghimire

10th Grade

24 Qs

SIMULASI KOMUNIKASI DIGITAL

SIMULASI KOMUNIKASI DIGITAL

10th Grade

30 Qs

Quiz Formatif Bab 7 : Algoritma dan Pemrograman

Quiz Formatif Bab 7 : Algoritma dan Pemrograman

7th Grade - University

25 Qs

UU ITE

UU ITE

10th Grade

25 Qs

ULANGAN HARIAN SIMDIG PENGOLAH KATA

ULANGAN HARIAN SIMDIG PENGOLAH KATA

10th Grade

25 Qs

Spread Sheet Genap

Spread Sheet Genap

Assessment

Quiz

Computers

10th Grade

Hard

Created by

Indra Priyadi

Used 97+ times

FREE Resource

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

Create a free account and access millions of resources

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

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

Already have an account?