
Analisis Data - Informatika
Authored by Yohan Adi Setiawan
Computers
8th Grade
Used 28+ 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
1 min • 2 pts
Pencarian data di dalam lembar kerja dapat dilakukan dengan menggunakan
fungsi. Mendapatkan data tentang sesuatu secara mendatar (horizontal) dengan formula?
IF
SUM
VLOOKUP
HLOOKUP
2.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
Formula yang digunakan pada Cell H7 adalah ...
SUM
COUNT
MATCH
INDEX
3.
MULTIPLE CHOICE QUESTION
1 min • 4 pts
Penulisan Formula yang benar untuk Cell H7 adalah ...
=MATCH(G7;G1:G4;0)
=MATCH(G1:G4;G7;0)
=MATCH(G1:G4;0;G7)
=MATCH(0;G7;G1:G4)
4.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
Formula yang digunakan pada Cell L8 adalah ...
MATCH
INDEX
VLOOKUP
HLOOKUP
5.
MULTIPLE CHOICE QUESTION
1 min • 4 pts
Penulisan formula pada L8 yang benar adalah ...
INDEX(K8;J8;J1:K4)
INDEX(J8;J1:K4;K8)
INDEX(J1:K4;J8;K8)
INDEX(J1;K4;J8;K8)
6.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
Apakah nama grafik pada gambar tersebut?
Bar Chart
Pie Chart
Line Chart
Area Chart
7.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
Perhatikan ciri-ciri grafik berikut ini:
1. Urutkan data untuk chart sehingga terlihat dengan jelas perbedaan antar data.
2. Jika label sumbu x (x-axis-label) berupa teks yang cukup panjang, gunakan chart horizontal.
Termasuk jenis chart apakah ciri-ciri tersebut?
Bar Chart
Line Chart
Pie Chart
Area Chart
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
Bài 5. Thao tác với bảng tính
Quiz
•
1st - 12th Grade
15 questions
6th Grade Media Quiz
Quiz
•
KG - University
15 questions
MS EXCEL Quiz 1
Quiz
•
6th - 8th Grade
10 questions
MS Excel
Quiz
•
5th - 8th Grade
15 questions
9 Электронные таблицы Excel
Quiz
•
8th - 9th Grade
15 questions
Desktop Publishing
Quiz
•
7th - 8th Grade
10 questions
MS EXCEL FORMULAS, FUNCTIONS AND ANALYSIS
Quiz
•
6th - 8th Grade
16 questions
Year 7 - Spreadsheets - L1
Quiz
•
7th - 9th 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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade