Pretest Pengolahan Data Dasar
Quiz
•
Computers
•
7th Grade
•
Practice Problem
•
Medium
Peserta 06530
Used 19+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi apa yang digunakan untuk menghitung jumlah angka dalam sebuah range di Excel?
AVERAGE
SUM
COUNT
MAX
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus Excel untuk mencari nilai terbesar dalam rentang B2:B10 adalah?
=LARGE(B2:B10)
=MAX(B2:B10)
=BIGGEST(B2:B10)
=HIGHEST(B2:B10)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika sel A1 berisi teks "informatika" dan sel B1 berisi teks "kelas 7", maka hasil dari rumus =CONCAT(A1,B1) adalah?
informatika kelas 7
informatikakelas 7
informatikakelas7
kelas 7 informatika
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Terletak pada cell apa harga untuk buah Anggur?
B5
C5
C4
BC
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mencari nilai Total harga buah pada tabel tersebut dapat menggunakan formula?
=AVG
=FIND
=SUM
=ERR
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk menghitung jumlah sel yang berisi angka dalam rentang C1:C10, rumus yang digunakan adalah?
=SUM(C1:C10)
=COUNT(C1:C10)
=COUNTA(C1:C10)
=COUNTIF(C1:C10,">0")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa fungsi dari rumus =IF(B2>=75,"Lulus","Tidak Lulus")?
Menentukan apakah siswa lulus atau tidak berdasarkan nilai pada sel B2
Menghitung jumlah siswa yang lulus
Menjumlahkan nilai siswa yang mendapat nilai lebih dari 75
Mengurutkan data siswa berdasarkan nilai
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
Already have an account?
Similar Resources on Wayground
10 questions
Analisis Data Bab 6
Quiz
•
7th Grade
10 questions
Skaičiuoklė - Diagramos
Quiz
•
7th - 8th Grade
14 questions
Arkusz kalkulacyjny - powtórzenie
Quiz
•
7th - 8th Grade
10 questions
Google Sheets Functions Review
Quiz
•
7th - 8th Grade
14 questions
BÀI 14- THUẬT TOÁN TÌM KIẾM TUẦN TỰ
Quiz
•
6th Grade - University
10 questions
Test Excel
Quiz
•
7th - 8th Grade
10 questions
Informatika Excel kelas 7
Quiz
•
7th Grade
10 questions
Basic Excel
Quiz
•
5th - 12th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd 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
