Excel Lanjut
9th - 12th Grade
•12 Qs
Similar activities
QUIZ - Microsoft Excel
10th Grade
•13 Qs
Analisis Data (Kelas X4) (2)
10th Grade
•10 Qs
Ulangan Harian TIk Kelas X
10th Grade
•10 Qs
MS WORD
10th Grade
•10 Qs
Ulangan Harian 1
11th Grade
•15 Qs
Excel Quis Before Examination
11th Grade
•10 Qs
Rumus Spreadsheet MS Excel
9th Grade
•10 Qs
Uji Pemahaman Fungsi Excel
9th Grade
•13 Qs
Excel Lanjut
Quiz
•
Computers
•
9th - 12th Grade
•
Hard
Weni Sulistyono
Used 4+ times
FREE Resource
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 4 pts
Rumus untuk mengisi sel L7 adalah?
=AVERAGE(D12:E12)
=AVERAGE(H7:I7)
=AVERAGE(F10:G10)
=AVERAGE(H13:I13)
2.
MULTIPLE CHOICE QUESTION
20 sec • 4 pts
Rumus untuk mengisi sel M11 adalah?
=AVERAGE(D12:E12)
=AVERAGE(F13:G13)
=AVERAGE(J6:L6)
=AVERAGE(J11:L11)
3.
MULTIPLE CHOICE QUESTION
20 sec • 4 pts
Rumus untuk mengisi sel N13 adalah?
=ROUND(M13;0)
=ROUND(F6:G6;2)
=ROUND(D13:I13;0)
=ROUND(K18;2)
4.
MULTIPLE CHOICE QUESTION
20 sec • 4 pts
Dengan kriteria jika nilai (pembulatan) >=70 "lulus" dan <70 "remidi" maka rumus untuk mengisi sel P9 adalah...?
=IF(J10>=70;"Lulus";"Remidi")
=IF(L13>=70;"Lulus";"Remidi")
=IF(M6>=70;"Lulus";"Remidi")
=IF(N9>=70;"Lulus";"Remidi")
5.
MULTIPLE CHOICE QUESTION
20 sec • 4 pts
Dengan kriteria jika nilai (pembulatan) >=90 skor "A", >=80 skor "B", >=70 skor "C" dan <70 skor "D" maka rumus untuk mengisi sel O6 adalah...?
=IF(K13>=90;"A";IF(K13>=80;"B";IF(K13>=70;"C";IF(K13<70;"D"))))
=IF(N6>=90;"A";IF(N6>=80;"B";IF(N6>=70;"C";IF(N6<70;"D"))))
=IF(M11>=90;"A";IF(M11>=80;"B";IF(M11>=70;"C";IF(M11<70;"D"))))
=IF(J6>=90;"A";IF(J6>=80;"B";IF(J6>=70;"C";IF(J6<70;"D"))))
6.
MULTIPLE CHOICE QUESTION
20 sec • 4 pts
Untuk menghitung siswa laki-laki yang nilainya >=75 maka rumus untuk mengisi sel E16 adalah...?
=COUNTIF(C6:C13;"L";E6:E13;">=75")
=COUNTIFS(C6:C13;"L";D6:D13;">75")
=COUNT(C6:C13;"L";E6:E13;">=75")
=COUNTIFS(C6:C13;"L";E6:E13;">=75")
7.
MULTIPLE CHOICE QUESTION
20 sec • 4 pts
Untuk menghitung siswa laki-laki yang nilainya >=75 maka rumus untuk mengisi sel I19 adalah...?
=COUNTIFS(C6:C13;"P";I6:I13;"<75")
=COUNTIFS(C6:C13;"P";I6:I13;">75")
=COUNTIFS(C6:C13;"P";;G6:G13;"<75")
=COUNTIFS(C6:C13;"P";E6:E13;"<75")
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
excel firts
Quiz
•
10th Grade
15 questions
Pre Test Aplikasi Perkantoran
Quiz
•
10th Grade
10 questions
RUMUS EXCEL
Quiz
•
10th Grade
10 questions
Analisis Data (1)
Quiz
•
10th Grade
10 questions
Assesmen Sumatif Penerapan Fungsi IF dan IF bertingkat
Quiz
•
12th Grade
15 questions
APLIKASI SPREADSHEET
Quiz
•
10th Grade
10 questions
INFORMATIKA 1 - OFFICE
Quiz
•
9th - 12th Grade
10 questions
Aplikasi Pengolah Slide (Powerpoint)
Quiz
•
10th Grade
Popular Resources on Wayground
10 questions
Video Games
Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines
Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22
Lesson
•
9th - 12th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
20 questions
US Constitution Quiz
Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
20 questions
Analog vs Digital
Quiz
•
9th - 12th Grade
10 questions
CTEA Computer Vocab Terms #1
Quiz
•
12th Grade
10 questions
Exploring Cybersecurity Techniques and Threats
Interactive video
•
6th - 10th Grade
10 questions
Understanding the Internet and Data Transmission
Interactive video
•
7th - 12th Grade