Excel Lanjut
9th - 12th Grade
•12 Qs
Similar activities
Entry Data dengan Rumus Statistika di Ms. Excel
10th Grade - University
•7 Qs
soal latihan operator matematika
8th - 9th Grade
•10 Qs
Pengenalan Spreadsheet
10th Grade
•15 Qs
RUMUS EXCEL
10th Grade
•10 Qs
fungsi vlookup
10th Grade
•15 Qs
Analisis Data (1)
10th Grade
•10 Qs
Absolut
10th Grade
•10 Qs
X ULP/ Ms.Excel
10th Grade
•10 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
10 questions
X ULP/ Ms.Excel
Quiz
•
10th Grade
10 questions
Quiz bab 6 informatika kelas X
Quiz
•
10th Grade
7 questions
Entry Data dengan Rumus Statistika di Ms. Excel
Quiz
•
10th Grade - University
15 questions
Pengenalan Spreadsheet
Quiz
•
10th Grade
10 questions
Microsoft Excel
Quiz
•
12th Grade
9 questions
ASESMEN KE_2 RUMUS DAN FUNGSI
Quiz
•
11th Grade
10 questions
RUMUS EXCEL
Quiz
•
10th Grade
10 questions
Analisis Data (1)
Quiz
•
10th Grade
Popular Resources on Wayground
50 questions
Trivia 7/25
Quiz
•
12th Grade
11 questions
Standard Response Protocol
Quiz
•
6th - 8th Grade
11 questions
Negative Exponents
Quiz
•
7th - 8th Grade
12 questions
Exponent Expressions
Quiz
•
6th Grade
4 questions
Exit Ticket 7/29
Quiz
•
8th Grade
20 questions
Subject-Verb Agreement
Quiz
•
9th Grade
20 questions
One Step Equations All Operations
Quiz
•
6th - 7th Grade
18 questions
"A Quilt of a Country"
Quiz
•
9th Grade
Discover more resources for Computers
50 questions
Trivia 7/25
Quiz
•
12th Grade
20 questions
Subject-Verb Agreement
Quiz
•
9th Grade
18 questions
"A Quilt of a Country"
Quiz
•
9th Grade
6 questions
RL.10.1 Cite Evidence
Quiz
•
10th Grade
10 questions
Characteristics of Life
Quiz
•
9th - 10th Grade
14 questions
Algebra 1 SOL Review #1
Quiz
•
9th Grade