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
Pseudocode - Arrays
Quiz
•
8th - 11th Grade
15 questions
9-Sinf III chorak CHSB
Quiz
•
9th Grade
10 questions
2.2 MAC Address
Quiz
•
9th - 10th Grade
10 questions
Comp Sci - KS3 - MS Excel Spreadsheet Formulas 1
Quiz
•
9th Grade
10 questions
Электронные таблица
Quiz
•
9th - 10th Grade
15 questions
ICT Ms Excel Comprehension Test
Quiz
•
8th - 9th Grade
12 questions
Skaičiuoklė Excel
Quiz
•
9th Grade
7 questions
Excel Formulas
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