KUIS
10th Grade
•5 Qs
Similar activities
DE 2 - ACCESS
9th - 12th Grade
•10 Qs
Programming Terms
8th - 10th Grade
•10 Qs
Latihan spread sheet
10th Grade
•10 Qs
Pre - Post Subnet+Konfigurasi IP
10th Grade
•10 Qs
Python Матрицы
10th - 11th Grade
•10 Qs
KODEKIDDO HACK #MLH3
4th Grade - University
•10 Qs
TIN 10_B22_LIST
10th Grade
•10 Qs
Microsoft Publisher
7th - 10th 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
BTEC DIT C3 LAA - Impact on organisations
Quiz
•
10th - 11th Grade
10 questions
MICROSOFT EXCEL
Quiz
•
9th - 11th Grade
10 questions
Python массив
Quiz
•
9th - 12th Grade
10 questions
Google Docs - Tables
Quiz
•
9th - 10th Grade
10 questions
Quiz - Ls.4 - Advanced Features of Word Processor(Part 2)
Quiz
•
4th Grade - Professio...
10 questions
R093 - Topic 2 Factors Influencing Product Design
Quiz
•
9th - 12th Grade
10 questions
STM BTEC DIT Component 3 -1. Communication Technologies p140
Quiz
•
9th - 10th Grade
10 questions
MOAC Excel 2016 Lesson 01
Quiz
•
8th - 12th 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
