Quiz Analisis Data
Authored by Usup Usup
Information Technology (IT)
8th Grade
Used 4+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Syntax yang tepat untuk menggunakan fungsi HLOOKUP adalah....
=HLOOKUP(tabel acuan, baris acuan,kolom,false)
=HLOOKUP(baris acuan, tabel acuan,kolom,false)
=HLOOKUP(tabel acuan, kolom acuan,baris,false)
=HLOOKUP(kolom acuan, tabel acuan, baris, false)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk melakukan penjumlahan dengan banyak kriteria tertentu adalah....
SUMIF
SUMIFS
COUNTIF
COUNTIFS
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pada fungsi VLOOKUP dan HLOOKUP, agar nilai yang dipindahkan bersifat absolut selain menggunakan FALSE juga dapat menggunakan notasi angka....
0
1
2
3
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penggunaan fungsi CHOOSE jika index number lebih kecil atau lebih besar dari angka nilai dalam daftar, maka fungsi CHOOSE akan menghasilkan nilai ....
TRUE
FALSE
#VALUE!
#######
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pengolahan data yang dapat dilakukan Excel meliputi hal berikut, kecuali....
peringkasan data
pengumpulan data
visualisasi data.
pencarian data
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi utama program Microsoft Excel adalah....
pengolah kata
pengolah data angka
pengelola dokumen
pencari informasi
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mencari data dengan mengambil range data dapat menggunakan fungsi ....
SEARCH
LOOK
LOOKUP
FIND
Access all questions and much more by creating a free account
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
20 questions
Quiz KTI
Quiz
•
University
20 questions
Latihan Soal Bab 1 dan 2
Quiz
•
8th Grade
10 questions
Lego Spike & Python - Challenge 3 Quiz
Quiz
•
6th - 8th Grade
15 questions
komputasi awan
Quiz
•
University
15 questions
İstifadəçi interfeysi
Quiz
•
University
20 questions
TJAT--SK,Elektronika & Mikroprosesor
Quiz
•
11th Grade
14 questions
Game dulu sebelum QUIZ 1
Quiz
•
University
15 questions
CCDI Competition- First League - Cycle 3 -
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
20 questions
7th grade ELA Vocabulary Review
Quiz
•
7th - 8th Grade
22 questions
Phases of the moon
Quiz
•
8th Grade
10 questions
Cell Organelles and Their Functions
Interactive video
•
6th - 10th Grade
14 questions
finding slope from a graph
Quiz
•
8th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
7 questions
Path and Ortho Greek bases
Quiz
•
6th - 8th Grade
20 questions
Relative Pronouns
Quiz
•
4th - 8th Grade
8 questions
8th U6L1: Organizing Data
Quiz
•
8th Grade