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
Already have an account?
Similar Resources on Wayground
15 questions
LỚP 7.1_KTTX1_MÔN TIN HỌC 7
Quiz
•
7th - 12th Grade
10 questions
Excel langelių koordinatės
Quiz
•
7th - 8th Grade
9 questions
Статистикалық мәліметтер
Quiz
•
1st - 10th Grade
10 questions
TIN HỌC 8 - BÀI TH1
Quiz
•
8th Grade
12 questions
MS Excel
Quiz
•
7th - 8th Grade
10 questions
Microsoft Excel - Basics, Formatting and Calculating
Quiz
•
6th - 8th Grade
12 questions
Exel Formulas
Quiz
•
6th - 8th Grade
12 questions
Spreadsheets Year 7
Quiz
•
1st - 9th Grade
Popular Resources on Wayground
10 questions
Forest Self-Management
Lesson
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
30 questions
Thanksgiving Trivia
Quiz
•
9th - 12th Grade
30 questions
Thanksgiving Trivia
Quiz
•
6th Grade
11 questions
Would You Rather - Thanksgiving
Lesson
•
KG - 12th Grade
48 questions
The Eagle Way
Quiz
•
6th Grade
10 questions
Identifying equations
Quiz
•
KG - University
10 questions
Thanksgiving
Lesson
•
5th - 7th Grade
Discover more resources for Computers
11 questions
Would You Rather - Thanksgiving
Lesson
•
KG - 12th Grade
10 questions
Identifying equations
Quiz
•
KG - University
18 questions
Thanksgiving Trivia
Quiz
•
4th - 12th Grade
20 questions
Thanksgiving Trivia!
Quiz
•
6th - 8th Grade
20 questions
Thanksgiving
Quiz
•
KG - 12th Grade
12 questions
Thanksgiving Trivia
Quiz
•
3rd - 8th Grade
20 questions
Pythagorean Theorem and Their Converse
Quiz
•
8th - 9th Grade
10 questions
Origins of Thanksgiving
Lesson
•
6th - 8th Grade
