ANALISA DATA KELAS 8D 2024

ANALISA DATA KELAS 8D 2024

8th Grade

10 Qs

quiz-placeholder

Similar activities

Spreadsheet Charts & Advanced Functions

Spreadsheet Charts & Advanced Functions

6th - 8th Grade

11 Qs

Google Sheets

Google Sheets

8th Grade

13 Qs

Spreadsheet Basics & Formula

Spreadsheet Basics & Formula

6th - 8th Grade

14 Qs

Document production

Document production

7th - 10th Grade

10 Qs

運算思維二

運算思維二

8th Grade

15 Qs

Microsoft Excel Review

Microsoft Excel Review

6th - 8th Grade

15 Qs

Kuis 1.7 Informatika (Mengenal Enkripsi)

Kuis 1.7 Informatika (Mengenal Enkripsi)

8th Grade

10 Qs

Creando Gráficos en Google Sheet(@profejulio)

Creando Gráficos en Google Sheet(@profejulio)

4th - 8th Grade

10 Qs

ANALISA DATA KELAS 8D 2024

ANALISA DATA KELAS 8D 2024

Assessment

Quiz

Computers

8th Grade

Practice Problem

Hard

Created by

I Widiantara

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

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

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

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?