Excel Lanjut
9th - 12th Grade
•12 Qs
Similar activities
Post Test Fungsi Logika
10th Grade
•10 Qs
UJIAN TRYOUT II TIK KELAS IX
9th Grade
•15 Qs
ULANGAN HARIAN KELAS 9 SEMESTER 1 TA. 2024/2025
9th Grade
•10 Qs
KUIS KELAS 9
9th Grade
•10 Qs
RUMUS MATEMATIKA
10th Grade
•10 Qs
Google Sheets - IF
11th Grade
•10 Qs
HAVE FUN
11th Grade
•10 Qs
Informatika x AKL
10th Grade
•11 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
REMEDIAL SIMDIG
Quiz
•
10th Grade
10 questions
Postes
Quiz
•
10th Grade
10 questions
Post Test Excel Logika IF
Quiz
•
10th Grade
10 questions
Quiz Sesi Kedua
Quiz
•
1st - 12th Grade
10 questions
Data Analytic Unit5-1
Quiz
•
12th Grade
16 questions
ASK Ting 1 : Bab 1.1
Quiz
•
7th - 12th Grade
15 questions
UH 1 SPREADSHEET X-2
Quiz
•
10th Grade
10 questions
Ms Excel 101 Series - Intermediate Level
Quiz
•
12th Grade
Popular Resources on Wayground
10 questions
Lab Safety Procedures and Guidelines
Interactive video
•
6th - 10th Grade
10 questions
Nouns, nouns, nouns
Quiz
•
3rd Grade
10 questions
9/11 Experience and Reflections
Interactive video
•
10th - 12th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
11 questions
All about me
Quiz
•
Professional Development
22 questions
Adding Integers
Quiz
•
6th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
9 questions
Tips & Tricks
Lesson
•
6th - 8th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
10 questions
1.2 OSI & TCP IP Models Quiz
Quiz
•
10th Grade
20 questions
Digital Citizenship
Quiz
•
8th - 12th Grade
30 questions
Introduction to Computers
Quiz
•
8th - 9th Grade
35 questions
Computer Baseline Examination 2025-26
Quiz
•
9th - 12th Grade
13 questions
Problem Solving Process
Quiz
•
9th - 12th Grade
20 questions
Hardware vs. Software Quiz
Quiz
•
7th - 10th Grade
10 questions
Understanding Algorithms with Pseudocode and Flowcharts
Interactive video
•
9th - 12th Grade