ANALISA DATA KELAS 8D 2024
8th Grade
•10 Qs
Similar activities
Bài 5: Từ bài toán đến chương trình(t1)
8th Grade
•10 Qs
KTTX_LẦN 2_TIN7
7th Grade - University
•10 Qs
Excel
1st - 12th Grade
•8 Qs
Cell References Puzzle
7th - 8th Grade
•10 Qs
Year 7 Spreadsheets recap
7th - 8th Grade
•14 Qs
ICT Spreadsheet Essentials - Lesson 1 (Part 3)
7th - 8th Grade
•15 Qs
Interfaz de Excel.
8th Grade
•11 Qs
excel
8th Grade
•13 Qs
ANALISA DATA KELAS 8D 2024
Quiz
•
Computers
•
8th Grade
•
Hard
I Widiantara
Used 3+ times
FREE Resource
Enhance your content
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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 ...
=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
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
15 questions
9 сынып Сүзгілеу
Quiz
•
8th Grade
13 questions
Robot Design
Quiz
•
6th - 8th Grade
12 questions
Excel
Quiz
•
7th - 9th Grade
10 questions
Кестелік процессор
Quiz
•
8th Grade
12 questions
Google Sheets basics
Quiz
•
6th - 8th Grade
15 questions
Spreadsheets
Quiz
•
1st - 12th Grade
10 questions
Excel If function WSC 4.2.3
Quiz
•
7th Grade - University
10 questions
ÔN TẬP GIỮA HKI (2) - Tin 8
Quiz
•
8th Grade
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
11 questions
NEASC Extended Advisory
Lesson
•
9th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
20 questions
Multiplying and Dividing Integers
Quiz
•
7th Grade