Spreadsheet
Quiz
•
Computers
•
1st - 3rd Grade
•
Practice Problem
•
Medium
Mohammad Ishak
Used 299+ times
FREE Resource
Enhance your content in a minute
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perangkat Lunak yang bisa digunakan untuk praktek spreadsheet adalah :
Coreldraw
Photoshop
Camtasia
Microsoft PowerPoint
Microsoft Excel
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa yang dimaksud dengan range dalam excel?
Kumpulan dari worksheet
Kumpulan beberapa sel
Pertemuan antara baris dan kolom
Pertemuan antara sel dengan range
Lembar kerja dalam excel
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus atau fungsi yang benar untuk isi sel E6 adalah
=SUM(B5:D5)
=B6+C6+D6
=SUM(A6:D6)
=C6+D6+E6
=B5+C6+D6
4.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
Rumus atau Fungsi di sel F6, yang salah di bawah ini adalah :
=average(b6:d6)
=average(e6)
=(b6+c6+d6)/3
=e6/3
=average(b6:e6)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan tabel berikut ini, untuk mengisi rumus atau fungsi di sel B14 adalah...
=MIN(B6:B13)
=MAX(B6:B13)
=SUM(B6:B13)
COUNT(B6:B13)
=MAX(B5:B13)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan tabel berikut ini, untuk mengisi rumus atau fungsi untuk mencari nilai terrendah di sel B15 adalah...
=MAX(B5:B13)
=MAX(B6:B13)
=MIN(B6:B13)
=MAX(B5:B14)
=ABS(B6:B13)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk menghitung jumlah sel-sel, dimana sel-sel tesebut tidak bernilai (null).
Fungsi COUNTIF
Fungsi COUNTA
Fungsi COUNT
Fungsi COUNTBLANK
Fungsi COUNTBLANKA
Create a free account and access millions of resources
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
20 questions
ULANGAN AIJ
Quiz
•
3rd Grade
15 questions
Kuis Excel & PPT
Quiz
•
1st Grade
20 questions
Pre Test Administrasi Infrastruktur Jaringan
Quiz
•
1st Grade
13 questions
QUIZ ANALISIS & ESTIMASI BIAYA PART 2
Quiz
•
1st Grade
10 questions
Perangkat Keras Komputer
Quiz
•
1st Grade
20 questions
TIK KD 3
Quiz
•
1st - 12th Grade
20 questions
Design Brief
Quiz
•
1st - 3rd Grade
15 questions
Object Oriented Programming
Quiz
•
1st Grade
Popular Resources on Wayground
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
15 questions
Solving Equations with Variables on Both Sides Review
Quiz
•
8th Grade
Discover more resources for Computers
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
10 questions
Area
Quiz
•
3rd Grade
8 questions
Predictions
Quiz
•
2nd - 4th Grade
17 questions
Multiplication facts
Quiz
•
3rd Grade
10 questions
Fractions
Quiz
•
3rd Grade
20 questions
Division Facts
Quiz
•
3rd Grade
25 questions
Division Facts
Quiz
•
3rd Grade
