Analisis Data
9th - 12th Grade
•10 Qs
Similar activities
Remedial PTS KKPI
11th Grade
•9 Qs
Asesmen Formatif Google Sheet - Part 1
11th Grade - University
•10 Qs
Referencias & Funciones Básicas Excel
11th Grade
•10 Qs
Ulangan Harian Analisis Data (Perbaikan dan Susulan)
9th - 12th Grade
•15 Qs
PTS GANJIL - TIK (XI)
11th Grade
•15 Qs
Ms. Excel
10th Grade
•15 Qs
Microsoft Excel
10th Grade
•10 Qs
SOAL EVALUASI MICROSOFT EXCEL
12th Grade
•10 Qs
Analisis Data
Quiz
•
Computers
•
9th - 12th Grade
•
Medium
Dadang Abdurochman
Used 1+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
3 mins • 10 pts
Perhatikan gambar dibawah ini!
Operator fungsi (Rumus) yang digunakan untuk mengetahui hasil Nilai rata-rata cell H5 dari hasil penjumlahan nilai yang didapat oleh Defa adalah…
=average(D5:G5)
=average(D6:G6)
=average(D7:G7)
=average(D8:G8)
=average(D4:G4)1
2.
MULTIPLE CHOICE QUESTION
3 mins • 10 pts
Perhatikan gambar dibawah ini!
Operator fungsi (Rumus) yang digunakan untuk mengetahui hasil Nilai Terendah pada cell D12 dari hasil perhitungan pada coloumn jumlah nilai siswa adalah…
=min(D5:D10)
=min(H5:H10)
=min (E5:E10)
=min (F5:F10)
=min (G5:G10)
3.
MULTIPLE CHOICE QUESTION
3 mins • 10 pts
Perhatikan tabel laporan penjualan berikut ini !
Dari tabel di atas, Rumus 1 untuk mencari Harga Total adalah….
=C1xD1
=C2xD2
=C2/D2
=C1*D1
=C2*D2
4.
MULTIPLE CHOICE QUESTION
3 mins • 10 pts
Perhatikan tabel laporan penjualan berikut ini !
Dari tabel diatas , Rumus 2 untuk mencari Jumlah Harga Total adalah ….
=average(E2:E5)
=min(E2:E5)
=sum(E2:E5)
=max(E2..E5)
=count(E2:E5)
5.
MULTIPLE CHOICE QUESTION
3 mins • 10 pts
Perhatikan tabel laporan penjualan berikut ini !
Dari tabel diatas, Rumus 3 untuk mencari Harga Total Tertinggi adalah ….
=count(E2:E5)
=max(E2:E5)
=min(E2:E5)
=average(E2:E5)
=sum(E2:E5)
6.
MULTIPLE CHOICE QUESTION
3 mins • 10 pts
Perhatikan tabel laporan penjualan berikut ini !
Dari tabel diatas, Rumus 4 untuk mencari Harga Total Terendah adalah ….
=max(E2:E5)
=count(E2:E5)
=average(E2:E5)
=sum(E2:E5)
=min(E2:E5)
7.
MULTIPLE CHOICE QUESTION
3 mins • 10 pts
Jika sebuah operasi matematika 2+3=5, 5-4=1, 6:2=3, maka penulisan yang tepat dalam oparator pada Ms. Excel adalah…
=2+3, =5-4, =6/2
=2+3, 5-4=, =6-2
5=2+3, 1=5-4, 3=6:2
=2+3, =5-4, =6:2
5=2+3, 1=5-4, 3=6/2
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
UH EXCEL TIK
Quiz
•
10th Grade
14 questions
Ms Excel
Quiz
•
10th Grade
10 questions
Spreadsheet 1
Quiz
•
10th Grade
15 questions
ÔN TẬP TIN HỌC 7 TUẦN 7 25-30/10/2021
Quiz
•
6th - 9th Grade
10 questions
Latihan Soal ICT (Blog & Excel)
Quiz
•
8th - 11th Grade
10 questions
Aplikasi Pengolah Angka
Quiz
•
10th Grade
5 questions
Preguntas sobre Fórmulas de Excel
Quiz
•
10th Grade
10 questions
POST-TEST (X-8)
Quiz
•
10th Grade - University
Popular Resources on Wayground
11 questions
Hallway & Bathroom Expectations
Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS
Quiz
•
6th - 8th Grade
10 questions
"LAST STOP ON MARKET STREET" Vocabulary Quiz
Quiz
•
3rd Grade
19 questions
Fractions to Decimals and Decimals to Fractions
Quiz
•
6th Grade
16 questions
Logic and Venn Diagrams
Quiz
•
12th Grade
15 questions
Compare and Order Decimals
Quiz
•
4th - 5th Grade
20 questions
Simplifying Fractions
Quiz
•
6th Grade
20 questions
Multiplication facts 1-12
Quiz
•
2nd - 3rd Grade
