
Tes Analisis Data
Authored by Fandy Septia Anggriawan
Computers
12th Grade
10 Questions
Used 2+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi AVERAGE pada Microsoft Excel digunakan untuk…
Menjumlahkan seluruh data dalam suatu range
Menghitung nilai rata-rata dari sekumpulan data
Menampilkan nilai maksimum dari data
Menghitung jumlah data yang berisi angka
Menampilkan nilai terkecil dari data
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus yang benar untuk mencari nilai maksimum dari sel A1 sampai A10 adalah…
=MAX(A1:A10)
=MIN(A1:A10)
=AVERAGE(A1:A10)
=SUM(A1:A10)
=COUNT(A1:A10)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi COUNTIF digunakan untuk…
Menghitung jumlah seluruh data dalam range
Menghitung jumlah data yang memenuhi kriteria tertentu
Menjumlahkan data berdasarkan kondisi tertentu
Menghitung rata-rata data berdasarkan kondisi
Menampilkan data yang sesuai dengan kriteria
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk menampilkan data dalam bentuk grafik batang, menu yang digunakan adalah…
Insert → Pie Chart
Insert → Line Chart
Insert → Column Chart
Insert → Scatter Chart
Insert → Area Chart
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika ingin mengurutkan data dari nilai tertinggi ke terendah, langkah yang benar adalah…
Data → Sort → Sort A to Z
Data → Sort → Sort Z to A
Data → Filter → Sort Ascending
Data → Filter → Sort by Color
Data → Sort → Custom Sort
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi VLOOKUP digunakan untuk…
Mencari data secara horizontal
Mencari data secara vertikal
Menghitung jumlah data
Mengurutkan data
Menampilkan data dalam bentuk grafik
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus =IF(B2>60,"Lulus","Tidak Lulus") berarti…
Jika nilai di B2 lebih dari 60 maka hasilnya “Tidak Lulus”
Jika nilai di B2 kurang dari 60 maka hasilnya “Lulus”
Jika nilai di B2 lebih dari 60 maka hasilnya “Lulus”, selain itu “Tidak Lulus”
Jika nilai di B2 sama dengan 60 maka hasilnya “Lulus”
Jika nilai di B2 kosong maka hasilnya “Tidak Lulus”
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
10 questions
Data Engineering y BigQuery V1
Quiz
•
12th Grade
10 questions
PRE-ASSESSMENT ETECH M1
Quiz
•
12th Grade
15 questions
emptech L1 A
Quiz
•
12th Grade
12 questions
ASAS SAINS KOMPUTER : TINGKATAN 3
Quiz
•
4th Grade - University
12 questions
Effect of ICT
Quiz
•
9th - 12th Grade
10 questions
Server Administration- Quiz 1
Quiz
•
12th Grade - University
10 questions
Quiz 9 (15.09.2021)
Quiz
•
1st - 12th Grade
10 questions
Cloud Computing
Quiz
•
12th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
15 questions
Christmas Song Emoji Pictionary
Quiz
•
7th - 12th Grade
20 questions
Christmas Movies
Quiz
•
1st - 12th Grade
55 questions
CHS Holiday Trivia
Quiz
•
12th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
29 questions
christmas facts
Lesson
•
5th - 12th Grade
20 questions
Christmas Trivia
Quiz
•
5th - 12th Grade
20 questions
Stages of Meiosis
Quiz
•
9th - 12th Grade