ANALISA DATA KELAS 8D 2024

ANALISA DATA KELAS 8D 2024

8th Grade

10 Qs

quiz-placeholder

Similar activities

Octavo A

Octavo A

8th Grade

12 Qs

Câu hỏi Trắc Nghiệm Tin Học 8

Câu hỏi Trắc Nghiệm Tin Học 8

8th Grade

10 Qs

Microsoft Functions

Microsoft Functions

6th - 9th Grade

11 Qs

Электронные таблицы. Основные понятия.

Электронные таблицы. Основные понятия.

5th - 11th Grade

10 Qs

MS Excel - kl.8

MS Excel - kl.8

8th Grade

14 Qs

الجداول الحسابية

الجداول الحسابية

8th Grade

12 Qs

Basic Mathematical Formula in MS office excel

Basic Mathematical Formula in MS office excel

8th Grade

10 Qs

Factor Cubic Equations

Factor Cubic Equations

3rd - 9th Grade

15 Qs

ANALISA DATA KELAS 8D 2024

ANALISA DATA KELAS 8D 2024

Assessment

Quiz

Computers

8th Grade

Hard

Created by

I Widiantara

Used 3+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image
  1. Perhatikan gambar di bawah ini! Pada cell C2 rumusnya adalah ...

=VLOOKUP(B2,B6:C9,2,FALSE)

=VLOOKUP(B2,B6:C9,2)

=HLOOKUP(B2,B6:C9,2,FALSE)

=HLOOKUP(B2,B6:C9,2)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image
  1. Perhatikan gambar di bawah ini! Pada cell C3 rumusnya adalah ...

=VLOOKUP(B3,B6:C9,2,FALSE)

=VLOOKUP(C2,B6:C9,2)

=HLOOKUP(C2,B6:C9,2,FALSE)

=HLOOKUP(B2,B6:C9,2)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image
  1. Perhatikan gambar berikut! Bagaimana fungsi untuk mencari nilai di D13!

=HLOOKUP(C13,B17:E18,2,FALSE)

=HLOOKUP(C13,B17:E18,2,TRUE)

=VLOOKUP(C13,B17:E18,2,FALSE)

=VLOOKUP(C13,B17:E18,2,TRUE)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image
  1. Perhatikan gambar berikut! Bagaimana fungsi untuk mencari nilai di D14!

=HLOOKUP(C14,B17:E18,2,FALSE)

=HLOOKUP(C14,B17:E18,2,TRUE)

=VLOOKUP(C14,B17:E18,2,FALSE)

=VLOOKUP(C14,B17:E18,2,TRUE)

5.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Apa isi dari g2 (berupa formula) jika ditanyakan total harga dengan kriteria Ana dan Buku?

6.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Apa isi dari g2 jika ditanyakan total harga dengan kriteria Ana dan Buku?

7.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Apa isi dari h2 (berupa formula) jika ditanyakan jumlah data dengan kriteria Ana dan Buku?

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?