
Latihan Excel

Quiz
•
Information Technology (IT)
•
10th Grade
•
Medium
YIS Animation
Used 54+ times
FREE Resource
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)
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Introduction to Excel

Quiz
•
10th Grade
20 questions
Informatika

Quiz
•
8th Grade - University
20 questions
Quizizz SIOTICS #2

Quiz
•
10th Grade - University
10 questions
MICROSOFT EXCEL

Quiz
•
10th Grade
10 questions
ASSESMEN SUMATIF

Quiz
•
2nd Grade - University
15 questions
Sumatif 2-TIK Kelas 8

Quiz
•
8th Grade - University
20 questions
Quizz Informatika Analisis Data Kelas 9

Quiz
•
9th Grade - University
15 questions
Uji Pemahaman Aplikasi Microsoft

Quiz
•
10th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Information Technology (IT)
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
28 questions
Ser vs estar

Quiz
•
9th - 12th Grade
10 questions
Exploring Newton's Laws of Motion

Interactive video
•
6th - 10th Grade
20 questions
Cell organelles and functions

Quiz
•
10th Grade
10 questions
Colonial Grievances Against the King Quiz

Quiz
•
10th Grade
13 questions
BizInnovator Startup - Experience and Overview

Quiz
•
9th - 12th Grade