KUIS
10th Grade
•5 Qs
Similar activities
INFORMATIKA
10th Grade
•10 Qs
PHIẾU HỌC TẬP 1
3rd - 12th Grade
•10 Qs
Iteration Assessment
9th - 10th Grade
•10 Qs
ATC Review
9th - 12th Grade
•10 Qs
Grafik Pada Microsoft Excel
7th - 12th Grade
•10 Qs
AppsLab_Q2
10th Grade - Professional Development
•10 Qs
Aplikasi Pengolah Angka
10th Grade
•10 Qs
HCI Quiz #1
1st - 12th Grade
•10 Qs
KUIS
Quiz
•
Computers
•
10th Grade
•
Practice Problem
•
Medium
YULIA SARI
Used 6+ times
FREE Resource
Enhance your content in a minute
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 20 pts
Fungsi SUMIF dalam Microsoft Excel digunakan untuk......
Menghitung jumlah data berdasarkan lebih dari satu kriteria
Menjumlahkan nilai berdasarkan satu kriteria tertentu
Mengurutkan data berdasarkan nilai terbesar
Menyalin data ke sel lain secara otomatis
2.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Sintaks dari fungsi SUMIF yang benar adalah....
SUMIF(range;sum_range;criteria)
SUMIF(criteria;range;sum_range)
SUMIF(range;criteria;sum_range)
SUMIF(sum_range;range;criteria)
3.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Untuk fungsi SUMIFS dalam Microsoft Excel digunakan untuk.....
Menjumlahkan jumlah data berdasarkan lebih dari satu kriteria
Menghitung nilai berdasarkan satu kriteria tertentu
Mengurutkan data berdasarkan nilai terbesar
Menyalin data ke sel lain secara otomatis
4.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Manakah di bawah ini yang merupakan sintaks SUMIFS yang benar.....
SUMIFS(sum_range;criteria_range1;criteria1)
SUMIFS(criteria_range1;sum_range;criteria1)
SUMIFS(sum_range;criteria1;criteria_range1)
SUMIFS(criteria1;criteria_range1;sum_range)
5.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Perbedaan utama antara SUMIF dan SUMIFS adalah.....
SUMIF hanya bisa menjumlahkan teks
SUMIFS hanya menjumlahkan data yang sama
SUMIF untuk penjumlahan data satu kriteria, SUMIFS untuk penjumlahan data banyak kriteria
SUMIFS hanya bisa digunakan jika ada grafik
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
Working with tables
Quiz
•
5th - 12th Grade
10 questions
10 CS // Pseudocode
Quiz
•
9th - 11th Grade
10 questions
Excel Data Validation Quiz
Quiz
•
9th - 12th Grade
10 questions
RUMUS EXCEL
Quiz
•
10th Grade
9 questions
Digital Audio Sound Principles
Quiz
•
9th - 12th Grade
10 questions
Pretest Mesin Pencari
Quiz
•
10th Grade
10 questions
NETWORK DEVICES
Quiz
•
10th Grade
10 questions
Programming Errors and Tests
Quiz
•
10th Grade
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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade
