Perhatikan gambar di bawah ini! Pada cell C2 rumusnya adalah ...
ANALISA DATA KELAS 8D 2024
8th Grade
•10 Qs
Similar activities
الجداول الحسابية
8th Grade
•13 Qs
kiểm tra 15 phút tin 7
6th - 9th Grade
•10 Qs
Microsoft Excel - Basics, Formatting and Calculating
6th - 8th Grade
•10 Qs
S1 Spreadsheets Functions/Formulae
7th - 11th Grade
•14 Qs
Excel 3 - Funzioni
8th - 10th Grade
•10 Qs
Bài 5: Sử dụng bảng tính để giải quyết các bài toán thực tế
8th Grade
•5 Qs
UH Analisis Data
8th Grade
•12 Qs
Tabulkový editor - oblasti
6th - 8th Grade
•12 Qs
ANALISA DATA KELAS 8D 2024
Quiz
•
Computers
•
8th Grade
•
Hard
I Widiantara
Used 3+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=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 ...
=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!
=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!
=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
Microsoft
Apple
Others
Similar Resources on Quizizz
15 questions
9 сынып Сүзгілеу
Quiz
•
8th Grade
10 questions
MS Excel
Quiz
•
5th - 8th Grade
11 questions
Tabeliarvutus (algus)
Quiz
•
6th - 8th Grade
5 questions
Bài 5: Sử dụng bảng tính để giải quyết các bài toán thực tế
Quiz
•
8th Grade
12 questions
Tabulkový editor - oblasti
Quiz
•
6th - 8th Grade
15 questions
MS EXCEL Quiz 1
Quiz
•
6th - 8th Grade
15 questions
9 Электронные таблицы Excel
Quiz
•
8th - 9th Grade
10 questions
MS EXCEL FORMULAS, FUNCTIONS AND ANALYSIS
Quiz
•
6th - 8th Grade
Popular Resources on Quizizz
15 questions
Character Analysis
Quiz
•
4th Grade
17 questions
Chapter 12 - Doing the Right Thing
Quiz
•
9th - 12th Grade
10 questions
American Flag
Quiz
•
1st - 2nd Grade
20 questions
Reading Comprehension
Quiz
•
5th Grade
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
18 questions
Full S.T.E.A.M. Ahead Summer Academy Pre-Test 24-25
Quiz
•
5th Grade
14 questions
Misplaced and Dangling Modifiers
Quiz
•
6th - 8th Grade
Discover more resources for Computers
14 questions
Misplaced and Dangling Modifiers
Quiz
•
6th - 8th Grade
17 questions
Parts of Speech
Quiz
•
7th - 12th Grade
10 questions
Identifying equations
Quiz
•
KG - University
44 questions
El fin del año- 7th
Quiz
•
7th - 12th Grade
40 questions
Word Study Assessment: Roots, Prefixes, Suffixes, and Vocabulary
Quiz
•
8th Grade
17 questions
guess the logo
Quiz
•
8th Grade
16 questions
Function or Non-Function?
Quiz
•
8th - 10th Grade
15 questions
Sentence Fragments and Run-ons
Quiz
•
8th Grade