Rumus untuk mengisi sel L7 adalah?
Excel Lanjut
9th - 12th Grade
•12 Qs
Similar activities
Post Test Excel Logika IF
10th Grade
•10 Qs
fungsi vlookup
10th Grade
•15 Qs
excel
10th Grade
•10 Qs
RUMUS FUNGSI EXCEL
7th - 9th Grade
•10 Qs
Pos Tes Laporan Bisnis
10th Grade
•10 Qs
HOJA DE CALCULO APLICADA
11th Grade
•15 Qs
Penilaian Harian 1 Ms. Excel (Kondisi IF)
1st - 12th Grade
•10 Qs
quiz IF EXCEL
12th Grade
•15 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
=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
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Quizizz
10 questions
Quiz Pengolahan Angka
Quiz
•
10th Grade
10 questions
Post Test Excel Logika IF
Quiz
•
10th Grade
10 questions
Quiz bab 6 informatika kelas X
Quiz
•
10th Grade
11 questions
Soal Fungsi Logika IF
Quiz
•
12th Grade
15 questions
Excel Formula
Quiz
•
10th Grade
10 questions
SOAL EVALUASI MICROSOFT EXCEL
Quiz
•
12th Grade
10 questions
COUNT FORMULA EXCEL
Quiz
•
10th Grade
9 questions
ASESMEN KE_2 RUMUS DAN FUNGSI
Quiz
•
11th Grade
Popular Resources on Quizizz
15 questions
Character Analysis
Quiz
•
4th Grade
17 questions
Chapter 12 - Doing the Right Thing
Quiz
•
9th - 12th Grade
10 questions
American Flag
Quiz
•
1st - 2nd Grade
20 questions
Reading Comprehension
Quiz
•
5th Grade
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
18 questions
Full S.T.E.A.M. Ahead Summer Academy Pre-Test 24-25
Quiz
•
5th Grade
14 questions
Misplaced and Dangling Modifiers
Quiz
•
6th - 8th Grade
Discover more resources for Computers
17 questions
Chapter 12 - Doing the Right Thing
Quiz
•
9th - 12th Grade
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
20 questions
Taxes
Quiz
•
9th - 12th Grade
17 questions
Parts of Speech
Quiz
•
7th - 12th Grade
20 questions
Chapter 3 - Making a Good Impression
Quiz
•
9th - 12th Grade
20 questions
Inequalities Graphing
Quiz
•
9th - 12th Grade
10 questions
Identifying equations
Quiz
•
KG - University