Kerjakan Latihan berikut! isilah nomor yang di cetak merah!
Tulislah ulang formula yang anda kerjakan di selembar kertas!
================================================================
=================================================================
Tulislah ulang formula yang anda kerjakan di selembar kertas!
================================================================
| Soal 1 | | | | | ||
| Daftar Nilai Pelajaran Komputer | | | | | ||
| | | | | | | |
| No | Nama | Nilai | Total Nilai | Rata-rata | ||
| Ulangan 1 | Ulangan 2 | Ulangan 3 | ||||
| 1 | Rani | 80 | 75 | 85 | 240 | 80.0 |
| 2 | Rina | 85 | 90 | 85 | 260 | 86.7 |
| 3 | Irna | 75 | 75 | 75 | 225 | 75.0 |
| 4 | Rian | 60 | 65 | 65 | 190 | 63.3 |
| 5 | Niar | 75 | 80 | 75 | 230 | 76.7 |
| | | | | | | |
| Banyaknya Siswa | | | | | ||
| Total Nilai Tertinggi | | | | | ||
| Rata-rata Nilai Irna | | | | | ||
| Nilai Ulangan Tertinggi Rina | | | | | ||
| Rata-rata Terendah | | | | | ||
| Soal 2 | | | | | ||
| Daftar Nilai Ujian Siswa | | | | | ||
| | Nama | Nilai | Rata-rata | |||
| UH | Tugas | Praktek | UAS | |||
| 121 | Amat | 65 | 60 | 70 | 75 | 67.5 |
| 136 | Imut | 70 | 75 | 70 | 85 | 75.0 |
| 140 | Imit | 85 | 85 | 80 | 65 | 78.8 |
| 143 | Omit | 75 | 70 | 75 | 90 | 77.5 |
| 154 | Amit | 85 | 85 | 90 | 75 | 83.8 |
| | | | | | | |
| Jumlah siswa seluruhnya | | | | |||
| Jumlah siswa yang nilai ujiannya >=80 | | | | |||
| Jumlah siswa yang nilai ujiannya <80 | | | | |||
| Jumlah siswa yang nilai rata-ratanya >=70 | | | | |||
| Nilai Imit yang >=80 | | | | |||
| Nilai tugas yang >= 75 | | | | |||
| Nilai Rata-rata < 76 | | | | |||
| Nilai Praktek Terendah | | | | |||
| | | | | | | |
Pak ga ngerti e. itu nilai ujian maksudnya UH ato uas?
pak ada yg ga bsa post komen
fransiska xaveria 11ipa
I
1. =COUNT(C3:C7)
2. =MAX(F3:F7)
3. =AVERAGE(C5:E5)
4. =MAX(C4:E4)
5. =MIN(G3:G7)
II.
1. =COUNT(A3:A7)
2. =COUNTIF(F3:F7;">=80")
3. =COUNTIF(F3:F7;"<80")
4. =COUNTIF(G3:G7;">=70")
5. =COUNTIF(C5:F5;">=80")
6. =COUNTIF(D3:D7;">=75")
7. =COUNTIF(G3:G7;"<76")
8. =MIN(E3:E7)
Pak kok q g bsa komen ya??
Katry
Soal 1
1. =COUNT(C3:C7)
2. =MAX(F3:F7)
3. =AVERAGE(C5:E5)
4. =MAX(C4:E4)
5. =MIN(G3:G7)
Soal 2
1. =COUNT(A3:A7)
2. =COUNTIF(F3:F7;">=80")
3. =COUNTIF(F3:F7;"<80")
4. =COUNTIF(G3:G7;">=70")
5. =COUNTIF(C5:F5;">=80")
6. =COUNTIF(D3:D7;">=75")
7. =COUNTIF(G3:G7;"<76")
8. =MIN(E3:E7)
Soal 1
1. =COUNT(C3:C7)
2. =MAX(F3:F7)
3. =AVERAGE(C5:E5)
4. =MAX(C4:E4)
5. =MIN(G3:G7)
Soal 2
1. =COUNT(A3:A7)
2. =COUNTIF(F3:F7;">=80")
3. =COUNTIF(F3:F7;"<80")
4. =COUNTIF(G3:G7;">=70")
5. =COUNTIF(C5:F5;">=80")
6. =COUNTIF(D3:D7;">=75")
7. =COUNTIF(G3:G7;"<76")
8. =MIN(E3:E7)
Soal1
1. =COUNT(C3:C7)
2. =MAX(F3:F7)
3. =AVERAGE(C5:E5)
4. =MAX(C4:E4)
5. =MIN(G3:G7)
Soal2
1. =COUNT(C3:C7)
2. =COUNTIF(F3:F7;">=80")
3. =COUNTIF(F3:F7;"<80")
4. =COUNTIF(G3:G7;">=70")
5. =COUNTIF(C5:F5;">=80")
6. =COUNTIF(D3:D7;">=75")
7. =COUNTIF(G3:G7;"<76")
8. =MIN(E3:E7)
From:SUWARMI
Sara
Soal Latihan 1
1. =COUNT(C3:C7)
2. =MAX(F3:F7)
3. =AVERAGE(C5:E5)
4. =MAX(C5:E5)
5. =MIN(G3:G7)
Soal Latihan 2
1. =COUNT(C3:C7)
2. =COUNTIF(F3:F7;">=80")
3. =COUNTIF(F3:F7;"<80")
4. =COUNTIF(G3:G7;">=70")
5. =COUNTIF(C5:F5;">=80")
6. =COUNTIF(D3:D7;">=75")
7. =COUNTIF(G3:G7;"<76")
8. =MIN(E3:E7)
soal 1
1. =COUNT(A7,A8,A9,A10,A11)
2. =MAX(F3,F7)
3. =AVERAGE(C5,E5)
4. =MAX(C4,E4)
5. =MIN(G3G7)
SOAL2
1. =COUNT(C3,C7)
2. =COUNTIF(F3,F7,">=80")
3. =COUNTIF(F3,F7,"<80")
4. =COUNTIF(G3,G7,">=70")
5. =COUNTIF(C5,F5,">=80")
6. =COUNTIF(D3,D7,">=75")
7. =COUNTIF(G3,G7,"<76")
8. =MIN(E3,E7)
Soal1
1. =COUNT(C3:C7)
2. =MAX(F3:F7)
3. =AVERAGE(C5:E5)
4. =MAX(C4:E4)
5. =MIN(G3:G7)
Soal2
1. =COUNT(C3:C7)
2. =COUNTIF(F3:F7;">=80")
3. =COUNTIF(F3:F7;"<80")
4. =COUNTIF(G3:G7;">=70")
5. =COUNTIF(C5:F5;">=80")
6. =COUNTIF(D3:D7;">=75")
7. =COUNTIF(G3:G7;"<76")
8. =MIN(E3:E7)
saking Martinus PUTU ardi
Soal1
1. =COUNT(C3:C7)
2. =MAX(F3:F7)
3. =AVERAGE(C5:E5)
4. =MAX(C4:E4)
5. =MIN(G3:G7)
Soal2
1. =COUNT(C3:C7)
2. =COUNTIF(F3:F7;">=80")
3. =COUNTIF(F3:F7;"<80")
4. =COUNTIF(G3:G7;">=70")
5. =COUNTIF(C5:F5;">=80")
6. =COUNTIF(D3:D7;">=75")
7. =COUNTIF(G3:G7;"<76")
8. =MIN(E3:E7)
from yuliuzh
=> soal 1
1.=COUNT(A3:A7)
2.=MAX(F3:F7)
3.=AVERAGE(C5:E5)
4.=MAX(C4:E4)
5.=MIN(G3:G7)
=> soal 2
1.=COUNT(A29:A33)
2.=COUNTIF(F29:F33;">=80")
3.=COUNTIF(F29:F33;"<80")
4.=COUNTIF(G29:G33;">=70")
5.=COUNTIF(C31:F31;">=80")
6.=COUNTIF(D29:D33;">=75")
7.=COUNTIF(G29:G33;"<76")
8.=MIN(E29:E33)
soal 1
1. =COUNT(C4:C8)
2. =MAX(F4:F8)
3. =AVERAGE(C6:C8)
4. =MAX(C5:E5)
5. =MIN(G4:G8)
SOAL 2
1. =COUNT(C3:C7)
2. =COUNTIF(F3:F7,">=80")
3. =COUNTIF(F3:F7,"<80")
4. =COUNTIF(G3:G7,">=70")
5. =COUNTIF(C5:F5,">80")
6. =COUNTIF(D3:D7,">=75")
7. =COUNTIF(G3:G7,"<76")
8. =MIN(G3:G7)
AKHIRRRNYAAA.....
SOAL 1:
1.=COUNT(A8:A12)
2.=MAX(F8:F12)
3.=AVERAGE(C10:E10)
4.=MAX(C9:E9)
5.=MIN(G8:G12)
SOAL 2 :
1.=COUNT(A8:A12)
2.=COUNTIF(F8:F12;">=80")
3.=COUNTIF(F8:F12;"<80")
4.=COUNTIF(G8:G12;">=70")
5.=COUNTIF(C10:F10;">=80")
6.=COUNTIF(D8:D12;"<76")
7.=COUNTIF(G8:G12;"<76")
8.=MIN(E8:E12)
Terima kasih telah mengerjakan tugas...
1. Siska
2. Katri
3. Kress
4. Vero
5. Sara
6. Desy
7. Yaya....????
8. Putu
9. Tri Wah
10. Agata
11. Santi
12. Seshi
GBU All...