Rumus untuk mengisi sel L7 adalah?
Excel Lanjut
9th - 12th Grade
•12 Qs
Similar activities
Pengolahan Data Dasar
10th Grade - University
•10 Qs
RUMUS FUNGSI EXCEL
7th - 9th Grade
•10 Qs
Pos Tes Laporan Bisnis
10th Grade
•10 Qs
APLIKASI PROGRAM PENGOLAH ANGKA
12th Grade
•10 Qs
Excel pemula
10th Grade
•16 Qs
Penilaian Harian 1 Ms. Excel (Kondisi IF)
1st - 12th Grade
•10 Qs
Post Test Excel Logika IF
10th Grade
•10 Qs
Quiz analisis data kelas 9
9th 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
15 questions
Ms. Exel dan Fungsi Logika IF
Quiz
•
10th Grade - University
10 questions
ULANGAN HARIAN KELAS 9 SEMESTER 1 TA. 2024/2025
Quiz
•
9th Grade
14 questions
Spreadsheets - H Admin
Quiz
•
12th Grade
15 questions
PTS Ganjil SKD 2020
Quiz
•
10th Grade
13 questions
QUIZ - Microsoft Excel
Quiz
•
10th Grade
13 questions
Uji Pemahaman Fungsi Excel
Quiz
•
9th Grade
10 questions
Google Sheets - IF
Quiz
•
11th Grade
10 questions
Rumus Spreadsheet MS Excel
Quiz
•
9th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts
Quiz
•
4th Grade
20 questions
Math Review - Grade 6
Quiz
•
6th Grade
20 questions
math review
Quiz
•
4th Grade
5 questions
capitalization in sentences
Quiz
•
5th - 8th Grade
10 questions
Juneteenth History and Significance
Interactive video
•
5th - 8th Grade
15 questions
Adding and Subtracting Fractions
Quiz
•
5th Grade
10 questions
R2H Day One Internship Expectation Review Guidelines
Quiz
•
Professional Development
12 questions
Dividing Fractions
Quiz
•
6th Grade
Discover more resources for Computers
25 questions
Spanish preterite verbs (irregular/changed)
Quiz
•
9th - 10th Grade
10 questions
Identify Slope and y-intercept (from equation)
Quiz
•
8th - 9th Grade
10 questions
Juneteenth: History and Significance
Interactive video
•
7th - 12th Grade
8 questions
"Keeping the City of Venice Afloat" - STAAR Bootcamp, Day 1
Quiz
•
9th - 12th Grade
26 questions
June 19th
Quiz
•
4th - 9th Grade
20 questions
Distance, Midpoint, and Slope
Quiz
•
10th Grade
20 questions
Figurative Language Review
Quiz
•
10th Grade
27 questions
STAAR English 1 Review
Quiz
•
9th Grade