Pencarian data di dalam lembar kerja dapat dilakukan dengan menggunakan
fungsi. Mendapatkan data tentang sesuatu secara mendatar (horizontal) dengan formula?
Analisis Data - Informatika
Quiz
•
Computers
•
8th Grade
•
Hard
Yohan Adi Setiawan
Used 24+ times
FREE Resource
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
15 questions
Latsol ASTS Genap Informatika Kelas 8
Quiz
•
8th Grade
20 questions
Quiz Analisis Data Kelas VIII
Quiz
•
8th Grade
10 questions
ANALISA DATA KELAS 8D 2024
Quiz
•
8th Grade
10 questions
Excel Functions and Data Visualization Quiz (PS)
Quiz
•
8th Grade
15 questions
Quiz Peringkasan Data dan Fungsi Excel BAB VI
Quiz
•
8th Grade
20 questions
Quiz PTS Informatika 8
Quiz
•
8th Grade
20 questions
Latihan PAT Informatika Kelas 8
Quiz
•
8th Grade
11 questions
Spreadsheet Charts & Advanced Functions
Quiz
•
6th - 8th Grade
15 questions
Multiplication Facts
Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz
Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set
Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025
Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)
Quiz
•
9th - 12th Grade
15 questions
June Review Quiz
Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles
Quiz
•
8th Grade
25 questions
Triangle Inequalities
Quiz
•
10th - 12th Grade
25 questions
SS Combined Advisory Quiz
Quiz
•
6th - 8th Grade
20 questions
Congruent and Similar Triangles
Quiz
•
8th Grade
14 questions
Exterior and Interior angles of Polygons
Quiz
•
8th Grade
6 questions
Earth's energy budget and the greenhouse effect
Lesson
•
6th - 8th Grade
15 questions
SMART Goals
Quiz
•
8th - 12th Grade
20 questions
Lesson: Slope and Y-intercept from a graph
Quiz
•
8th Grade