Peringkasan dan visualisasi data

Peringkasan dan visualisasi data

8th Grade

10 Qs

quiz-placeholder

Similar activities

về đích

về đích

8th Grade - University

10 Qs

Operasi Matematika Sederhana Dengan Excel

Operasi Matematika Sederhana Dengan Excel

1st - 10th Grade

10 Qs

2BS p2 EXCEL

2BS p2 EXCEL

8th Grade

15 Qs

Uji Kompetensi ANALISIS DATA

Uji Kompetensi ANALISIS DATA

8th Grade

15 Qs

Warm Up- Scenarios for Functions and Formula

Warm Up- Scenarios for Functions and Formula

8th Grade

10 Qs

Cell References Puzzle

Cell References Puzzle

7th - 8th Grade

10 Qs

Контрольне тестування з теми "Табличний процесор"

Контрольне тестування з теми "Табличний процесор"

6th - 8th Grade

14 Qs

G-8 Spreadsheet Formula and Functions

G-8 Spreadsheet Formula and Functions

8th Grade

10 Qs

Peringkasan dan visualisasi data

Peringkasan dan visualisasi data

Assessment

Quiz

Computers

8th Grade

Hard

Created by

Al Recap

Used 14+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 10 pts

Media Image

Jika ingin mengambil nilai siswa pada posisi ke-4, rumus yang benar adalah?

=INDEX(A1:C6, 3, 4)

=INDEX(A1:C6, 4, 3)

=INDEX(A2:C6, 4, 3)

=INDEX(A2:C6, 3, 4)

2.

MULTIPLE CHOICE QUESTION

1 min • 10 pts

Media Image

Jika Anda ingin mencari harga produk dengan kode P003, rumus mana yang benar?

=VLOOKUP("P003", A2:C6, 2, FALSE)

=VLOOKUP("P003", A2:C6, 3, FALSE)

=VLOOKUP("Monitor", A2:C6, 3, FALSE)

=VLOOKUP(P003, A2:C6, 3, TRUE)

3.

MULTIPLE CHOICE QUESTION

1 min • 10 pts

Media Image

Rumus CHOOSE yang benar untuk mendapatkan hari ke 4 adalah?

=CHOOSE(4, "Senin", "Selasa", "Rabu", "Kamis", "Jumat")

=CHOOSE(3, "Senin", "Selasa", "Rabu", "Kamis", "Jumat")

=CHOOSE(4, A2:A6)

=CHOOSE(4, "Senin", "Selasa", "Rabu", "Jumat", "Kamis")

4.

MULTIPLE CHOICE QUESTION

1 min • 10 pts

Media Image

Manakah rumus yang benar untuk mencari target penjualan di bulan Maret?

=HLOOKUP("Maret", A1:F2, 2, FALSE)

=HLOOKUP("Maret", A1:F2, 3, FALSE)

=HLOOKUP("Maret", A1:F2, 2, TRUE)

=HLOOKUP("Mar", A1:F2, 2, FALSE)

5.

MULTIPLE CHOICE QUESTION

1 min • 10 pts

Media Image

Manakah rumus yang benar untuk mencari posisi pelanggan Dewi dalam daftar?

=MATCH("Dewi", B2:B6, -1)

=MATCH("Dewi", A2:A6, 0)

=MATCH("Dewi", B2:B6, 1)

=MATCH("Dewi", B2:B6, 0)

6.

MULTIPLE CHOICE QUESTION

30 sec • 10 pts

Seorang analis ingin menampilkan tren pertumbuhan penjualan dari Januari hingga Desember. Grafik apa yang paling cocok digunakan?

Pie Chart

Line Chart

Bar Chart

Column Chart

7.

MULTIPLE CHOICE QUESTION

30 sec • 10 pts

Seorang manajer ingin mengetahui kontribusi setiap divisi terhadap total pendapatan perusahaan dalam bentuk persentase. Grafik apa yang paling tepat?

Pie Chart

Column Chart

Bar Chart

Area Chart

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?