Quiz Analisis Data
Quiz
•
Information Technology (IT)
•
8th Grade
•
Practice Problem
•
Hard
Usup Usup
Used 4+ times
FREE Resource
Enhance your content in a minute
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
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
Quiz 1 Sistem Infrastruktur
Quiz
•
University
12 questions
Transformação Digital
Quiz
•
University
20 questions
AI Vs Robots Revision
Quiz
•
8th Grade
15 questions
Data Literacy Quizizz
Quiz
•
6th Grade - University
15 questions
PPL 223 - (QUIZ 3) Data Types and Structures
Quiz
•
University
20 questions
Quiz Mengenal Data VII
Quiz
•
7th Grade - University
10 questions
Quiz 1 IoT
Quiz
•
University
10 questions
HTML DASAR
Quiz
•
11th 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
Discover more resources for Information Technology (IT)
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
15 questions
scatter plots and trend lines
Quiz
•
8th Grade
20 questions
Physical and Chemical Changes
Quiz
•
8th Grade
6 questions
Veterans Day
Lesson
•
8th Grade
13 questions
Finding slope from graph
Quiz
•
8th Grade
10 questions
Exploring Europe: Geography, History, and Culture
Interactive video
•
5th - 8th Grade
