Ujian Teori Microsoft Excel
Authored by CHATARINA OKTAVILIA
Computers
11th Grade
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
35 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa fungsi dasar dari Excel?
Mengedit video
Untuk mengolah dan menganalisis data.
Mengirim email massal
Membuat presentasi visual
Mengolah dan menganalisis angka
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Sebutkan tiga rumus dasar yang sering digunakan di Excel!
PRODUCT, MEDIAN, SUM
SUM, AVERAGE, COUNT
MEDIAN, COUNT, PRODUCT
MAX, MINT, MEDIAN
AVERAGE, MINT, PRODUCT
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana cara membuat grafik batang di Excel?
Pilih grafik, klik 'Chart', lalu pilih 'Column Chart'.
Pilih data, klik 'File', lalu pilih 'Pie Chart'.
Pilih data, klik 'Home', lalu pilih 'Line Chart'.
Pilih data, klik 'Insert', lalu pilih 'Bar Chart'.
Pilih data, klik 'File', lalu pilih 'Bar Chart'.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus Excel yang digunakan untuk menjumlahkan sel A1 sampai A10 adalah...
=SUM(A1:A10)
=TOTAL(A1+A10)
=ADD(A1:A10)
=COUNT(A1:A10)
=SUM(A1,A10)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jelaskan cara menggunakan fungsi VLOOKUP!
Fungsi VLOOKUP digunakan untuk mencari nilai dalam tabel berdasarkan kolom.
Fungsi VLOOKUP digunakan untuk mengurutkan data dalam tabel.
Fungsi VLOOKUP hanya dapat digunakan untuk mencari nilai di kolom terakhir.
Fungsi VLOOKUP digunakan untuk menghitung jumlah total dalam tabel.
Fungsi VLOOKUP digunakan untuk mencari nilai dalam tabel berdasarkan baris.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa yang dimaksud dengan fungsi IF di Excel?
Digunakan untuk menguji kondisi dan mengembalikan nilai berdasarkan hasil pengujian tersebut.
Fungsi IF di Excel digunakan untuk membuat grafik.
Fungsi IF di Excel adalah untuk mengurutkan data.
Fungsi IF di Excel digunakan untuk menghitung rata-rata.
Digunakan untuk menguji kondisi dan menjumlahkan nilai berdasarkan hasil pengujian tersebut.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk menghitung rata-rata dari sel B2 hingga B8, rumus yang benar adalah...
=MEAN(B2:B8)
=AVERAGE(B2:B8)
=TOTAL(B2:B8)/7
=SUM(B2:B8)
=RATA(B2:B8)
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
30 questions
UKD3 Multimedia 11
Quiz
•
11th Grade
40 questions
Empowerment Technology
Quiz
•
11th Grade
30 questions
SOAL PERANGKAT KOMPUTER
Quiz
•
11th Grade
36 questions
UJIAN TIK
Quiz
•
9th - 12th Grade
30 questions
Excel Exam 1: Multiple Choice
Quiz
•
9th - 12th Grade
40 questions
MID EXAM GRAPHIC DESIGN
Quiz
•
11th Grade
30 questions
ADMINISTRASI INFRASTRUKTUR JARINGAN
Quiz
•
11th Grade
30 questions
J808 LO1 End of Module Assessment
Quiz
•
10th - 11th Grade
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
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
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade
10 questions
Valentine's Day: History and Modern Celebration
Interactive video
•
9th - 12th Grade
11 questions
Valentine's Day Trivia
Quiz
•
8th - 12th Grade
10 questions
Factor Quadratic Expressions with Various Coefficients
Quiz
•
9th - 12th Grade
10 questions
Evaluating Piecewise Functions Practice
Quiz
•
11th Grade
18 questions
Success Strategies
Quiz
•
9th - 12th Grade