ANALISA DATA KELAS 8D 2024

ANALISA DATA KELAS 8D 2024

8th Grade

10 Qs

quiz-placeholder

Similar activities

Google Sheets basics

Google Sheets basics

6th - 8th Grade

12 Qs

Excel If function WSC 4.2.3

Excel If function WSC 4.2.3

7th Grade - University

10 Qs

ÔN TẬP GIỮA HKI (2) - Tin 8

ÔN TẬP GIỮA HKI (2) - Tin 8

8th Grade

10 Qs

Aplikasi Pengolah angka

Aplikasi Pengolah angka

8th Grade

15 Qs

9 сынып Сүзгілеу

9 сынып Сүзгілеу

8th Grade

15 Qs

Robot Design

Robot Design

6th - 8th Grade

13 Qs

INFORMÁTICA: Quem sabe mais?

INFORMÁTICA: Quem sabe mais?

KG - Professional Development

15 Qs

Spreadsheets

Spreadsheets

1st - 12th Grade

15 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

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

Already have an account?