Spread Sheet Genap

Spread Sheet Genap

10th Grade

•

29 Qs

quiz-placeholder

Similar activities

quizzz 1 berfikir komputasional

quizzz 1 berfikir komputasional

10th Grade

•

25 Qs

QUIZ BAB 8: DAMPAK SOSIAL INFORMATIKA

QUIZ BAB 8: DAMPAK SOSIAL INFORMATIKA

8th Grade - University

•

25 Qs

Ulangan Harian

Ulangan Harian

10th Grade

•

25 Qs

Informatika X

Informatika X

10th Grade

•

25 Qs

Pengenalan Microsoft Power Point

Pengenalan Microsoft Power Point

10th Grade

•

25 Qs

latihan soal informatika SMALSA

latihan soal informatika SMALSA

10th Grade

•

25 Qs

PENGENALAN MICROSOFT WORD

PENGENALAN MICROSOFT WORD

7th - 12th Grade

•

25 Qs

Ulangan Harian Bab Jaringan Kelas 8

Ulangan Harian Bab Jaringan Kelas 8

8th Grade - University

•

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?