Dasar Rumus Microsoft Excel
9th - 12th Grade
•10 Qs
Similar activities
Pemanfaatan AI dalam Pembelajaran
12th Grade - University
•10 Qs
QUIZZ LOGIKA MATEMATIKA
10th Grade
•10 Qs
Kompyuter va Internet haqida savollar
9th Grade
•15 Qs
Quiz Blog dan Vlog
9th Grade - University
•10 Qs
Tin 9 Bài 8. Hàm SUMIF
9th Grade - University
•10 Qs
Excel
12th Grade
•10 Qs
Quiz Konten Vlog (Kelas 9)
9th Grade
•10 Qs
Pengenalan hyperlink dan navigasi
11th Grade
•15 Qs
Dasar Rumus Microsoft Excel
Quiz
•
Information Technology (IT)
•
9th - 12th Grade
•
Practice Problem
•
Medium
tiklab madsafada
Used 7+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berikut adalah data nilai siswa dalam pelajaran Matematika, Untuk menghitung total nilai semua siswa, rumus Excel apa yang harus digunakan?
=AVERAGE(B2:B6)
=MAX(B2:B6)
=SUM(B2:B6)
=MIN(B2:B6)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dengan data nilai siswa yang sama, rumus Excel untuk menghitung rata-rata nilai siswa adalah:
=SUM(B2:B6)
=AVERAGE(B2:B6)
=MIN(B2:B6)
=MAX(B2:B6)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk menemukan nilai tertinggi dari data nilai siswa di atas, rumus Excel yang tepat adalah:
=MIN(B2:B6)
=AVERAGE(B2:B6)
=MAX(B2:B6)
=SUM(B2:B6)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mengetahui nilai terendah dari data nilai siswa di atas, rumus yang digunakan adalah:
=MAX(B2:B6)
=AVERAGE(B2:B6)
=MIN(B2:B6)
=SUM(B2:B6)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika kamu ingin menghitung jumlah siswa yang mendapatkan nilai lebih dari 85, rumus Excel yang digunakan adalah:
IF(SUM(B2:B6)>85, "Jumlah lebih dari 85", "Jumlah tidak lebih dari 85")
SUMIF(B2:B6, ">85")
=AVERAGE(B2:B6)
=COUNTIF(B2:B6, ">85")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus Excel apa yang harus digunakan untuk menghitung berapa siswa yang mendapatkan nilai di bawah 80?
=SUMIF(B2:B6, "<80")
=COUNTIF(B2:B6, "<80")
=AVERAGE(B2:B6)
=MAX(B2:B6)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk menghitung nilai rata-rata dari siswa yang mendapatkan nilai di atas 85, rumus Excel yang sesuai adalah:
=MAX(B2:B6)
=COUNTIF(B2:B6, ">85")
=SUMIF(B2:B6, ">85")
=AVERAGEIF(B2:B6, ">85")
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
14 questions
Intro to Databases
Quiz
•
10th Grade
10 questions
Asesmen Harian 1
Quiz
•
11th Grade - University
10 questions
PKK2 Bussiness Plan Bacaan
Quiz
•
11th Grade
10 questions
Algoritma dan Pemrograman (Array dan String)
Quiz
•
11th Grade
15 questions
SAS informatika kelas 8 S2
Quiz
•
8th Grade - University
10 questions
QUIZ 1
Quiz
•
10th Grade
10 questions
Syntax Dasar C++ #1
Quiz
•
11th Grade
10 questions
Latsol
Quiz
•
10th Grade - University
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
Discover more resources for Information Technology (IT)
20 questions
El Verbo IR Practice
Quiz
•
9th Grade
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
18 questions
SAT Prep: Ratios, Proportions, & Percents
Quiz
•
9th - 10th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade
12 questions
Exponential Growth and Decay
Quiz
•
9th Grade