
Ulangan ke 2
Quiz
•
Computers
•
10th Grade
•
Practice Problem
•
Medium
Nurhidayat Nurhidayat
Used 5+ times
FREE Resource
Enhance your content in a minute
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Fungsi =SUM(A1:A5) berfungsi untuk...
Menghitung rata-rata
Mengalikan data
Menjumlahkan data
Mencari nilai tertinggi
Menampilkan data terakhir
2.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Untuk mencari nilai rata-rata dari sel B1 sampai B10, digunakan rumus...
=AVG(B1:B10)
=TOTAL(B1:B10)
=MEAN(B1:B10)
=AVERAGE(B1:B10)
=SUM(B1:B10)
3.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Untuk membulatkan angka ke atas digunakan fungsi...
=ROUNDUP()
=FLOOR()
=CEILING()
=INT()
=ROUND()
4.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Fungsi logika yang hanya bisa memilih antara dua kondisi adalah...
=MATCH()
=AND()
=CHOOSE()
=IF()
=VLOOKUP()
5.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Fungsi =VLOOKUP() biasanya digunakan untuk...
Mengurutkan data
Mencari data di kolom pertama dan menampilkan nilai dari kolom lain
Membandingkan dua sel
Menyalin isi sel
Menyaring data
6.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Untuk mencari nilai dari kolom lain dengan acuan data di kolom pertama digunakan...
=VLOOKUP()
=FIND()
=SEARCH()
=HLOOKUP()
=FILTER()
7.
MULTIPLE CHOICE QUESTION
45 sec • 5 pts
Rumus =A2*$B$1 artinya...
Menjumlahkan A2 dan B1
Mengalikan A2 dan B1 secara absolut
Mengurangkan A2 dengan B1
Membagi A2 dengan B1
Menyalin nilai dari B1 ke A2
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
15 questions
LATIHAN SOAL PEMROGRAMAN
Quiz
•
9th Grade - University
15 questions
Quiz Aplikasi Pengolah Angka
Quiz
•
10th Grade - University
20 questions
QUIZ BAB 4: SISTEM OPERASI
Quiz
•
8th Grade - University
19 questions
QUIZ INFORMATIKA
Quiz
•
1st - 10th Grade
20 questions
KELAS 7 1
Quiz
•
9th - 12th Grade
20 questions
ULANGAN FORMATIF 1
Quiz
•
10th Grade
20 questions
PSTS INFORMATIKA X
Quiz
•
10th Grade - University
20 questions
Komjardas KD 10
Quiz
•
10th Grade
Popular Resources on Wayground
8 questions
2 Step Word Problems
Quiz
•
KG - University
20 questions
Comparing Fractions
Quiz
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Latin Bases claus(clois,clos, clud, clus) and ped
Quiz
•
6th - 8th Grade
22 questions
fractions
Quiz
•
3rd Grade
7 questions
The Story of Books
Quiz
•
6th - 8th Grade
