Pre Test - Microsoft Excel
Authored by Ahmad firdaus
Information Technology (IT)
10th Grade
Used 1+ 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
Fungsi utama dari Microsoft Excel adalah…
Mengedit foto
Menghitung dan menganalisis data
Membuat presentasi
Mengedit video
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi apa yang digunakan untuk menghitung jumlah seluruh angka dalam sebuah rentang sel di Microsoft Excel?
MAX
MIN
SUM
AVERAGE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk mencari nilai tertinggi dalam sebuah rangkaian angka di Excel adalah?
AVERAGE
SUM
MAX
MIN
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mencari nilai terendah dalam sebuah rentang data di Excel, rumus yang digunakan adalah?
MAX
MIN
AVERAGE
SUM
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk mencari nilai rata-rata dari sekumpulan data di Excel adalah?
SUM
MAX
MIN
AVERAGE
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berikut ini adalah data dalam sel A1 hingga A5: 12, 15, 8, 20, 30. Rumus untuk menghitung jumlah total seluruh data tersebut adalah?
=MAX(A1:A5)
=AVERAGE(A1:A5)
=MIN(A1:A5)
=SUM(A1:A5)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika data dalam sel B1 hingga B4 adalah 10, 25, 40, dan 55, maka rumus untuk mencari nilai rata-rata adalah?
=MAX(B1:B4)
=MIN(B1:B4)
=AVERAGE(B1:B4)
=SUM(B1:B4)
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
12 questions
Aplikasi Digital
Quiz
•
10th Grade
10 questions
POST TEST - PRESENTASI - OKT 24
Quiz
•
10th Grade
15 questions
X - BAB 5 - Analisis Data - Pengantar - Faris
Quiz
•
10th Grade
10 questions
Soal Informatika
Quiz
•
10th Grade
10 questions
FUNGSI REFERENCE
Quiz
•
8th Grade - University
10 questions
EXCEL
Quiz
•
9th - 12th Grade
10 questions
Informatika 2
Quiz
•
7th Grade - University
15 questions
6-sinfl. Ofis dasturlari va Scratch
Quiz
•
6th Grade - University
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
Discover more resources for Information Technology (IT)
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade
20 questions
Cell Organelles
Quiz
•
10th Grade
25 questions
Complementary and Supplementary Angles
Quiz
•
7th - 10th Grade
12 questions
Add and Subtract Polynomials
Quiz
•
9th - 12th Grade
13 questions
Model Exponential Growth and Decay Scenarios
Quiz
•
9th - 12th Grade
10 questions
Exploring the Layers of the Earth
Interactive video
•
6th - 10th Grade