Fungsi SUM dalam Microsoft Excel digunakan untuk:
Quiz Fungsi Excel XI A
11th Grade
•26 Qs
Similar activities
BSG IGCSE spreadsheet revision
10th - 12th Grade
•22 Qs
PTS 11 Semester 2
11th Grade
•30 Qs
ÔN TẬP TIN 7 HỌC KỲ 1
1st - 12th Grade
•25 Qs
Computer Apps- Excel Formulas & Cell References
9th - 12th Grade
•30 Qs
ÔN TẬP GIỮA KÌ 2 TIN 9 24-25
9th Grade - University
•23 Qs
PENILAIAN AKHIR SEMESTER 1 2018 (KELAS XI)
5th - 11th Grade
•30 Qs
Microsoft Excel XI Semester 4 KD3
11th Grade
•30 Qs
Quiz Fungsi Excel XI A
Passage
•
Computers
•
11th Grade
•
Medium
Tri Wuryani
Used 1+ times
FREE Resource
26 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Menghitung jumlah data dalam suatu sel
Menjumlahkan nilai dari sekumpulan sel
Menghitung rata-rata dari sekumpulan sel
Mencari nilai terbesar dalam sekumpulan sel
Menghitung jumlah sel kosong dalam suatu rentang
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus yang benar untuk mencari rata-rata dari sel A1 sampai A10 adalah:
=SUM(A1:A10)
=AVERAGE(A1:A10)
=AVG(A1:A10)
=MEAN(A1:A10)
=RATA2(A1:A10)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk mencari nilai tertinggi dari sekumpulan angka adalah:
MIN
MAX
AVERAGE
SUM
COUNT
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika Anda ingin mencari nilai terkecil dalam rentang B2:B15, maka rumus yang digunakan adalah:
=MIN(B2:B15)
=MAX(B2:B15)
=SMALLEST(B2:B15)
=LOW(B2:B15)
=MINIMUM(B2:B15)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Manakah di bawah ini yang merupakan penggunaan fungsi IF tunggal dengan benar?
=IF(A1>50, "Lulus", "Gagal")
=IF(A1>50; "Lulus"; "Gagal")
=IF(A1>50 "Lulus" "Gagal")
=IF(A1>50: "Lulus": "Gagal")
=IF(A1>50 "Lulus"; "Gagal")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Manakah di bawah ini yang merupakan fungsi IF majemuk yang benar?
=IF(A1>80, "Baik", IF(A1>60, "Cukup", "Kurang"))
=IF(A1>80, "Baik", A1>60, "Cukup", "Kurang")
=IF(A1>80, "Baik" IF(A1>60, "Cukup", "Kurang"))
=IF(A1>80; "Baik"; IF(A1>60; "Cukup"; "Kurang"))
=IF(A1>80, "Baik"); IF(A1>60, "Cukup", "Kurang")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa hasil dari rumus berikut jika nilai B1 = 75?
A
B
C
Error
Tidak ada jawaban yang benar
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Wayground
30 questions
Summative Quiz (Excel, Online Platforms and Collaboration)
Quiz
•
11th Grade
30 questions
Quiz SUMATIF 9-12024/2025
Quiz
•
9th Grade - University
24 questions
Câu hỏi về Công nghệ thông tin
Quiz
•
9th Grade - University
28 questions
Tin học 9-Ôn tập giữa kì 2
Quiz
•
9th Grade - University
24 questions
TIC - GRADO 10°
Quiz
•
11th Grade - University
25 questions
Working With Number (Microsoft Excel beginner)
Quiz
•
4th Grade - University
32 questions
Data Analysis Part 2
Quiz
•
9th - 11th Grade
25 questions
UH PEMROGRAMAN DASAR 1
Quiz
•
10th - 12th Grade
Popular Resources on Wayground
25 questions
Equations of Circles
Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)
Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System
Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice
Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers
Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons
Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)
Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review
Quiz
•
10th Grade