
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
Fungsi SUM dalam Microsoft Excel digunakan untuk:
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
Similar Resources on Wayground
25 questions
ÔN TẬP TIN 7- GIỮA KI 1

Quiz
•
8th - 12th Grade
25 questions
UH PEMROGRAMAN DASAR 1

Quiz
•
10th - 12th Grade
23 questions
EXCEL TEST

Quiz
•
KG - University
25 questions
8-2 PTS INFORMATIKA

Quiz
•
8th Grade - University
22 questions
TIN HỌC 7

Quiz
•
9th Grade - University
30 questions
Quiz SUMATIF 9-12024/2025

Quiz
•
9th Grade - University
22 questions
TIN HỌC 7

Quiz
•
9th Grade - University
25 questions
Working With Number (Microsoft Excel beginner)

Quiz
•
4th Grade - University
Popular Resources on Wayground
50 questions
Trivia 7/25

Quiz
•
12th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
11 questions
Negative Exponents

Quiz
•
7th - 8th Grade
12 questions
Exponent Expressions

Quiz
•
6th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
20 questions
One Step Equations All Operations

Quiz
•
6th - 7th Grade
18 questions
"A Quilt of a Country"

Quiz
•
9th Grade