ANALISA DATA KELAS 8D 2024

ANALISA DATA KELAS 8D 2024

8th Grade

10 Qs

quiz-placeholder

Similar activities

Excel

Excel

7th - 11th Grade

10 Qs

Ինֆորմատիկա 8, 1-ին  կիսամ․ ամփոփ

Ինֆորմատիկա 8, 1-ին կիսամ․ ամփոփ

8th Grade

10 Qs

S1 Spreadsheets Functions/Formulae

S1 Spreadsheets Functions/Formulae

7th - 11th Grade

14 Qs

Fogli elettronici 2 - Formule e Funzioni

Fogli elettronici 2 - Formule e Funzioni

8th Grade

13 Qs

Spreadsheet Formulas

Spreadsheet Formulas

7th - 8th Grade

15 Qs

Електронні таблиці (Початок)

Електронні таблиці (Початок)

8th Grade

10 Qs

UH Analisis Data

UH Analisis Data

8th Grade

12 Qs

Bạn có phải là người học tốt Tin học 8

Bạn có phải là người học tốt Tin học 8

1st Grade - University

10 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?