ANALISA DATA KELAS 8D 2024
Quiz
•
Computers
•
8th Grade
•
Practice Problem
•
Hard
I Widiantara
Used 3+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan gambar di bawah ini! Pada cell C2 rumusnya adalah ...
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
Perhatikan gambar di bawah ini! Pada cell C3 rumusnya adalah ...
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
Perhatikan gambar berikut! Bagaimana fungsi untuk mencari nilai di D13!
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
Perhatikan gambar berikut! Bagaimana fungsi untuk mencari nilai di D14!
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
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
Apa isi dari g2 jika ditanyakan total harga dengan kriteria Ana dan Buku?
7.
FILL IN THE BLANK QUESTION
1 min • 1 pt
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

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
10 questions
Kuis 1.7 Informatika (Mengenal Enkripsi)
Quiz
•
8th Grade
10 questions
Creando Gráficos en Google Sheet(@profejulio)
Quiz
•
4th - 8th Grade
11 questions
Spreadsheet Charts & Advanced Functions
Quiz
•
6th - 8th Grade
13 questions
Google Sheets
Quiz
•
8th Grade
14 questions
Spreadsheet Basics & Formula
Quiz
•
6th - 8th Grade
10 questions
Document production
Quiz
•
7th - 10th Grade
15 questions
運算思維二
Quiz
•
8th Grade
15 questions
Microsoft Excel Review
Quiz
•
6th - 8th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade
