spread sheet kelas x

spread sheet kelas x

1st Grade

25 Qs

quiz-placeholder

Similar activities

PTS PROGDAS

PTS PROGDAS

1st Grade - University

20 Qs

TEKNOLOGI LAYANAN JARINGAN

TEKNOLOGI LAYANAN JARINGAN

1st - 12th Grade

20 Qs

Kuis Search Engine

Kuis Search Engine

1st Grade - Professional Development

20 Qs

Data Mining

Data Mining

1st - 5th Grade

20 Qs

ULANGAN 1 BASIS DATA KELAS XII RPL

ULANGAN 1 BASIS DATA KELAS XII RPL

1st - 10th Grade

20 Qs

Ôn Tập Các Hàm Trong Excel

Ôn Tập Các Hàm Trong Excel

KG - Professional Development

20 Qs

Metaverse

Metaverse

1st - 3rd Grade

20 Qs

SIMDIG - PENGOLAH KATA

SIMDIG - PENGOLAH KATA

KG - 10th Grade

20 Qs

spread sheet kelas x

spread sheet kelas x

Assessment

Quiz

Computers

1st Grade

Practice Problem

Hard

Created by

bayu handono

Used 18+ times

FREE Resource

AI

Enhance your content in a minute

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

25 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

Already have an account?