Quiz Fungsi Excel
Authored by Uswatun Nisa
Computers
9th Grade
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dalam sebuah tabel penjualan, Anda memiliki data jumlah produk terjual pada kolom B2. Fungsi apa yang digunakan untuk menghitung total penjualan semua produk?
=SUMIF(B2:B10)
=COUNT(B2:B10)
=SUM(B2:B10)
=AVERAGE(B2:B10)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda ingin menjumlahkan nilai penjualan pada kolom B jika nama produk pada kolom A adalah "Laptop". Fungsi mana yang tepat digunakan?
=SUMIF(A2:A10, "Laptop", B2:B10)
=SUM(A2:A10)
=COUNTIF(A2:A10, "Laptop")
=SUMIF(B2:B10, "Laptop")
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda ingin menghitung berapa kali nilai pada kolom B lebih besar dari 50. Fungsi apa yang paling tepat digunakan?
=SUMIF(B2:B10, ">50")
=COUNTIF(B2:B10, ">50")
=COUNT(B2:B10, ">50")
=SUM(B2:B10, ">50")
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika di kolom C2 terdapat rumus =A2 + B2, apa yang dilakukan oleh Excel?
Menghitung selisih nilai di sel A2 dan B2.
Mengalikan nilai di sel A2 dan B2.
Menambahkan nilai di sel A2 dan B2.
Membagi nilai di sel A2 dengan nilai di sel B2.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda ingin menghitung berapa banyak siswa yang memperoleh nilai lebih dari 75 pada kolom C. Fungsi apa yang paling tepat digunakan?
=SUMIF(C2:C20, ">75")
=COUNTIF(C2:C20, ">75")
=COUNT(C2:C20)
=SUM(C2:C20, ">75")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi =COUNT(B2:B10) dalam Microsoft Excel digunakan untuk:
Menjumlahkan semua nilai pada rentang B2.
Menghitung jumlah sel yang berisi angka dalam rentang B2.
Menghitung jumlah sel kosong dalam rentang B2.
Menampilkan jumlah karakter di dalam sel.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana cara menggunakan fungsi SUMIF untuk menjumlahkan hanya nilai yang lebih dari 100 dalam rentang B2?
=SUMIF(B2:B10, ">100")
=COUNTIF(B2:B10, ">100")
=SUM(B2:B10, ">100")
=SUMIF(B2:B10, 100)
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
10 questions
Excel
Quiz
•
7th - 11th Grade
10 questions
SUMATIF LINGKUP MATERI BERPIKIR KOMPUTASIONAL
Quiz
•
9th - 12th Grade
10 questions
Operator dan Fungsi Dasar Google Sheets
Quiz
•
9th Grade
10 questions
9 Вычисление в электронных таблицах
Quiz
•
9th Grade
10 questions
Struktur Database
Quiz
•
9th - 12th Grade
15 questions
Code.org CSP Unit 1 Review
Quiz
•
9th - 12th Grade
12 questions
Excel Basics
Quiz
•
5th - 10th Grade
15 questions
Soal tentang Blog kelas 9
Quiz
•
9th Grade
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
Discover more resources for Computers
10 questions
Navigating Digital Citizenship and Online Safety
Interactive video
•
6th - 10th Grade
20 questions
Computer / Internet Companies
Quiz
•
9th Grade
10 questions
Exploring the Basics of Google Sheets
Interactive video
•
9th Grade
10 questions
Exponent Rules
Quiz
•
9th - 12th Grade
20 questions
JavaScript - Karel
Quiz
•
9th - 10th Grade