Latihan Excel
Authored by YIS Animation
Information Technology (IT)
10th Grade
Used 54+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Seorang manajer proyek sedang mengelola anggaran proyek menggunakan Microsoft Excel. Dia perlu menyusun laporan keuangan bulanan. Bagaimana cara dia menyusun rumus untuk menghitung total pengeluaran proyek setiap bulan?
=SUM(B2:B30)
=MAX(B2:B30)
=AVERAGE(B2:B30)
=MIN(B2:B30)
=COUNT(B2:B30)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Seorang pemilik toko ingin menghitung rata-rata penjualan harian selama seminggu. Bagaimana rumus Excel yang sebaiknya digunakan?
=SUM(B2:B8)
=AVERAGE(B2:B8)
=MAX(B2:B8)
=MIN(B2:B8)
=COUNT(B2:B8)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Seorang peneliti ingin mengetahui berapa jumlah data yang memiliki nilai di atas 50 dalam rentang A1 hingga A20. Rumus Excel yang tepat untuk menghitungnya adalah?
=IF(A1:A20 > 50, 1, 0)
=COUNTIF(A1:A20, ">50")
=AVERAGE(A1:A20)
=SUM(A1:A20)
=COUNT(A1:A20)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Seorang sekretaris ingin menyatukan sel-sel A1 hingga C1 menjadi satu sel yang besar. Apa langkah yang tepat untuk melakukan ini di Excel?
Klik kanan pada sel dan pilih Merge Cells.
Pilih sel A1 hingga C1 dan tekan tombol Ctrl + M.
Gunakan fungsi =MERGE(A1:C1).
Pilih sel A1 hingga C1, lalu pilih menu Merge di tab Home.
Gunakan rumus =CONCATENATE(A1, B1, C1)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
untuk memberikan satu nilai jika kondisi benar dan nilai lain jika kondisi salah, kita dapat menggunakan formula ?
SUMIFS
IF
COUNT
AVERAGEIF
COUNTIF
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
untuk mengisi cel berwarna merah kita dapat membuat rumus berikut!
=SUM(C3:F3)
=SUM(C3;F3)
=AVERAGE(C3:F3)
=AVERAGE(C3;F3)
=SUM(C3:F5)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
untuk mengisi cel berwarna kuning kita dapat membuat rumus berikut
=MAX(C3:F3)
=MAX(C3:F4)
=MAX(C4:F4)
=MAX(C4:G4)
=MAX(C4:D4)
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
15 questions
Chestionar pentru lecția - Funcțiile în Excel
Quiz
•
10th Grade
10 questions
PEMBELAJARAN KOMPUTASIONAL
Quiz
•
10th Grade
10 questions
Assesment Diagnostik Awal Kognitif TIK
Quiz
•
10th Grade
20 questions
X ULP 1 - SOAL MS. WORD, MS. EXCEL., MAIL MERGE
Quiz
•
10th Grade
20 questions
Evaluasi Pemahaman Analisis Data
Quiz
•
10th Grade
20 questions
Quiz Berpikir Komputasional
Quiz
•
10th Grade
10 questions
Post Test VLOOKUP dan HLOOKUP
Quiz
•
10th Grade
20 questions
QUIS TIK BY FATAHUL
Quiz
•
9th - 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
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Cell Organelles and Their Functions
Interactive video
•
6th - 10th Grade
22 questions
El Imperfecto
Quiz
•
9th - 12th Grade
20 questions
SSS/SAS
Quiz
•
9th - 12th Grade
20 questions
verbos reflexivos en español
Quiz
•
9th - 12th Grade
14 questions
Making Inferences From Samples
Quiz
•
7th - 12th Grade
23 questions
CCG - CH8 Polygon angles and area Review
Quiz
•
9th - 12th Grade
8 questions
Momentum and Collisions
Lesson
•
9th - 12th Grade